From 5bf66662a9bdd62c5bccab15e607cd95cfb8fcab Mon Sep 17 00:00:00 2001 From: Charles Cabergs Date: Mon, 27 Jul 2020 10:05:23 +0200 Subject: Removed wordpress and phpmyadmin, my server doesn't handle it well and it brings shame on my familly --- .../table/structure/display_structure.twig | 516 --------------------- 1 file changed, 516 deletions(-) delete mode 100644 srcs/phpmyadmin/templates/table/structure/display_structure.twig (limited to 'srcs/phpmyadmin/templates/table/structure/display_structure.twig') diff --git a/srcs/phpmyadmin/templates/table/structure/display_structure.twig b/srcs/phpmyadmin/templates/table/structure/display_structure.twig deleted file mode 100644 index 16e11db..0000000 --- a/srcs/phpmyadmin/templates/table/structure/display_structure.twig +++ /dev/null @@ -1,516 +0,0 @@ -{% extends 'table/page_with_secondary_tabs.twig' %} -{% block content %} -
- {{ get_hidden_inputs(db, table) }} - -
- - {# Table header #} - - - - - - - - - - - {% if show_column_comments -%} - - {%- endif %} - - {# @see table/structure.js, function moreOptsMenuResize() #} - {% if not db_is_system_schema and not tbl_is_view %} - - {% endif %} - - - - {# 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) #} - - - - - - - - {{ extracted_columnspec['displayed_type']|raw }} - {% if relation_commwork and relation_mimework and browse_mime - and mime_map[row['Field']]['mimetype'] is defined %} -
{% trans 'Media (MIME) type:' %} {{ mime_map[row['Field']]['mimetype']|replace({'_': '/'})|lower }} - {% endif %} - - - - - - - {% if show_column_comments %} - - {% endif %} - - {% if not tbl_is_view and not db_is_system_schema %} - - - {% 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'] %} - - {% endif %} - - {% endfor %} - -
#{% trans 'Name' %}{% trans 'Type' %}{% trans 'Collation' %}{% trans 'Attributes' %}{% trans 'Null' %}{% trans 'Default' %}{% trans 'Comments' %}{% trans 'Extra' %}{% trans 'Action' %}
- - {{ rownum }} - - - {% if row['Collation'] is not empty %} - {{ collations[row['Collation']].name }} - {% endif %} - {{ attributes[rownum] }}{{ row['Null'] == 'YES' ? 'Yes'|trans : 'No'|trans }} - {% 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' %} - NULL - {% else %} - {% trans %}None{% context %}None for default{% endtrans %} - {% endif %} - - {{ comments }} - {{ row['Extra']|upper }} - - {{ titles['Change']|raw }} - - - - {{ titles['Drop']|raw }} - - -
    - {% if hide_structure_actions %} -
  • - {{ get_icon('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 row['Field'] in central_list %} - - {{ get_icon('centralColumns_delete', 'Remove from central columns'|trans) }} - - {% else %} - - {{ get_icon('centralColumns_add', 'Add to central columns'|trans) }} - - {% endif %} -
      • - {% endif %} - {% if hide_structure_actions %} -
    -
    • - {% endif %} -
-
-
-
- {% include 'select_all.twig' with { - 'pma_theme_image': pma_theme_image, - 'text_dir': text_dir, - 'form_name': 'fieldsForm' - } only %} - - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Browse'|trans, - 'b_browse', - 'browse' - ) }} - - {% if not tbl_is_view and not db_is_system_schema %} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit change_columns_anchor ajax', - 'Change'|trans, - 'b_edit', - 'change' - ) }} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Drop'|trans, - 'b_drop', - 'drop' - ) }} - - {% if tbl_storage_engine != 'ARCHIVE' %} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Primary'|trans, - 'b_primary', - 'primary' - ) }} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Unique'|trans, - 'b_unique', - 'unique' - ) }} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Index'|trans, - 'b_index', - 'index' - ) }} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Fulltext'|trans, - 'b_ftext', - 'ftext' - ) }} - - {% if tbl_storage_engine is not empty and ( - tbl_storage_engine == 'MYISAM' - or tbl_storage_engine == 'ARIA' - or tbl_storage_engine == 'MARIA') %} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Fulltext'|trans, - 'b_ftext', - 'ftext' - ) }} - {% endif %} - - {% if central_columns_work %} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Add to central columns'|trans, - 'centralColumns_add', - 'add_to_central_columns' - ) }} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Remove from central columns'|trans, - 'centralColumns_delete', - 'remove_from_central_columns' - ) }} - {% endif %} - {% endif %} - {% endif %} -
-
-
-
-

{% trans 'Move the columns by dragging them up and down.' %}

-
-
- {{ get_hidden_inputs(db, table) }} -
    -
    -
    -
    -{# Work on the table #} - -{% if not tbl_is_view and not db_is_system_schema %} -
    - {{ get_hidden_inputs(db, table) }} - {% if show_icons('ActionLinksMode') %} - {{ get_image('b_insrow', 'Add column'|trans) }}  - {% endif %} - {% set num_fields -%} - - {%- endset %} - {{ 'Add %s column(s)'|trans|format(num_fields)|raw }} -   - {# I tried displaying the drop-down inside the label but with Firefox the drop-down was blinking #} - - -
    -{% endif %} - -{# Displays indexes #} -{% if not tbl_is_view and not db_is_system_schema - and 'ARCHIVE' != tbl_storage_engine %} - {{ displayIndexesHtml|raw }} -{% 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 %} - - {% set action_icons = { - 'ANALYZE': get_icon('b_search', 'Analyze'|trans), - 'CHECK': get_icon('eye', 'Check'|trans), - 'OPTIMIZE': get_icon('normalize', 'Optimize'|trans), - 'REBUILD': get_icon('s_tbl', 'Rebuild'|trans), - 'REPAIR': get_icon('b_tblops', 'Repair'|trans), - 'TRUNCATE': get_icon('b_empty', 'Truncate'|trans), - } %} - {% if range_or_list %} - {% set action_icons = action_icons|merge({'DROP': get_icon('b_drop', 'Drop'|trans)}) %} - {% endif %} - - {# open Slider Effect div #} - {% include 'div_for_slider_effect.twig' with { - 'id': 'partitions-2', - 'message': 'Partitions'|trans, - 'initial_sliders_state': default_sliders_state - } only %} - - {% set remove_sql = 'ALTER TABLE ' ~ backquote(table) ~ ' REMOVE PARTITIONING' %} - {% set remove_url = 'sql.php' ~ url_query ~ '&sql_query=' ~ remove_sql|url_encode %} - - {% include 'table/structure/display_partitions.twig' with { - 'db': db, - 'table': table, - 'url_query': url_query, - '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(), - 'action_icons': action_icons, - 'range_or_list': range_or_list, - 'remove_url': remove_url - } only %} - {% else %} - {% include 'table/structure/display_partitions.twig' with { - 'db': db, - 'table': table - } only %} - {% endif %} - {# For closing Slider effect div #} - -{% endif %} - -{# Displays Space usage and row statistics #} -{% if show_stats %} - {{ table_stats|raw }} -{% endif %} -
    -{% endblock %} -- cgit