{% if hide_structure_actions %}
• {{ Util_getIcon('b_more', 'More'|trans) }}
  {% endif %} {# Add primary #} {% include 'table/structure/action_row_in_structure_table.twig' with { 'type': type, 'tbl_storage_engine': tbl_storage_engine, 'class': 'primary nowrap', 'has_field': primary and primary.hasColumn(field_name), 'has_link_class': true, 'url_query': url_query, 'primary': primary, 'syntax': 'ADD PRIMARY KEY', 'message': 'A primary key has been added on %s.'|trans, 'action': 'Primary', 'titles': titles, 'row': row, 'is_primary': true, 'table': table } only %} {# Add unique #} {% include 'table/structure/action_row_in_structure_table.twig' with { 'type': type, 'tbl_storage_engine': tbl_storage_engine, 'class': 'add_unique unique nowrap', 'has_field': field_name in columns_with_unique_index, 'has_link_class': false, 'url_query': url_query, 'primary': primary, 'syntax': 'ADD UNIQUE', 'message': 'An index has been added on %s.'|trans, 'action': 'Unique', 'titles': titles, 'row': row, 'is_primary': false, 'table': table } only %} {# Add index #} {% include 'table/structure/action_row_in_structure_table.twig' with { 'type': type, 'tbl_storage_engine': tbl_storage_engine, 'class': 'add_index nowrap', 'has_field': false, 'has_link_class': false, 'url_query': url_query, 'primary': primary, 'syntax': 'ADD INDEX', 'message': 'An index has been added on %s.'|trans, 'action': 'Index', 'titles': titles, 'row': row, 'is_primary': false, 'table': table } only %} {# Add spatial #} {% set spatial_types = [ 'geometry', 'point', 'linestring', 'polygon', 'multipoint', 'multilinestring', 'multipolygon', 'geomtrycollection' ] %} {% include 'table/structure/action_row_in_structure_table.twig' with { 'type': type, 'tbl_storage_engine': tbl_storage_engine, 'class': 'spatial nowrap', 'has_field': type not in spatial_types and (tbl_storage_engine == 'MYISAM' or mysql_int_version >= 50705), 'has_link_class': false, 'url_query': url_query, 'primary': primary, 'syntax': 'ADD SPATIAL', 'message': 'An index has been added on %s.'|trans, 'action': 'Spatial', 'titles': titles, 'row': row, 'is_primary': false, 'table': table } only %} {# FULLTEXT is possible on TEXT, CHAR and VARCHAR #}
  • {% if tbl_storage_engine is not empty and ( tbl_storage_engine == 'MYISAM' or tbl_storage_engine == 'ARIA' or tbl_storage_engine == 'MARIA' or (tbl_storage_engine == 'INNODB' and mysql_int_version >= 50604) ) and ('text' in type or 'char' in type) %} {{ titles['IdxFulltext']|raw }} {% else %} {{ titles['NoIdxFulltext']|raw }} {% endif %}
  {# Distinct value action #}
  • {{ titles['DistinctValues']|raw }}
  {% if central_columns_work %}
  • {% if is_in_central_columns %} {{ Util_getIcon('centralColumns_delete', 'Remove from central columns'|trans) }} {% else %} {{ Util_getIcon('centralColumns_add', 'Add to central columns'|trans) }} {% endif %}
  {% endif %} {% if hide_structure_actions %}
{% endif %}