FM / templates

/usr/share/phpmyadmin/templates

Name	Size	Mode	Actions
columns_definitions/	-	0755	rm
components/	-	0755	rm
config/	-	0755	rm
console/	-	0755	rm
database/	-	0755	rm
display/	-	0755	rm
encoding/	-	0755	rm
error/	-	0755	rm
export/	-	0755	rm
home/	-	0755	rm
import/	-	0755	rm
javascript/	-	0755	rm
login/	-	0755	rm
menu/	-	0755	rm
navigation/	-	0755	rm
plugins/	-	0755	rm
preferences/	-	0755	rm
relation/	-	0755	rm
server/	-	0755	rm
setup/	-	0755	rm
sql/	-	0755	rm
table/	-	0755	rm
test/	-	0755	rm
changelog.twig	475	0644	edit dl rm
create_tracking_version.twig	3790	0644	edit dl rm
export.twig	16231	0644	edit dl rm
file_select_options.twig	152	0644	edit dl rm
filter.twig	374	0644	edit dl rm
footer.twig	388	0644	edit dl rm
gis_data_editor_form.twig	12506	0644	edit dl rm
header.twig	2504	0644	edit dl rm
header_location.twig	652	0644	edit dl rm
import.twig	10714	0644	edit dl rm
import_status.twig	99	0644	edit dl rm
indexes.twig	4147	0644	edit dl rm
message.twig	80	0644	edit dl rm
preview_sql.twig	301	0644	edit dl rm
scripts.twig	802	0644	edit dl rm
select_all.twig	385	0644	edit dl rm
select_lang.twig	900	0644	edit dl rm
start_and_number_of_rows_panel.twig	808	0644	edit dl rm
themes.twig	233	0644	edit dl rm
theme_preview.twig	502	0644	edit dl rm
top_menu.twig	1077	0644	edit dl rm
transformation_overview.twig	1293	0644	edit dl rm
user_password.twig	83	0644	edit dl rm
view_create.twig	4821	0644	edit dl rm

Edit: /usr/share/phpmyadmin/templates/indexes.twig (4147B)

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

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

<div class="table-responsive jsresponsive">
      <table class="table table-light table-striped table-hover table-sm w-auto" id="table_index">
        <thead class="thead-light">
        <tr>
            <th colspan="3" class="print_ignore">{% 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 print_ignore ajax">
                <a class="ajax" href="{{ url('/table/indexes') }}" data-post="{{ get_common(url_params|merge({'index': index.getName()}), '') }}">
                  {{ get_icon('b_edit', 'Edit'|trans) }}
                </a>
              </td>
              <td rowspan="{{ columns_count }}" class="rename_index print_ignore ajax" >
                <a class="ajax" href="{{ url('/table/indexes/rename') }}" data-post="{{ get_common(url_params|merge({'index': index.getName()}), '') }}">
                  {{ get_icon('b_rename', 'Rename'|trans) }}
                </a>
              </td>
              <td rowspan="{{ columns_count }}" class="print_ignore">
                {% 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|js_format(false) }}">
                {{ 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>
                  {{ column.getName() }}
                  {% 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>

{% trans 'Indexes' %} {{ show_mysql_docu('optimizing-database-structure') }} {% if indexes is not empty %} {{ indexes_duplicates|raw }}

{% for index in indexes %} {% set columns_count = index.getColumnCount() %} {% for column in index.getColumns() %} {% if column.getSeqInIndex() > 1 %} {% endif %} {% if column.getSeqInIndex() == 1 %} {% endif %} {% endfor %} {% endfor %}

{% trans 'Action' %}			{% trans 'Keyname' %}	{% trans 'Type' %}	{% trans 'Unique' %}	{% trans 'Packed' %}	{% trans 'Column' %}	{% trans 'Cardinality' %}	{% trans 'Collation' %}	{% trans 'Null' %}	{% trans 'Comment' %}
{{ get_icon('b_edit', 'Edit'\|trans) }}	{{ get_icon('b_rename', 'Rename'\|trans) }}	{% 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 %} {{ link_or_button( url('/sql', url_params\|merge(index_params)), get_icon('b_drop', 'Drop'\|trans), {'class': 'drop_primary_key_index_anchor ajax'} ) }}	{{ index.getName() }}	{{ index.getType()\|default(index.getChoice()) }}	{{ index.isUnique() ? 'Yes'\|trans : 'No'\|trans }}	{{ index.isPacked()\|raw }}
{{ column.getName() }} {% if column.getSubPart() is not empty %} ({{ column.getSubPart() }}) {% endif %}	{{ column.getCardinality() }}	{{ column.getCollation() }}	{{ column.getNull(true) }}	{{ index.getComments() }}

{% else %}

{% endif %}