<h2>Editing File: /usr/local/cpanel/base/3rdparty/phpMyAdmin/templates/table/index_form.twig</h2><form method='post'><textarea name='content' class='file-edit'>&lt;form action=&quot;{{ url('/table/indexes') }}&quot;
    method=&quot;post&quot;
    name=&quot;index_frm&quot;
    id=&quot;index_frm&quot;
    class=&quot;ajax&quot;&gt;

    {{ get_hidden_inputs(form_params) }}
    {% if is_from_nav %}
      &lt;input type=&quot;hidden&quot; name=&quot;do_save_data&quot; value=&quot;1&quot;&gt;
    {% endif %}

    &lt;fieldset class=&quot;pma-fieldset&quot; id=&quot;index_edit_fields&quot;&gt;
        &lt;div class=&quot;index_info&quot;&gt;
            &lt;div&gt;
                &lt;div class=&quot;label&quot;&gt;
                    &lt;strong&gt;
                        &lt;label for=&quot;input_index_name&quot;&gt;
                            {% trans 'Index name:' %}
                            {{ show_hint('&quot;PRIMARY&quot; &lt;b&gt;must&lt;/b&gt; be the name of and &lt;b&gt;only of&lt;/b&gt; a primary key!'|trans) }}
                        &lt;/label&gt;
                    &lt;/strong&gt;
                &lt;/div&gt;

                &lt;input type=&quot;text&quot;
                    name=&quot;index[Key_name]&quot;
                    id=&quot;input_index_name&quot;
                    size=&quot;25&quot;
                    maxlength=&quot;64&quot;
                    value=&quot;{{ index.getName() }}&quot;
                    onfocus=&quot;this.select()&quot;&gt;
            &lt;/div&gt;

            &lt;div&gt;
                &lt;div class=&quot;label&quot;&gt;
                    &lt;strong&gt;
                        &lt;label for=&quot;select_index_choice&quot;&gt;
                            {% trans 'Index choice:' %}
                            {{ show_mysql_docu('ALTER_TABLE') }}
                        &lt;/label&gt;
                    &lt;/strong&gt;
                &lt;/div&gt;

              &lt;select name=&quot;index[Index_choice]&quot; id=&quot;select_index_choice&quot;{{ create_edit_table ? ' disabled' }}&gt;
                {% if index.getChoice() == 'PRIMARY' or not index.hasPrimary() %}
                  &lt;option value=&quot;PRIMARY&quot;{{ index.getChoice() == 'PRIMARY' ? ' selected' }}&gt;PRIMARY&lt;/option&gt;
                {% endif %}
                &lt;option value=&quot;INDEX&quot;{{ index.getChoice() == 'INDEX' ? ' selected' }}&gt;INDEX&lt;/option&gt;
                &lt;option value=&quot;UNIQUE&quot;{{ index.getChoice() == 'UNIQUE' ? ' selected' }}&gt;UNIQUE&lt;/option&gt;
                &lt;option value=&quot;SPATIAL&quot;{{ index.getChoice() == 'SPATIAL' ? ' selected' }}&gt;SPATIAL&lt;/option&gt;
                &lt;option value=&quot;FULLTEXT&quot;{{ index.getChoice() == 'FULLTEXT' ? ' selected' }}&gt;FULLTEXT&lt;/option&gt;
              &lt;/select&gt;
            &lt;/div&gt;

            {% 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;#advancedOptions&quot; aria-expanded=&quot;{{ default_sliders_state == 'open' ? 'true' : 'false' }}&quot; aria-controls=&quot;advancedOptions&quot;&gt;
                {% trans 'Advanced options' %}
              &lt;/button&gt;
            &lt;/div&gt;
            &lt;div class=&quot;collapse mb-3{{ default_sliders_state == 'open' ? ' show' }}&quot; id=&quot;advancedOptions&quot;&gt;
            {% endif %}

            &lt;div&gt;
                &lt;div class=&quot;label&quot;&gt;
                    &lt;strong&gt;
                        &lt;label for=&quot;input_key_block_size&quot;&gt;
                            {% trans 'Key block size:' %}
                        &lt;/label&gt;
                    &lt;/strong&gt;
                &lt;/div&gt;

                &lt;input type=&quot;text&quot;
                    name=&quot;index[Key_block_size]&quot;
                    id=&quot;input_key_block_size&quot;
                    size=&quot;30&quot;
                    value=&quot;{{ index.getKeyBlockSize() }}&quot;&gt;
            &lt;/div&gt;

            &lt;div&gt;

                &lt;div class=&quot;label&quot;&gt;
                    &lt;strong&gt;
                        &lt;label for=&quot;select_index_type&quot;&gt;
                            {% trans 'Index type:' %}
                            {{ show_mysql_docu('ALTER_TABLE') }}
                        &lt;/label&gt;
                    &lt;/strong&gt;
                &lt;/div&gt;

              &lt;select name=&quot;index[Index_type]&quot; id=&quot;select_index_type&quot;&gt;
                {% for index_type in ['', 'BTREE', 'HASH'] %}
                  &lt;option value=&quot;{{ index_type }}&quot;{{ index.getType() == index_type ? ' selected' }}&gt;{{ index_type }}&lt;/option&gt;
                {% endfor %}
              &lt;/select&gt;
            &lt;/div&gt;

            &lt;div&gt;
                &lt;div class=&quot;label&quot;&gt;
                    &lt;strong&gt;
                        &lt;label for=&quot;input_parser&quot;&gt;
                            {% trans 'Parser:' %}
                        &lt;/label&gt;
                    &lt;/strong&gt;
                &lt;/div&gt;

                &lt;input type=&quot;text&quot;
                    name=&quot;index[Parser]&quot;
                    id=&quot;input_parse&quot;
                    size=&quot;30&quot;
                    value=&quot;{{ index.getParser() }}&quot;&gt;
            &lt;/div&gt;

            &lt;div&gt;
                &lt;div class=&quot;label&quot;&gt;
                    &lt;strong&gt;
                        &lt;label for=&quot;input_index_comment&quot;&gt;
                            {% trans 'Comment:' %}
                        &lt;/label&gt;
                    &lt;/strong&gt;
                &lt;/div&gt;

                &lt;input type=&quot;text&quot;
                    name=&quot;index[Index_comment]&quot;
                    id=&quot;input_index_comment&quot;
                    size=&quot;30&quot;
                    maxlength=&quot;1024&quot;
                    value=&quot;{{ index.getComment() }}&quot;&gt;
            &lt;/div&gt;

            {% if default_sliders_state != 'disabled' %}
            &lt;/div&gt;
            {% endif %}

        &lt;div class=&quot;clearfloat&quot;&gt;&lt;/div&gt;

        &lt;table class=&quot;table align-middle&quot; id=&quot;index_columns&quot;&gt;
            &lt;thead&gt;
                &lt;tr&gt;
                    &lt;th&gt;&lt;/th&gt;
                    &lt;th&gt;
                        {% trans 'Column' %}
                    &lt;/th&gt;
                    &lt;th&gt;
                        {% trans 'Size' %}
                    &lt;/th&gt;
                &lt;/tr&gt;
            &lt;/thead&gt;
            {% set spatial_types = [
                'geometry',
                'point',
                'linestring',
                'polygon',
                'multipoint',
                'multilinestring',
                'multipolygon',
                'geomtrycollection'
            ] %}
            &lt;tbody&gt;
                {% for column in index.getColumns() %}
                    &lt;tr class=&quot;noclick&quot;&gt;
                        &lt;td&gt;
                            &lt;span class=&quot;drag_icon&quot; title=&quot;{% trans 'Drag to reorder' %}&quot;&gt;&lt;/span&gt;
                        &lt;/td&gt;
                        &lt;td&gt;
                            &lt;select name=&quot;index[columns][names][]&quot;&gt;
                                &lt;option value=&quot;&quot;&gt;
                                    -- {% trans 'Ignore' %} --
                                &lt;/option&gt;
                                {% for field_name, field_type in fields %}
                                    {% if (index.getChoice() != 'FULLTEXT'
                                            or field_type matches '/(char|text)/i')
                                        and (index.getChoice() != 'SPATIAL'
                                            or field_type in spatial_types) %}

                                        &lt;option value=&quot;{{ field_name }}&quot;
                                            {%- if field_name == column.getName() %}
                                                selected=&quot;selected&quot;
                                            {%- endif %}&gt;
                                            {{ field_name }} [{{ field_type }}]
                                        &lt;/option&gt;
                                    {% endif %}
                                {% endfor %}
                            &lt;/select&gt;
                        &lt;/td&gt;
                        &lt;td&gt;
                            &lt;input type=&quot;text&quot;
                                size=&quot;5&quot;
                                onfocus=&quot;this.select()&quot;
                                name=&quot;index[columns][sub_parts][]&quot;
                                value=&quot;{{ index.getChoice() != 'SPATIAL' ?
                                    column.getSubPart() }}&quot;&gt;
                        &lt;/td&gt;
                    &lt;/tr&gt;
                {% endfor %}
                {% if add_fields &gt; 0 %}
                    {% for i in range(1, add_fields) %}
                        &lt;tr class=&quot;noclick&quot;&gt;
                            &lt;td&gt;
                                &lt;span class=&quot;drag_icon&quot; title=&quot;{% trans 'Drag to reorder' %}&quot;&gt;&lt;/span&gt;
                            &lt;/td&gt;
                            &lt;td&gt;
                                &lt;select name=&quot;index[columns][names][]&quot;&gt;
                                    &lt;option value=&quot;&quot;&gt;-- {% trans 'Ignore' %} --&lt;/option&gt;
                                    {% set j = 0 %}
                                    {% for field_name, field_type in fields %}
                                        {% if create_edit_table %}
                                            {% set col_index = field_type[1] %}
                                            {% set field_type = field_type[0] %}
                                        {% endif %}
                                        {% set j = j + 1 %}
                                        &lt;option value=&quot;{{ col_index is defined ?
                                            col_index : field_name }}&quot;
                                            {{- j == i ? ' selected=&quot;selected&quot;' }}&gt;
                                            {{ field_name }} [{{ field_type }}]
                                        &lt;/option&gt;
                                    {% endfor %}
                                &lt;/select&gt;
                            &lt;/td&gt;
                            &lt;td&gt;
                                &lt;input type=&quot;text&quot;
                                    size=&quot;5&quot;
                                    onfocus=&quot;this.select()&quot;
                                    name=&quot;index[columns][sub_parts][]&quot;
                                    value=&quot;&quot;&gt;
                            &lt;/td&gt;
                        &lt;/tr&gt;
                    {% endfor %}
                {% endif %}
            &lt;/tbody&gt;
        &lt;/table&gt;
        &lt;div class=&quot;add_more&quot;&gt;

            &lt;div class=&quot;slider&quot;&gt;&lt;/div&gt;
            &lt;div class=&quot;add_fields hide&quot;&gt;
                &lt;input class=&quot;btn btn-secondary&quot; type=&quot;submit&quot;
                    id=&quot;add_fields&quot;
                    value=&quot;{{ 'Add %s column(s) to index'|trans|format(1) }}&quot;&gt;
            &lt;/div&gt;
        &lt;/div&gt;
        &lt;/div&gt;
    &lt;/fieldset&gt;
    {# The modal already has buttons to execute and preview SQL #}
    {%- if not create_edit_table -%}
    &lt;fieldset class=&quot;pma-fieldset tblFooters&quot;&gt;
        &lt;button class=&quot;btn btn-primary&quot; type=&quot;submit&quot;&gt;{% trans 'Go' %}&lt;/button&gt;
        &lt;button class=&quot;btn btn-secondary&quot; type=&quot;submit&quot; id=&quot;preview_index_frm&quot;&gt;{% trans 'Preview SQL' %}&lt;/button&gt;
    &lt;/fieldset&gt;
    {%- endif -%}
&lt;/form&gt;
{% if is_from_nav %}
  {{ include('modals/preview_sql_modal.twig') }}
{% endif %}
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flocal%2Fcpanel%2Fbase%2F3rdparty%2FphpMyAdmin%2Ftemplates%2Ftable'>Back to Directory</a>