Gecko [ www.vortexaion.com ]

Name	Size	Permission	Date
columns_definitions	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
components	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
config	[ DIR ]	drwxrwxrwx	2024-07-26 17:40
console	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
database	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
display	[ DIR ]	drwxrwxrwx	2024-07-26 17:40
encoding	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
error	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
export	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
home	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
import	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
javascript	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
login	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
menu	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
modals	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
navigation	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
plugins	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
preferences	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
relation	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
server	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
setup	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
sql	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
table	[ DIR ]	drwxrwxrwx	2024-07-26 17:41
changelog.twig	457 B	-rw-rw-rw-	2023-02-07 22:26
create_tracking_version.twig	3.7 KB	-rw-rw-rw-	2023-02-07 22:26
export.twig	23.07 KB	-rw-rw-rw-	2023-02-07 22:26
export_modal.twig	662 B	-rw-rw-rw-	2023-02-07 22:26
file_select_options.twig	152 B	-rw-rw-rw-	2023-02-07 22:26
filter.twig	433 B	-rw-rw-rw-	2023-02-07 22:26
footer.twig	1.55 KB	-rw-rw-rw-	2023-02-07 22:26
gis_data_editor_form.twig	12.18 KB	-rw-rw-rw-	2023-02-07 22:26
header.twig	2.26 KB	-rw-rw-rw-	2023-02-07 22:26
header_location.twig	652 B	-rw-rw-rw-	2023-02-07 22:26
import.twig	10.76 KB	-rw-rw-rw-	2023-02-07 22:26
import_status.twig	112 B	-rw-rw-rw-	2023-02-07 22:26
indexes.twig	4.19 KB	-rw-rw-rw-	2023-02-07 22:26
list_navigator.twig	2.29 KB	-rw-rw-rw-	2023-02-07 22:26
message.twig	80 B	-rw-rw-rw-	2023-02-07 22:26
preview_sql.twig	301 B	-rw-rw-rw-	2023-02-07 22:26
recent_favorite_table_favorite.twig	497 B	-rw-rw-rw-	2023-02-07 22:26
recent_favorite_table_no_tables.twig	187 B	-rw-rw-rw-	2023-02-07 22:26
recent_favorite_table_recent.twig	172 B	-rw-rw-rw-	2023-02-07 22:26
scripts.twig	802 B	-rw-rw-rw-	2023-02-07 22:26
select_all.twig	380 B	-rw-rw-rw-	2023-02-07 22:26
top_menu.twig	1.07 KB	-rw-rw-rw-	2023-02-07 22:26
transformation_overview.twig	1.31 KB	-rw-rw-rw-	2023-02-07 22:26
user_password.twig	83 B	-rw-rw-rw-	2023-02-07 22:26
view_create.twig	4.73 KB	-rw-rw-rw-	2023-02-07 22:26

Rename

<fieldset class="pma-fieldset index_info">
  <legend id="index_header">
    {% trans 'Indexes' %}
    {{ show_mysql_docu('optimizing-database-structure') }}
  </legend>

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

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

{% for index in indexes %}
          <tbody class="row_span">
            {% set columns_count = index.getColumnCount() %}
            <tr class="noclick">
              <td rowspan="{{ columns_count }}" class="edit_index d-print-none ajax">
                <a class="ajax" href="{{ url('/table/indexes') }}" data-post="{{ get_common(url_params|merge({'index': index.getName()}), '', false) }}">
                  {{ get_icon('b_edit', 'Edit'|trans) }}
                </a>
              </td>
              <td rowspan="{{ columns_count }}" class="rename_index d-print-none ajax" >
                <a class="ajax" href="{{ url('/table/indexes/rename') }}" data-post="{{ get_common(url_params|merge({'index': index.getName()}), '', false) }}">
                  {{ get_icon('b_rename', 'Rename'|trans) }}
                </a>
              </td>
              <td rowspan="{{ columns_count }}" class="d-print-none">
                {% 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 %}

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

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

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