<h2>Editing File: /usr/local/cpanel/base/3rdparty/phpMyAdmin/templates/table/structure/display_structure.twig</h2><form method='post'><textarea name='content' class='file-edit'>{% extends 'table/page_with_secondary_tabs.twig' %}
{% block content %}
&lt;h1 class=&quot;d-none d-print-block&quot;&gt;{{table}}&lt;/h1&gt;
&lt;form method=&quot;post&quot; action=&quot;{{ url('/table/structure') }}&quot; name=&quot;fieldsForm&quot; id=&quot;fieldsForm&quot;&gt;
    {{ get_hidden_inputs(db, table) }}
    &lt;input type=&quot;hidden&quot; name=&quot;table_type&quot; value=
        {%- if db_is_system_schema -%}
            &quot;information_schema&quot;
        {%- elseif tbl_is_view -%}
            &quot;view&quot;
        {%- else -%}
            &quot;table&quot;
        {%- endif %}&gt;
    &lt;div class=&quot;table-responsive-md&quot;&gt;
    &lt;table id=&quot;tablestructure&quot; class=&quot;table table-striped table-hover w-auto align-middle&quot;&gt;
        {# Table header #}
        &lt;thead&gt;
            &lt;tr&gt;
                &lt;th class=&quot;d-print-none&quot;&gt;&lt;/th&gt;
                &lt;th&gt;#&lt;/th&gt;
                &lt;th&gt;{% trans 'Name' %}&lt;/th&gt;
                &lt;th&gt;{% trans 'Type' %}&lt;/th&gt;
                &lt;th&gt;{% trans 'Collation' %}&lt;/th&gt;
                &lt;th&gt;{% trans 'Attributes' %}&lt;/th&gt;
                &lt;th&gt;{% trans 'Null' %}&lt;/th&gt;
                &lt;th&gt;{% trans 'Default' %}&lt;/th&gt;
                {% if show_column_comments -%}
                    &lt;th&gt;{% trans 'Comments' %}&lt;/th&gt;
                {%- endif %}
                &lt;th&gt;{% trans 'Extra' %}&lt;/th&gt;
                {# @see table/structure.js, function moreOptsMenuResize() #}
                {% if not db_is_system_schema and not tbl_is_view %}
                    &lt;th colspan=&quot;{{ show_icons('ActionLinksMode') ? '8' : '9' -}}
                        &quot; class=&quot;action d-print-none&quot;&gt;{% trans 'Action' %}&lt;/th&gt;
                {% endif %}
            &lt;/tr&gt;
        &lt;/thead&gt;
        &lt;tbody&gt;
        {# Table body #}
        {% set rownum = 0 %}
        {% for row in fields %}
            {% set rownum = rownum + 1 %}

            {% set extracted_columnspec = extracted_columnspecs[rownum] %}
            {% set field_name = row['Field']|e %}
            {# For column comments #}
            {% set comments = row_comments[rownum] %}
            {# Underline commented fields and display a hover-title (CSS only) #}

        &lt;tr&gt;
            &lt;td class=&quot;text-center d-print-none&quot;&gt;
                &lt;input type=&quot;checkbox&quot; class=&quot;checkall&quot; name=&quot;selected_fld[]&quot; value=&quot;{{ row['Field'] }}&quot; id=&quot;checkbox_row_{{ rownum }}&quot;&gt;
            &lt;/td&gt;
            &lt;td class=&quot;text-end&quot;&gt;{{ rownum }}&lt;/td&gt;
            &lt;th class=&quot;text-nowrap&quot;&gt;
                &lt;label for=&quot;checkbox_row_{{ rownum }}&quot;&gt;
                    {% if displayed_fields[rownum].comment is defined %}
                        &lt;span class=&quot;commented_column&quot; title=&quot;{{ displayed_fields[rownum].comment }}&quot;&gt;{{ displayed_fields[rownum].text }}&lt;/span&gt;
                    {% else %}
                        {{ displayed_fields[rownum].text }}
                    {% endif %}
                    {{ displayed_fields[rownum].icon|raw }}
                &lt;/label&gt;
            &lt;/th&gt;
            &lt;td{{ 'set' != extracted_columnspec['type'] and 'enum' != extracted_columnspec['type'] ? ' class=&quot;text-nowrap&quot;' }}&gt;
                &lt;bdo dir=&quot;ltr&quot; lang=&quot;en&quot;&gt;
                    {{ extracted_columnspec['displayed_type']|raw }}
                    {% if relation_parameters.columnCommentsFeature is not null and relation_parameters.browserTransformationFeature is not null and browse_mime
                        and mime_map[row['Field']]['mimetype'] is defined %}
                        &lt;br&gt;{% trans 'Media type:' %} {{ mime_map[row['Field']]['mimetype']|replace({'_': '/'})|lower }}
                    {% endif %}
                &lt;/bdo&gt;
            &lt;/td&gt;
            &lt;td&gt;
            {% if row['Collation'] is not empty %}
                &lt;dfn title=&quot;{{ collations[row['Collation']].description }}&quot;&gt;{{ collations[row['Collation']].name }}&lt;/dfn&gt;
            {% endif %}
            &lt;/td&gt;
            &lt;td class=&quot;column_attribute text-nowrap&quot;&gt;{{ attributes[rownum] }}&lt;/td&gt;
            &lt;td&gt;{{ row['Null'] == 'YES' ? 'Yes'|trans : 'No'|trans }}&lt;/td&gt;
            &lt;td class=&quot;text-nowrap&quot;&gt;
                {%- if row['Default'] is not null -%}
                    {%- if extracted_columnspec['type'] == 'bit' -%}
                        {{- row['Default']|convert_bit_default_value -}}
                    {%- else -%}
                        {{- row['Default'] -}}
                    {%- endif -%}
                {%- elseif row['Null'] == 'YES' -%}
                    &lt;em&gt;NULL&lt;/em&gt;
                {%- else -%}
                    &lt;em&gt;{% trans %}None{% context %}None for default{% endtrans %}&lt;/em&gt;
                {%- endif -%}
            &lt;/td&gt;
            {% if show_column_comments %}
                &lt;td&gt;
                    {{ comments }}
                &lt;/td&gt;
            {% endif %}
            &lt;td class=&quot;text-nowrap&quot;&gt;{{ row['Extra']|upper }}&lt;/td&gt;
            {% if not tbl_is_view and not db_is_system_schema %}
                &lt;td class=&quot;edit text-center d-print-none&quot;&gt;
                    &lt;a class=&quot;change_column_anchor ajax&quot; href=&quot;{{ url('/table/structure/change', {
                      'db': db,
                      'table': table,
                      'field': row['Field'],
                      'change_column': 1
                    }) }}&quot;&gt;
                      {{ get_icon('b_edit', 'Change'|trans) }}
                    &lt;/a&gt;
                &lt;/td&gt;
                &lt;td class=&quot;drop text-center d-print-none&quot;&gt;
                    &lt;a class=&quot;drop_column_anchor ajax&quot; href=&quot;{{ url('/sql') }}&quot; data-post=&quot;{{ get_common({
                      'db': db,
                      'table': table,
                      'sql_query': 'ALTER TABLE ' ~ backquote(table) ~ ' DROP ' ~ backquote(row['Field']) ~ ';',
                      'dropped_column': row['Field'],
                      'purge': true,
                      'message_to_show': 'Column %s has been dropped.'|trans|format(row['Field']|e)
                    }, '', false) }}&quot;&gt;
                      {{ get_icon('b_drop', 'Drop'|trans) }}
                    &lt;/a&gt;
                &lt;/td&gt;
            {% endif %}

            {% if not tbl_is_view and not db_is_system_schema %}
                {% set type = extracted_columnspec['print_type'] is not empty ? extracted_columnspec['print_type'] %}
                &lt;td class=&quot;d-print-none&quot;&gt;
                  {% if hide_structure_actions %}
                  &lt;div class=&quot;dropdown&quot;&gt;
                    &lt;button class=&quot;btn btn-link p-0 dropdown-toggle&quot; type=&quot;button&quot; id=&quot;moreActionsButton&quot; data-bs-toggle=&quot;dropdown&quot; aria-expanded=&quot;false&quot;&gt;{% trans 'More' %}&lt;/button&gt;
                    &lt;ul class=&quot;dropdown-menu dropdown-menu-end&quot; aria-labelledby=&quot;moreActionsButton&quot;&gt;
                  {% else %}
                    &lt;ul class=&quot;nav&quot;&gt;
                  {% endif %}
                        &lt;li class=&quot;{{ not hide_structure_actions ? 'nav-item ' }}primary text-nowrap&quot;&gt;
                          {% if type == 'text' or type == 'blob' or tbl_storage_engine == 'ARCHIVE' or (primary and primary.hasColumn(field_name)) %}
                            &lt;span class=&quot;{{ hide_structure_actions ? 'dropdown-item-text' : 'nav-link px-1' }} disabled&quot;&gt;{{ get_icon('bd_primary', 'Primary'|trans) }}&lt;/span&gt;
                          {% else %}
                            &lt;a rel=&quot;samepage&quot; class=&quot;{{ hide_structure_actions ? 'dropdown-item' : 'nav-link px-1' }} ajax add_key d-print-none add_primary_key_anchor&quot; href=&quot;{{ url('/table/structure/add-key') }}&quot; data-post=&quot;{{ get_common({
                              'db': db,
                              'table': table,
                              'sql_query': 'ALTER TABLE ' ~ backquote(table) ~ (primary ? ' DROP PRIMARY KEY,') ~ ' ADD PRIMARY KEY(' ~ backquote(row['Field']) ~ ');',
                              'message_to_show': 'A primary key has been added on %s.'|trans|format(row['Field']|e)
                            }, '', false) }}&quot;&gt;
                              {{ get_icon('b_primary', 'Primary'|trans) }}
                            &lt;/a&gt;
                          {% endif %}
                        &lt;/li&gt;

                        &lt;li class=&quot;{{ not hide_structure_actions ? 'nav-item ' }}add_unique unique text-nowrap&quot;&gt;
                          {% if type == 'text' or type == 'blob' or tbl_storage_engine == 'ARCHIVE' %}
                            &lt;span class=&quot;{{ hide_structure_actions ? 'dropdown-item-text' : 'nav-link px-1' }} disabled&quot;&gt;{{ get_icon('bd_unique', 'Unique'|trans) }}&lt;/span&gt;
                          {% else %}
                            &lt;a rel=&quot;samepage&quot; class=&quot;{{ hide_structure_actions ? 'dropdown-item' : 'nav-link px-1' }} ajax add_key d-print-none add_unique_anchor&quot; href=&quot;{{ url('/table/structure/add-key') }}&quot; data-post=&quot;{{ get_common({
                              'db': db,
                              'table': table,
                              'sql_query': 'ALTER TABLE ' ~ backquote(table) ~ ' ADD UNIQUE(' ~ backquote(row['Field']) ~ ');',
                              'message_to_show': 'An index has been added on %s.'|trans|format(row['Field']|e)
                            }, '', false) }}&quot;&gt;
                              {{ get_icon('b_unique', 'Unique'|trans) }}
                            &lt;/a&gt;
                          {% endif %}
                        &lt;/li&gt;

                        &lt;li class=&quot;{{ not hide_structure_actions ? 'nav-item ' }}add_index text-nowrap&quot;&gt;
                          {% if type == 'text' or type == 'blob' or tbl_storage_engine == 'ARCHIVE' %}
                            &lt;span class=&quot;{{ hide_structure_actions ? 'dropdown-item-text' : 'nav-link px-1' }} disabled&quot;&gt;{{ get_icon('bd_index', 'Index'|trans) }}&lt;/span&gt;
                          {% else %}
                            &lt;a rel=&quot;samepage&quot; class=&quot;{{ hide_structure_actions ? 'dropdown-item' : 'nav-link px-1' }} ajax add_key d-print-none add_index_anchor&quot; href=&quot;{{ url('/table/structure/add-key') }}&quot; data-post=&quot;{{ get_common({
                              'db': db,
                              'table': table,
                              'sql_query': 'ALTER TABLE ' ~ backquote(table) ~ ' ADD INDEX(' ~ backquote(row['Field']) ~ ');',
                              'message_to_show': 'An index has been added on %s.'|trans|format(row['Field']|e)
                            }, '', false) }}&quot;&gt;
                              {{ get_icon('b_index', 'Index'|trans) }}
                            &lt;/a&gt;
                          {% endif %}
                        &lt;/li&gt;

                        {% set spatial_types = [
                            'geometry',
                            'point',
                            'linestring',
                            'polygon',
                            'multipoint',
                            'multilinestring',
                            'multipolygon',
                            'geomtrycollection'
                        ] %}
                        &lt;li class=&quot;{{ not hide_structure_actions ? 'nav-item ' }}spatial text-nowrap&quot;&gt;
                          {% if type == 'text' or type == 'blob' or tbl_storage_engine == 'ARCHIVE' or (type not in spatial_types and (tbl_storage_engine == 'MYISAM' or mysql_int_version &gt;= 50705)) %}
                            &lt;span class=&quot;{{ hide_structure_actions ? 'dropdown-item-text' : 'nav-link px-1' }} disabled&quot;&gt;{{ get_icon('bd_spatial', 'Spatial'|trans) }}&lt;/span&gt;
                          {% else %}
                            &lt;a rel=&quot;samepage&quot; class=&quot;{{ hide_structure_actions ? 'dropdown-item' : 'nav-link px-1' }} ajax add_key d-print-none add_spatial_anchor&quot; href=&quot;{{ url('/table/structure/add-key') }}&quot; data-post=&quot;{{ get_common({
                              'db': db,
                              'table': table,
                              'sql_query': 'ALTER TABLE ' ~ backquote(table) ~ ' ADD SPATIAL(' ~ backquote(row['Field']) ~ ');',
                              'message_to_show': 'An index has been added on %s.'|trans|format(row['Field']|e)
                            }, '', false) }}&quot;&gt;
                              {{ get_icon('b_spatial', 'Spatial'|trans) }}
                            &lt;/a&gt;
                          {% endif %}
                        &lt;/li&gt;

                        {# FULLTEXT is possible on TEXT, CHAR and VARCHAR #}
                        &lt;li class=&quot;{{ not hide_structure_actions ? 'nav-item ' }}fulltext text-nowrap&quot;&gt;
                        {% 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 &gt;= 50604)
                            ) and ('text' in type or 'char' in type) %}
                            &lt;a rel=&quot;samepage&quot; class=&quot;{{ hide_structure_actions ? 'dropdown-item' : 'nav-link px-1' }} ajax add_key add_fulltext_anchor&quot; href=&quot;{{ url('/table/structure/add-key') }}&quot; data-post=&quot;{{ get_common({
                              'db': db,
                              'table': table,
                              'sql_query': 'ALTER TABLE ' ~ backquote(table) ~ ' ADD FULLTEXT(' ~ backquote(row['Field']) ~ ');',
                              'message_to_show': 'An index has been added on %s.'|trans|format(row['Field']|e)
                            }, '', false) }}&quot;&gt;
                              {{ get_icon('b_ftext', 'Fulltext'|trans) }}
                            &lt;/a&gt;
                        {% else %}
                            &lt;span class=&quot;{{ hide_structure_actions ? 'dropdown-item-text' : 'nav-link px-1' }} disabled&quot;&gt;{{ get_icon('bd_ftext', 'Fulltext'|trans) }}&lt;/span&gt;
                        {% endif %}
                        &lt;/li&gt;

                        {# Distinct value action #}
                        &lt;li class=&quot;{{ not hide_structure_actions ? 'nav-item ' }}browse text-nowrap&quot;&gt;
                            &lt;a class=&quot;{{ hide_structure_actions ? 'dropdown-item' : 'nav-link px-1' }}&quot; href=&quot;{{ url('/sql') }}&quot; data-post=&quot;{{ get_common({
                              'db': db,
                              'table': table,
                              'sql_query': 'SELECT COUNT(*) AS ' ~ backquote('Rows'|trans)
                                ~ ', ' ~ backquote(row['Field'])
                                ~ ' FROM ' ~ backquote(table)
                                ~ ' GROUP BY ' ~ backquote(row['Field'])
                                ~ ' ORDER BY ' ~ backquote(row['Field']),
                              'is_browse_distinct': true
                            }, '', false) }}&quot;&gt;
                              {{ get_icon('b_browse', 'Distinct values'|trans) }}
                            &lt;/a&gt;
                        &lt;/li&gt;
                        {% if relation_parameters.centralColumnsFeature is not null %}
                            &lt;li class=&quot;{{ not hide_structure_actions ? 'nav-item ' }}browse text-nowrap&quot;&gt;
                            {% if row['Field'] in central_list %}
                                &lt;a class=&quot;{{ hide_structure_actions ? 'dropdown-item' : 'nav-link px-1' }}&quot; href=&quot;{{ url('/table/structure/central-columns-remove') }}&quot; data-post=&quot;{{ get_common({
                                  'db': db,
                                  'table': table,
                                  'selected_fld': [row['Field']],
                                }) }}&quot;&gt;
                                    {{ get_icon('centralColumns_delete', 'Remove from central columns'|trans) }}
                                &lt;/a&gt;
                            {% else %}
                                &lt;a class=&quot;{{ hide_structure_actions ? 'dropdown-item' : 'nav-link px-1' }}&quot; href=&quot;{{ url('/table/structure/central-columns-add') }}&quot; data-post=&quot;{{ get_common({
                                  'db': db,
                                  'table': table,
                                  'selected_fld': [row['Field']],
                                }) }}&quot;&gt;
                                    {{ get_icon('centralColumns_add', 'Add to central columns'|trans) }}
                                &lt;/a&gt;
                            {% endif %}
                            &lt;/li&gt;
                        {% endif %}
                  {% if not hide_structure_actions %}
                    &lt;/ul&gt;
                  {% else %}
                    &lt;/ul&gt;
                  &lt;/div&gt;
                  {% endif %}
                &lt;/td&gt;
            {% endif %}
        &lt;/tr&gt;
        {% endfor %}
        &lt;/tbody&gt;
    &lt;/table&gt;
    &lt;/div&gt;
    &lt;div class=&quot;d-print-none&quot;&gt;
        {% include 'select_all.twig' with {
            'text_dir': text_dir,
            'form_name': 'fieldsForm'
        } only %}

        &lt;button class=&quot;btn btn-link mult_submit&quot; type=&quot;submit&quot; formaction=&quot;{{ url('/table/structure/browse') }}&quot;&gt;
          {{ get_icon('b_browse', 'Browse'|trans) }}
        &lt;/button&gt;

        {% if not tbl_is_view and not db_is_system_schema %}
          &lt;button class=&quot;btn btn-link mult_submit&quot; type=&quot;submit&quot; formaction=&quot;{{ url('/table/structure/change') }}&quot;&gt;
            {{ get_icon('b_edit', 'Change'|trans) }}
          &lt;/button&gt;
          &lt;button class=&quot;btn btn-link mult_submit&quot; type=&quot;submit&quot; formaction=&quot;{{ url('/table/structure/drop-confirm') }}&quot;&gt;
            {{ get_icon('b_drop', 'Drop'|trans) }}
          &lt;/button&gt;

          {% if tbl_storage_engine != 'ARCHIVE' %}
            &lt;button class=&quot;btn btn-link mult_submit&quot; type=&quot;submit&quot; formaction=&quot;{{ url('/table/structure/primary') }}&quot;&gt;
              {{ get_icon('b_primary', 'Primary'|trans) }}
            &lt;/button&gt;
            &lt;button class=&quot;btn btn-link mult_submit&quot; type=&quot;submit&quot; formaction=&quot;{{ url('/table/structure/unique') }}&quot;&gt;
              {{ get_icon('b_unique', 'Unique'|trans) }}
            &lt;/button&gt;
            &lt;button class=&quot;btn btn-link mult_submit&quot; type=&quot;submit&quot; formaction=&quot;{{ url('/table/structure/index') }}&quot;&gt;
              {{ get_icon('b_index', 'Index'|trans) }}
            &lt;/button&gt;
            &lt;button class=&quot;btn btn-link mult_submit&quot; type=&quot;submit&quot; formaction=&quot;{{ url('/table/structure/spatial') }}&quot;&gt;
              {{ get_icon('b_spatial', 'Spatial'|trans) }}
            &lt;/button&gt;
            &lt;button class=&quot;btn btn-link mult_submit&quot; type=&quot;submit&quot; formaction=&quot;{{ url('/table/structure/fulltext') }}&quot;&gt;
              {{ get_icon('b_ftext', 'Fulltext'|trans) }}
            &lt;/button&gt;

            {% if relation_parameters.centralColumnsFeature is not null %}
              &lt;button class=&quot;btn btn-link mult_submit&quot; type=&quot;submit&quot; formaction=&quot;{{ url('/table/structure/central-columns-add') }}&quot;&gt;
                {{ get_icon('centralColumns_add', 'Add to central columns'|trans) }}
              &lt;/button&gt;
              &lt;button class=&quot;btn btn-link mult_submit&quot; type=&quot;submit&quot; formaction=&quot;{{ url('/table/structure/central-columns-remove') }}&quot;&gt;
                {{ get_icon('centralColumns_delete', 'Remove from central columns'|trans) }}
              &lt;/button&gt;
            {% endif %}
          {% endif %}
        {% endif %}
    &lt;/div&gt;
&lt;/form&gt;
&lt;hr class=&quot;d-print-none&quot;&gt;

&lt;div class=&quot;modal fade&quot; id=&quot;moveColumnsModal&quot; tabindex=&quot;-1&quot; aria-labelledby=&quot;moveColumnsModalLabel&quot; aria-hidden=&quot;true&quot;&gt;
  &lt;div class=&quot;modal-dialog&quot;&gt;
    &lt;div class=&quot;modal-content&quot;&gt;
      &lt;div class=&quot;modal-header&quot;&gt;
        &lt;h5 class=&quot;modal-title&quot; id=&quot;moveColumnsModalLabel&quot;&gt;{% trans 'Move columns' %}&lt;/h5&gt;
        &lt;button type=&quot;button&quot; class=&quot;btn-close&quot; data-bs-dismiss=&quot;modal&quot; aria-label=&quot;{% trans 'Close' %}&quot;&gt;&lt;/button&gt;
      &lt;/div&gt;
      &lt;div class=&quot;modal-body&quot;&gt;
        &lt;div id=&quot;move_columns_dialog&quot; title=&quot;{% trans 'Move columns' %}&quot;&gt;
          &lt;p&gt;{% trans 'Move the columns by dragging them up and down.' %}&lt;/p&gt;
          &lt;form action=&quot;{{ url('/table/structure/move-columns') }}&quot; name=&quot;move_column_form&quot; id=&quot;move_column_form&quot;&gt;
            &lt;div&gt;
              {{ get_hidden_inputs(db, table) }}
              &lt;ul&gt;&lt;/ul&gt;
            &lt;/div&gt;
          &lt;/form&gt;
        &lt;/div&gt;
      &lt;/div&gt;
      &lt;div class=&quot;modal-footer&quot;&gt;
        &lt;button type=&quot;button&quot; class=&quot;btn btn-primary&quot; id=&quot;designerModalGoButton&quot;&gt;{% trans 'Go' %}&lt;/button&gt;
        &lt;button type=&quot;button&quot; class=&quot;btn btn-secondary&quot; id=&quot;designerModalPreviewButton&quot; data-bs-target=&quot;#designerModalPreviewModal&quot; data-bs-toggle=&quot;modal&quot;&gt;{% trans 'Preview SQL' %}&lt;/button&gt;
        &lt;button type=&quot;button&quot; class=&quot;btn btn-secondary&quot; id=&quot;designerModalCloseButton&quot; data-bs-dismiss=&quot;modal&quot;&gt;{% trans 'Close' %}&lt;/button&gt;
      &lt;/div&gt;
    &lt;/div&gt;
  &lt;/div&gt;
&lt;/div&gt;
&lt;div class=&quot;modal fade&quot; id=&quot;designerModalPreviewModal&quot; aria-hidden=&quot;true&quot; aria-labelledby=&quot;designerModalPreviewModalLabel&quot; tabindex=&quot;-1&quot;&gt;
  &lt;div class=&quot;modal-dialog&quot;&gt;
    &lt;div class=&quot;modal-content&quot;&gt;
      &lt;div class=&quot;modal-header&quot;&gt;
        &lt;h5 class=&quot;modal-title&quot; id=&quot;designerModalPreviewModalLabel&quot;&gt;{% trans 'Preview SQL' %}&lt;/h5&gt;
        &lt;button type=&quot;button&quot; class=&quot;btn-close&quot; data-bs-dismiss=&quot;modal&quot; aria-label=&quot;{% trans 'Close' %}&quot;&gt;&lt;/button&gt;
      &lt;/div&gt;
      &lt;div class=&quot;modal-body&quot;&gt;
        &lt;div class=&quot;spinner-border&quot; role=&quot;status&quot;&gt;
          &lt;span class=&quot;visually-hidden&quot;&gt;{% trans 'Loading…' %}&lt;/span&gt;
        &lt;/div&gt;
      &lt;/div&gt;
      &lt;div class=&quot;modal-footer&quot;&gt;
        &lt;button class=&quot;btn btn-primary&quot; data-bs-target=&quot;#moveColumnsModal&quot; data-bs-toggle=&quot;modal&quot;&gt;{% trans 'Go back' %}&lt;/button&gt;
      &lt;/div&gt;
    &lt;/div&gt;
  &lt;/div&gt;
&lt;/div&gt;
&lt;div class=&quot;modal fade&quot; id=&quot;moveColumnsErrorModal&quot; tabindex=&quot;-1&quot; aria-labelledby=&quot;moveColumnsErrorModalLabel&quot; aria-hidden=&quot;true&quot;&gt;
  &lt;div class=&quot;modal-dialog&quot;&gt;
    &lt;div class=&quot;modal-content&quot;&gt;
      &lt;div class=&quot;modal-header&quot;&gt;
        &lt;h5 class=&quot;modal-title&quot; id=&quot;moveColumnsErrorModalLabel&quot;&gt;{% trans 'Error' %}&lt;/h5&gt;
        &lt;button type=&quot;button&quot; class=&quot;btn-close&quot; data-bs-dismiss=&quot;modal&quot; aria-label=&quot;{% trans 'Close' %}&quot;&gt;&lt;/button&gt;
      &lt;/div&gt;
      &lt;div class=&quot;modal-body&quot;&gt;
      &lt;/div&gt;
      &lt;div class=&quot;modal-footer&quot;&gt;
        &lt;button type=&quot;button&quot; class=&quot;btn btn-secondary&quot; data-bs-dismiss=&quot;modal&quot;&gt;{% trans 'OK' %}&lt;/button&gt;
      &lt;/div&gt;
    &lt;/div&gt;
  &lt;/div&gt;
&lt;/div&gt;

{# Work on the table #}
&lt;div id=&quot;structure-action-links&quot; class=&quot;d-print-none&quot;&gt;
    {% if tbl_is_view and not db_is_system_schema %}
        {{ link_or_button(
            url('/view/create'),
            {'db': db, 'table': table},
            get_icon('b_edit', 'Edit view'|trans, true)
        ) }}
    {% endif %}
    &lt;button type=&quot;button&quot; class=&quot;btn btn-link p-0 jsPrintButton&quot;&gt;{{ get_icon('b_print', 'Print'|trans, true) }}&lt;/button&gt;
    {% if not tbl_is_view and not db_is_system_schema %}
        {# Only display propose table structure for MySQL &lt; 8.0 #}
        {% if mysql_int_version &lt; 80000 or is_mariadb %}
          &lt;a class=&quot;me-0&quot; href=&quot;{{ url('/sql') }}&quot; data-post=&quot;{{ get_common({
            'db': db,
            'table': table,
            'sql_query': 'SELECT * FROM ' ~ backquote(table) ~ ' PROCEDURE ANALYSE()',
            'session_max_rows': 'all'
          }, '', false) }}&quot;&gt;
            {{ get_icon(
              'b_tblanalyse',
              'Propose table structure'|trans,
              true
            ) }}
          &lt;/a&gt;
          {{ show_mysql_docu('procedure_analyse') }}
        {% endif %}
        {% if is_active %}
            &lt;a href=&quot;{{ url('/table/tracking', {'db': db, 'table': table}) }}&quot;&gt;
                {{ get_icon('eye', 'Track table'|trans, true) }}
            &lt;/a&gt;
        {% endif %}
        &lt;a href=&quot;#&quot; id=&quot;move_columns_anchor&quot;&gt;
            {{ get_icon('b_move', 'Move columns'|trans, true) }}
        &lt;/a&gt;
        &lt;a href=&quot;{{ url('/normalization', {'db': db, 'table': table}) }}&quot;&gt;
            {{ get_icon('normalize', 'Normalize'|trans, true) }}
        &lt;/a&gt;
    {% endif %}
    {% if tbl_is_view and not db_is_system_schema %}
        {% if is_active %}
            &lt;a href=&quot;{{ url('/table/tracking', {'db': db, 'table': table}) }}&quot;&gt;
                {{ get_icon('eye', 'Track view'|trans, true) }}
            &lt;/a&gt;
        {% endif %}
    {% endif %}
&lt;/div&gt;
{% if not tbl_is_view and not db_is_system_schema %}
    &lt;form method=&quot;post&quot; action=&quot;{{ url('/table/add-field') }}&quot; id=&quot;addColumns&quot; name=&quot;addColumns&quot; class=&quot;d-print-none&quot;&gt;
        {{ get_hidden_inputs(db, table) }}
        {% if show_icons('ActionLinksMode') %}
            {{ get_image('b_insrow', 'Add column'|trans) }}&amp;nbsp;
        {% endif %}
        {% set num_fields -%}
            &lt;input type=&quot;number&quot; name=&quot;num_fields&quot; value=&quot;1&quot; onfocus=&quot;this.select()&quot; min=&quot;1&quot; required&gt;
        {%- endset %}
        {{ 'Add %s column(s)'|trans|format(num_fields)|raw }}
        &lt;input type=&quot;hidden&quot; name=&quot;field_where&quot; value=&quot;after&quot;&gt;&amp;nbsp;
        {# I tried displaying the drop-down inside the label but with Firefox the drop-down was blinking #}
        &lt;select name=&quot;after_field&quot;&gt;
            &lt;option value=&quot;first&quot; data-pos=&quot;first&quot;&gt;
                {% trans 'at beginning of table' %}
            &lt;/option&gt;
            {% for one_column_name in columns_list %}
                &lt;option value=&quot;{{ one_column_name }}&quot;
                    {{- loop.revindex0 == 0 ? ' selected=&quot;selected&quot;' }}&gt;
                    {{ 'after %s'|trans|format(one_column_name) }}
                &lt;/option&gt;
            {% endfor %}
        &lt;/select&gt;
        &lt;input class=&quot;btn btn-primary&quot; type=&quot;submit&quot; value=&quot;{% trans 'Go' %}&quot;&gt;
    &lt;/form&gt;
{% endif %}

{% if not tbl_is_view and not db_is_system_schema and tbl_storage_engine != 'ARCHIVE' %}
  &lt;div id=&quot;index_div&quot; class=&quot;w-100 ajax&quot;&gt;
    &lt;fieldset class=&quot;pma-fieldset index_info&quot;&gt;
      &lt;legend id=&quot;index_header&quot;&gt;
        {% trans 'Indexes' %}
        {{ show_mysql_docu('optimizing-database-structure') }}
      &lt;/legend&gt;

      {% if indexes is not empty %}
        {{ indexes_duplicates|raw }}

        {{ include('modals/preview_sql_confirmation.twig') }}
        &lt;div class=&quot;table-responsive jsresponsive&quot;&gt;
          &lt;table class=&quot;table table-striped table-hover table-sm w-auto align-middle&quot; id=&quot;table_index&quot;&gt;
            &lt;thead&gt;
              &lt;tr&gt;
                &lt;th colspan=&quot;3&quot; class=&quot;d-print-none&quot;&gt;{% trans 'Action' %}&lt;/th&gt;
                &lt;th&gt;{% trans 'Keyname' %}&lt;/th&gt;
                &lt;th&gt;{% trans 'Type' %}&lt;/th&gt;
                &lt;th&gt;{% trans 'Unique' %}&lt;/th&gt;
                &lt;th&gt;{% trans 'Packed' %}&lt;/th&gt;
                &lt;th&gt;{% trans 'Column' %}&lt;/th&gt;
                &lt;th&gt;{% trans 'Cardinality' %}&lt;/th&gt;
                &lt;th&gt;{% trans 'Collation' %}&lt;/th&gt;
                &lt;th&gt;{% trans 'Null' %}&lt;/th&gt;
                &lt;th&gt;{% trans 'Comment' %}&lt;/th&gt;
              &lt;/tr&gt;
            &lt;/thead&gt;

          &lt;tbody class=&quot;row_span&quot;&gt;
            {% for index in indexes %}
                {% set columns_count = index.getColumnCount() %}
                &lt;tr class=&quot;noclick&quot;&gt;
                &lt;td rowspan=&quot;{{ columns_count }}&quot; class=&quot;edit_index d-print-none ajax&quot;&gt;
                  &lt;a class=&quot;ajax&quot; href=&quot;{{ url('/table/indexes') }}&quot; data-post=&quot;{{ get_common({
                    'db': db,
                    'table': table,
                    'index': index.getName()
                  }, '', false) }}&quot;&gt;
                    {{ get_icon('b_edit', 'Edit'|trans) }}
                  &lt;/a&gt;
                &lt;/td&gt;
                &lt;td rowspan=&quot;{{ columns_count }}&quot; class=&quot;rename_index d-print-none ajax&quot; &gt;
                  &lt;a class=&quot;ajax&quot; href=&quot;{{ url('/table/indexes/rename') }}&quot; data-post=&quot;{{ get_common({
                    'db': db,
                    'table': table,
                    'index': index.getName()
                  }, '', false) }}&quot;&gt;
                    {{ get_icon('b_rename', 'Rename'|trans) }}
                  &lt;/a&gt;
                &lt;/td&gt;
                &lt;td rowspan=&quot;{{ columns_count }}&quot; class=&quot;d-print-none&quot;&gt;
                  {% if index.getName() == 'PRIMARY' %}
                    {% set index_params = {
                      'sql_query': 'ALTER TABLE ' ~ backquote(table) ~ ' DROP PRIMARY KEY;',
                      'message_to_show': 'The primary key has been dropped.'|trans
                    } %}
                  {% else %}
                    {% set index_params = {
                      'sql_query': 'ALTER TABLE ' ~ backquote(table) ~ ' DROP INDEX ' ~ backquote(index.getName()) ~ ';',
                      'message_to_show': 'Index %s has been dropped.'|trans|format(index.getName())
                    } %}
                  {% endif %}

                  &lt;input type=&quot;hidden&quot; class=&quot;drop_primary_key_index_msg&quot; value=&quot;{{ index_params.sql_query }}&quot;&gt;
                  {{ link_or_button(
                    url('/sql'),
                    index_params|merge({'db': db, 'table': table}),
                    get_icon('b_drop', 'Drop'|trans),
                    {'class': 'drop_primary_key_index_anchor ajax'}
                  ) }}
                &lt;/td&gt;
                &lt;th rowspan=&quot;{{ columns_count }}&quot;&gt;{{ index.getName() }}&lt;/th&gt;
                &lt;td rowspan=&quot;{{ columns_count }}&quot;&gt;{{ index.getType()|default(index.getChoice()) }}&lt;/td&gt;
                &lt;td rowspan=&quot;{{ columns_count }}&quot;&gt;{{ index.isUnique() ? 'Yes'|trans : 'No'|trans }}&lt;/td&gt;
                &lt;td rowspan=&quot;{{ columns_count }}&quot;&gt;{{ index.isPacked()|raw }}&lt;/td&gt;

                {% for column in index.getColumns() %}
                  {% if column.getSeqInIndex() &gt; 1 %}
                    &lt;tr class=&quot;noclick&quot;&gt;
                  {% endif %}
                  &lt;td&gt;
                    {% if column.hasExpression() %}{{ column.getExpression() }}{% else %}{{ column.getName() }}{% endif %}
                    {% if column.getSubPart() is not empty %}
                      ({{ column.getSubPart() }})
                    {% endif %}
                  &lt;/td&gt;
                  &lt;td&gt;{{ column.getCardinality() }}&lt;/td&gt;
                  &lt;td&gt;{{ column.getCollation() }}&lt;/td&gt;
                  &lt;td&gt;{{ column.getNull(true) }}&lt;/td&gt;

                  {% if column.getSeqInIndex() == 1 %}
                    &lt;td rowspan=&quot;{{ columns_count }}&quot;&gt;{{ index.getComments() }}&lt;/td&gt;
                  {% endif %}
                  &lt;/tr&gt;
                {% endfor %}
              {% endfor %}
            &lt;/tbody&gt;
          &lt;/table&gt;
        &lt;/div&gt;
      {% else %}
        &lt;div class=&quot;no_indexes_defined&quot;&gt;{{ 'No index defined!'|trans|notice }}&lt;/div&gt;
      {% endif %}
    &lt;/fieldset&gt;

    &lt;fieldset class=&quot;pma-fieldset tblFooters d-print-none text-start&quot;&gt;
      &lt;form action=&quot;{{ url('/table/indexes') }}&quot; method=&quot;post&quot;&gt;
        {{ get_hidden_inputs(db, table) }}
        &lt;input type=&quot;hidden&quot; name=&quot;create_index&quot; value=&quot;1&quot;&gt;

        {% apply format('&lt;input class=&quot;mx-2&quot; type=&quot;number&quot; name=&quot;added_fields&quot; value=&quot;1&quot; min=&quot;1&quot; max=&quot;16&quot; required&gt;')|raw %}
          {% trans %}Create an index on %s columns{% endtrans %}
        {% endapply %}

        &lt;input class=&quot;btn btn-primary add_index ajax&quot; type=&quot;submit&quot; value=&quot;{% trans 'Go' %}&quot;&gt;
      &lt;/form&gt;
    &lt;/fieldset&gt;
  &lt;/div&gt;
  {{ include('modals/index_dialog_modal.twig') }}
{% endif %}

{# Display partition details #}
{% if have_partitioning %}
    {# Detect partitioning #}
    {% if partition_names is not empty and partition_names[0] is not null %}
        {% set first_partition = partitions[0] %}
        {% set range_or_list = first_partition.getMethod() == 'RANGE'
            or first_partition.getMethod() == 'RANGE COLUMNS'
            or first_partition.getMethod() == 'LIST'
            or first_partition.getMethod() == 'LIST COLUMNS' %}
        {% set sub_partitions = first_partition.getSubPartitions() %}
        {% set has_sub_partitions = first_partition.hasSubPartitions() %}
        {% if has_sub_partitions %}
            {% set first_sub_partition = sub_partitions[0] %}
        {% endif %}

        {% if default_sliders_state != 'disabled' %}
        &lt;div class=&quot;mb-3&quot;&gt;
          &lt;button class=&quot;btn btn-sm btn-secondary&quot; type=&quot;button&quot; data-bs-toggle=&quot;collapse&quot; data-bs-target=&quot;#partitionsCollapse&quot; aria-expanded=&quot;{{ default_sliders_state == 'open' ? 'true' : 'false' }}&quot; aria-controls=&quot;partitionsCollapse&quot;&gt;
            {% trans 'Partitions' %}
          &lt;/button&gt;
        &lt;/div&gt;
        &lt;div class=&quot;collapse mb-3{{ default_sliders_state == 'open' ? ' show' }}&quot; id=&quot;partitionsCollapse&quot;&gt;
        {% endif %}

        {% include 'table/structure/display_partitions.twig' with {
            'db': db,
            'table': table,
            'partitions': partitions,
            'partition_method': first_partition.getMethod(),
            'partition_expression': first_partition.getExpression(),
            'has_description': first_partition.getDescription() is not empty,
            'has_sub_partitions': has_sub_partitions,
            'sub_partition_method': has_sub_partitions ? first_sub_partition.getMethod(),
            'sub_partition_expression': has_sub_partitions ? first_sub_partition.getExpression(),
            'range_or_list': range_or_list
        } only %}
    {% else %}
        {% include 'table/structure/display_partitions.twig' with {
            'db': db,
            'table': table
        } only %}
    {% endif %}
    {% if default_sliders_state != 'disabled' %}
    &lt;/div&gt;
    {% endif %}
{% endif %}

{# Displays Space usage and row statistics #}
{% if show_stats %}
    {{ table_stats|raw }}
{% endif %}
&lt;div class=&quot;clearfloat&quot;&gt;&lt;/div&gt;
{% endblock %}
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flocal%2Fcpanel%2Fbase%2F3rdparty%2FphpMyAdmin%2Ftemplates%2Ftable%2Fstructure'>Back to Directory</a>