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/browse_foreigners/column_element.twig | 12 - .../table/browse_foreigners/show_all.twig | 5 - .../templates/table/chart/tbl_chart.twig | 159 ------- .../table/gis_visualization/gis_visualization.twig | 80 ---- srcs/phpmyadmin/templates/table/index_form.twig | 223 --------- .../table/insert/continue_insertion_form.twig | 19 - .../templates/table/operations/view.twig | 31 -- .../templates/table/page_with_secondary_tabs.twig | 22 - .../templates/table/relation/common_form.twig | 223 --------- .../table/relation/dropdown_generate.twig | 9 - .../templates/table/relation/foreign_key_row.twig | 136 ------ .../table/relation/relational_dropdown.twig | 18 - .../table/search/column_comparison_operators.twig | 3 - .../templates/table/search/fields_table.twig | 33 -- .../templates/table/search/form_tag.twig | 4 - .../templates/table/search/geom_func.twig | 19 - .../templates/table/search/input_box.twig | 97 ---- .../templates/table/search/replace_preview.twig | 39 -- .../templates/table/search/rows_normal.twig | 39 -- .../templates/table/search/rows_zoom.twig | 74 --- .../templates/table/search/selection_form.twig | 226 --------- .../templates/table/search/zoom_result_form.twig | 86 ---- .../structure/action_row_in_structure_table.twig | 31 -- .../table/structure/display_partitions.twig | 145 ------ .../table/structure/display_structure.twig | 516 --------------------- .../table/structure/display_table_stats.twig | 169 ------- .../table/structure/partition_definition_form.twig | 14 - srcs/phpmyadmin/templates/table/tracking/main.twig | 132 ------ .../templates/table/tracking/report_table.twig | 27 -- .../table/tracking/structure_snapshot_columns.twig | 56 --- .../table/tracking/structure_snapshot_indexes.twig | 33 -- 31 files changed, 2680 deletions(-) delete mode 100644 srcs/phpmyadmin/templates/table/browse_foreigners/column_element.twig delete mode 100644 srcs/phpmyadmin/templates/table/browse_foreigners/show_all.twig delete mode 100644 srcs/phpmyadmin/templates/table/chart/tbl_chart.twig delete mode 100644 srcs/phpmyadmin/templates/table/gis_visualization/gis_visualization.twig delete mode 100644 srcs/phpmyadmin/templates/table/index_form.twig delete mode 100644 srcs/phpmyadmin/templates/table/insert/continue_insertion_form.twig delete mode 100644 srcs/phpmyadmin/templates/table/operations/view.twig delete mode 100644 srcs/phpmyadmin/templates/table/page_with_secondary_tabs.twig delete mode 100644 srcs/phpmyadmin/templates/table/relation/common_form.twig delete mode 100644 srcs/phpmyadmin/templates/table/relation/dropdown_generate.twig delete mode 100644 srcs/phpmyadmin/templates/table/relation/foreign_key_row.twig delete mode 100644 srcs/phpmyadmin/templates/table/relation/relational_dropdown.twig delete mode 100644 srcs/phpmyadmin/templates/table/search/column_comparison_operators.twig delete mode 100644 srcs/phpmyadmin/templates/table/search/fields_table.twig delete mode 100644 srcs/phpmyadmin/templates/table/search/form_tag.twig delete mode 100644 srcs/phpmyadmin/templates/table/search/geom_func.twig delete mode 100644 srcs/phpmyadmin/templates/table/search/input_box.twig delete mode 100644 srcs/phpmyadmin/templates/table/search/replace_preview.twig delete mode 100644 srcs/phpmyadmin/templates/table/search/rows_normal.twig delete mode 100644 srcs/phpmyadmin/templates/table/search/rows_zoom.twig delete mode 100644 srcs/phpmyadmin/templates/table/search/selection_form.twig delete mode 100644 srcs/phpmyadmin/templates/table/search/zoom_result_form.twig delete mode 100644 srcs/phpmyadmin/templates/table/structure/action_row_in_structure_table.twig delete mode 100644 srcs/phpmyadmin/templates/table/structure/display_partitions.twig delete mode 100644 srcs/phpmyadmin/templates/table/structure/display_structure.twig delete mode 100644 srcs/phpmyadmin/templates/table/structure/display_table_stats.twig delete mode 100644 srcs/phpmyadmin/templates/table/structure/partition_definition_form.twig delete mode 100644 srcs/phpmyadmin/templates/table/tracking/main.twig delete mode 100644 srcs/phpmyadmin/templates/table/tracking/report_table.twig delete mode 100644 srcs/phpmyadmin/templates/table/tracking/structure_snapshot_columns.twig delete mode 100644 srcs/phpmyadmin/templates/table/tracking/structure_snapshot_indexes.twig (limited to 'srcs/phpmyadmin/templates/table') diff --git a/srcs/phpmyadmin/templates/table/browse_foreigners/column_element.twig b/srcs/phpmyadmin/templates/table/browse_foreigners/column_element.twig deleted file mode 100644 index f2ec2ba..0000000 --- a/srcs/phpmyadmin/templates/table/browse_foreigners/column_element.twig +++ /dev/null @@ -1,12 +0,0 @@ - - {{ is_selected ? '' }} - - {% if nowrap %} - {{ keyname }} - {% else %} - {{ description }} - {% endif %} - - {{ is_selected ? '' }} - diff --git a/srcs/phpmyadmin/templates/table/browse_foreigners/show_all.twig b/srcs/phpmyadmin/templates/table/browse_foreigners/show_all.twig deleted file mode 100644 index 4de9b81..0000000 --- a/srcs/phpmyadmin/templates/table/browse_foreigners/show_all.twig +++ /dev/null @@ -1,5 +0,0 @@ -{% if foreign_data.disp_row is iterable and - (show_all and foreign_data.the_total > max_rows) %} - -{% endif %} diff --git a/srcs/phpmyadmin/templates/table/chart/tbl_chart.twig b/srcs/phpmyadmin/templates/table/chart/tbl_chart.twig deleted file mode 100644 index 4201599..0000000 --- a/srcs/phpmyadmin/templates/table/chart/tbl_chart.twig +++ /dev/null @@ -1,159 +0,0 @@ - -{# Display Chart options #} -
-
- {{ get_hidden_inputs(url_params) }} -
- - {% trans 'Display chart' %} - -
-
- - -
-
- - -
-
- - -
-
- - -
-
- - -
- - - - - - - - - - - - -

- - - - -

- - -
- {% set xaxis = null %} -
- - -
- - - - -
-
- - -
- - -
-
-
-
- - -
- - - - -
- {{ get_start_and_number_of_rows_panel(sql_query) }} -
- -
-
-
diff --git a/srcs/phpmyadmin/templates/table/gis_visualization/gis_visualization.twig b/srcs/phpmyadmin/templates/table/gis_visualization/gis_visualization.twig deleted file mode 100644 index 9e82e2e..0000000 --- a/srcs/phpmyadmin/templates/table/gis_visualization/gis_visualization.twig +++ /dev/null @@ -1,80 +0,0 @@ -
-
- {% trans 'Display GIS Visualization' %} -
-
- {{ get_hidden_inputs(url_params) }} - - - - - - - - - - - - {{ get_start_and_number_of_rows_panel(sql_query) }} -
- -
-
- - {{ get_image('b_saveimage', 'Save'|trans) }} - - -
-
-
- -
- -
- {{ visualization|raw }} -
-
- - -
-
diff --git a/srcs/phpmyadmin/templates/table/index_form.twig b/srcs/phpmyadmin/templates/table/index_form.twig deleted file mode 100644 index 6364599..0000000 --- a/srcs/phpmyadmin/templates/table/index_form.twig +++ /dev/null @@ -1,223 +0,0 @@ -
- - {{ get_hidden_inputs(form_params) }} - -
-
-
-
- - - -
- - -
- -
-
- - - -
- {{ index.generateIndexChoiceSelector(create_edit_table)|raw }} -
- - {% include 'div_for_slider_effect.twig' with { - 'id': 'indexoptions', - 'message': 'Advanced Options'|trans, - 'initial_sliders_state': default_sliders_state - } only %} - -
-
- - - -
- - -
- -
- -
- - - -
- {{ index.generateIndexTypeSelector()|raw }} -
- -
-
- - - -
- - -
- -
-
- - - -
- - -
-
- - -
- - - - - - - - - - {% set spatial_types = [ - 'geometry', - 'point', - 'linestring', - 'polygon', - 'multipoint', - 'multilinestring', - 'multipolygon', - 'geomtrycollection' - ] %} - - {% for column in index.getColumns() %} - - - - - - {% endfor %} - {% if add_fields > 0 %} - {% for i in range(1, add_fields) %} - - - - - - {% endfor %} - {% endif %} - -
- {% trans 'Column' %} - - {% trans 'Size' %} -
- - - - - -
- - - - - -
-
- -
-
- -
-
-
-
- - -
-
diff --git a/srcs/phpmyadmin/templates/table/insert/continue_insertion_form.twig b/srcs/phpmyadmin/templates/table/insert/continue_insertion_form.twig deleted file mode 100644 index 86a8215..0000000 --- a/srcs/phpmyadmin/templates/table/insert/continue_insertion_form.twig +++ /dev/null @@ -1,19 +0,0 @@ -
- {{ get_hidden_inputs(db, table) }} - - - - - {% if has_where_clause %} - {% for key_id, where_clause in where_clause_array %} - - {% endfor %} - {% endif %} - - {% set insert_rows %} - - {% endset %} - {{ 'Continue insertion with %s rows'|trans|format(insert_rows)|raw }} -
diff --git a/srcs/phpmyadmin/templates/table/operations/view.twig b/srcs/phpmyadmin/templates/table/operations/view.twig deleted file mode 100644 index e590532..0000000 --- a/srcs/phpmyadmin/templates/table/operations/view.twig +++ /dev/null @@ -1,31 +0,0 @@ - -
-
- {{ get_hidden_inputs(db, table) }} - -
- {% trans 'Operations' %} - - - - - - -
{% trans 'Rename view to' %} -
-
-
- - -
-
-
- -
-
- {% trans 'Delete data or table' %} -
    {{ delete_data_or_table_link | raw }}
-
-
diff --git a/srcs/phpmyadmin/templates/table/page_with_secondary_tabs.twig b/srcs/phpmyadmin/templates/table/page_with_secondary_tabs.twig deleted file mode 100644 index 2aae85a..0000000 --- a/srcs/phpmyadmin/templates/table/page_with_secondary_tabs.twig +++ /dev/null @@ -1,22 +0,0 @@ -{% if cfg_relation['relwork'] or is_foreign_key_supported %} - -
-{% endif %} - -
- {% block content %} - {% endblock %} -
diff --git a/srcs/phpmyadmin/templates/table/relation/common_form.twig b/srcs/phpmyadmin/templates/table/relation/common_form.twig deleted file mode 100644 index e85c6ce..0000000 --- a/srcs/phpmyadmin/templates/table/relation/common_form.twig +++ /dev/null @@ -1,223 +0,0 @@ -{% extends 'table/page_with_secondary_tabs.twig' %} - -{% block content %} -
- {{ get_hidden_inputs(db, table) }} - {# InnoDB #} - {% if is_foreign_key_supported(tbl_storage_engine) %} -
- {% trans 'Foreign key constraints' %} -
- - - - - {% if tbl_storage_engine|upper == 'INNODB' %} - - {% else %} - - {% endif %} - - - - - - - - - - - {% set i = 0 %} - {% if existrel_foreign is not empty %} - {% for key, one_key in existrel_foreign %} - {# Foreign database dropdown #} - {% set foreign_db = one_key['ref_db_name'] is defined - and one_key['ref_db_name'] is not null - ? one_key['ref_db_name'] : db %} - {% set foreign_table = false %} - {% if foreign_db %} - {% set foreign_table = one_key['ref_table_name'] is defined - and one_key['ref_table_name'] is not null - ? one_key['ref_table_name'] : false %} - {% endif %} - {% set unique_columns = [] %} - {% if foreign_db and foreign_table %} - {% set table_obj = table_get(foreign_table, foreign_db) %} - {% set unique_columns = table_obj.getUniqueColumns(false, false) %} - {% endif %} - {% include 'table/relation/foreign_key_row.twig' with { - 'i': i, - 'one_key': one_key, - 'column_array': column_array, - 'options_array': options_array, - 'tbl_storage_engine': tbl_storage_engine, - 'db': db, - 'table': table, - 'url_params': url_params, - 'databases': databases, - 'foreign_db': foreign_db, - 'foreign_table': foreign_table, - 'unique_columns': unique_columns - } only %} - {% set i = i + 1 %} - {% endfor %} - {% endif %} - {% include 'table/relation/foreign_key_row.twig' with { - 'i': i, - 'one_key': [], - 'column_array': column_array, - 'options_array': options_array, - 'tbl_storage_engine': tbl_storage_engine, - 'db': db, - 'table': table, - 'url_params': url_params, - 'databases': databases, - 'foreign_db': foreign_db, - 'foreign_table': foreign_table, - 'unique_columns': unique_columns - } only %} - {% set i = i + 1 %} - - - -
{% trans 'Actions' %}{% trans 'Constraint properties' %} - {% trans 'Column' %} - {{ show_hint('Creating a foreign key over a non-indexed column would automatically create an index on it. Alternatively, you can define an index below, before creating the foreign key.'|trans) }} - - {% trans 'Column' %} - {{ show_hint('Only columns with index will be displayed. You can define an index below.'|trans) }} - - {% trans 'Foreign key constraint' %} - ({{ tbl_storage_engine }}) -
{% trans 'Database' %}{% trans 'Table' %}{% trans 'Column' %}
- - {% trans '+ Add constraint' %} - -
-
-
- {% endif %} - - {% if cfg_relation['relwork'] %} - {% if is_foreign_key_supported(tbl_storage_engine) %} - {% include 'div_for_slider_effect.twig' with { - 'id': 'ir_div', - 'message': 'Internal relationships'|trans, - 'initial_sliders_state': default_sliders_state - } only %} - {% endif %} - -
- - {% trans 'Internal relationships' %} - {{ show_docu('config', 'cfg_Servers_relation') }} - - - - - - {% set saved_row_cnt = save_row|length - 1 %} - {% for i in 0..saved_row_cnt %} - {% set myfield = save_row[i]['Field'] %} - {# Use an md5 as array index to avoid having special characters - in the name attribute (see bug #1746964 ) #} - {% set myfield_md5 = column_hash_array[myfield] %} - - {% set foreign_table = false %} - {% set foreign_column = false %} - - {# Database dropdown #} - {% if existrel[myfield] is defined %} - {% set foreign_db = existrel[myfield]['foreign_db'] %} - {% else %} - {% set foreign_db = db %} - {% endif %} - - {# Table dropdown #} - {% set tables = [] %} - {% if foreign_db %} - {% if existrel[myfield] is defined %} - {% set foreign_table = existrel[myfield]['foreign_table'] %} - {% endif %} - {% set tables = dbi.getTables(foreign_db) %} - {% endif %} - - {# Column dropdown #} - {% set unique_columns = [] %} - {% if foreign_db and foreign_table %} - {% if existrel[myfield] is defined %} - {% set foreign_column = existrel[myfield]['foreign_field'] %} - {% endif %} - {% set table_obj = table_get(foreign_table, foreign_db) %} - {% set unique_columns = table_obj.getUniqueColumns(false, false) %} - {% endif %} - - - - - - - {% endfor %} -
{% trans 'Column' %}{% trans 'Internal relation' %} - {% if is_foreign_key_supported(tbl_storage_engine) %} - {{ show_hint('An internal relation is not necessary when a corresponding FOREIGN KEY relation exists.'|trans) }} - {% endif %} -
- {{ myfield }} - - - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_db[' ~ myfield_md5 ~ ']', - 'title': 'Database'|trans, - 'values': databases, - 'foreign': foreign_db - } only %} - - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_table[' ~ myfield_md5 ~ ']', - 'title': 'Table'|trans, - 'values': tables, - 'foreign': foreign_table - } only %} - - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_column[' ~ myfield_md5 ~ ']', - 'title': 'Column'|trans, - 'values': unique_columns, - 'foreign': foreign_column - } only %} -
-
- {% if is_foreign_key_supported(tbl_storage_engine) %} - - {% endif %} - {% endif %} - - {% if cfg_relation['displaywork'] %} - {% set disp = get_display_field(db, table) %} -
- - -
- {% endif %} - -
- - -
-
-{% if foreignKeySupported %} - {{ displayIndexesHtml|raw }} -{% endif %} -{% endblock %} diff --git a/srcs/phpmyadmin/templates/table/relation/dropdown_generate.twig b/srcs/phpmyadmin/templates/table/relation/dropdown_generate.twig deleted file mode 100644 index ff179bc..0000000 --- a/srcs/phpmyadmin/templates/table/relation/dropdown_generate.twig +++ /dev/null @@ -1,9 +0,0 @@ -{{ dropdown_question is not empty ? dropdown_question -}} - diff --git a/srcs/phpmyadmin/templates/table/relation/foreign_key_row.twig b/srcs/phpmyadmin/templates/table/relation/foreign_key_row.twig deleted file mode 100644 index 3df6c34..0000000 --- a/srcs/phpmyadmin/templates/table/relation/foreign_key_row.twig +++ /dev/null @@ -1,136 +0,0 @@ - - {# Drop key anchor #} - - {% set js_msg = '' %} - {% set this_params = null %} - {% if one_key['constraint'] is defined %} - {% set drop_fk_query = 'ALTER TABLE ' ~ backquote(db) ~ '.' ~ backquote(table) - ~ ' DROP FOREIGN KEY ' - ~ backquote(one_key['constraint']) ~ ';' - %} - {% set this_params = url_params %} - {% set this_params = { - 'goto': 'tbl_relation.php', - 'back': 'tbl_relation.php', - 'sql_query': drop_fk_query, - 'message_to_show': 'Foreign key constraint %s has been dropped'|trans|format( - one_key['constraint'] - ) - } %} - {% set js_msg = 'ALTER TABLE ' ~ db ~ '.' ~ table ~ ' DROP FOREIGN KEY ' ~ one_key['constraint'] ~ ';'|js_format %} - {% endif %} - {% if one_key['constraint'] is defined %} - - {% set drop_url = 'sql.php' ~ get_common(this_params) %} - {% set drop_str = get_icon('b_drop', 'Drop'|trans) %} - {{ link_or_button(drop_url, drop_str, {'class': 'drop_foreign_key_anchor ajax'}) }} - {% endif %} - - - - - -
- {# For ON DELETE and ON UPDATE, the default action - is RESTRICT as per MySQL doc; however, a SHOW CREATE TABLE - won't display the clause if it's set as RESTRICT. #} - {% set on_delete = one_key['on_delete'] is defined - ? one_key['on_delete'] : 'RESTRICT' %} - {% set on_update = one_key['on_update'] is defined - ? one_key['on_update'] : 'RESTRICT' %} - - {% include 'table/relation/dropdown_generate.twig' with { - 'dropdown_question': 'ON DELETE', - 'select_name': 'on_delete[' ~ i ~ ']', - 'choices': options_array, - 'selected_value': on_delete - } only %} - - - {% include 'table/relation/dropdown_generate.twig' with { - 'dropdown_question': 'ON UPDATE', - 'select_name': 'on_update[' ~ i ~ ']', - 'choices': options_array, - 'selected_value': on_update - } only %} - -
- - - {% if one_key['index_list'] is defined %} - {% for key, column in one_key['index_list'] %} - - {% include 'table/relation/dropdown_generate.twig' with { - 'dropdown_question': '', - 'select_name': 'foreign_key_fields_name[' ~ i ~ '][]', - 'choices': column_array, - 'selected_value': column - } only %} - - {% endfor %} - {% else %} - - {% include 'table/relation/dropdown_generate.twig' with { - 'dropdown_question': '', - 'select_name': 'foreign_key_fields_name[' ~ i ~ '][]', - 'choices': column_array, - 'selected_value': '' - } only %} - - {% endif %} - - {% trans '+ Add column' %} - - - {% set tables = [] %} - {% if foreign_db %} - {% set tables = get_tables(foreign_db, tbl_storage_engine) %} - {% endif %} - - - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_foreign_db[' ~ i ~ ']', - 'title': 'Database'|trans, - 'values': databases, - 'foreign': foreign_db - } only %} - - - - - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_foreign_table[' ~ i ~ ']', - 'title': 'Table'|trans, - 'values': tables, - 'foreign': foreign_table - } only %} - - - - {% if foreign_db and foreign_table %} - {% for foreign_column in one_key['ref_index_list'] %} - - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_foreign_column[' ~ i ~ '][]', - 'title': 'Column'|trans, - 'values': unique_columns, - 'foreign': foreign_column - } only %} - - {% endfor %} - {% else %} - - {% include 'table/relation/relational_dropdown.twig' with { - 'name': 'destination_foreign_column[' ~ i ~ '][]', - 'title': 'Column'|trans, - 'values': [], - 'foreign': '' - } only %} - - {% endif %} - - diff --git a/srcs/phpmyadmin/templates/table/relation/relational_dropdown.twig b/srcs/phpmyadmin/templates/table/relation/relational_dropdown.twig deleted file mode 100644 index 9d5f3c9..0000000 --- a/srcs/phpmyadmin/templates/table/relation/relational_dropdown.twig +++ /dev/null @@ -1,18 +0,0 @@ - diff --git a/srcs/phpmyadmin/templates/table/search/column_comparison_operators.twig b/srcs/phpmyadmin/templates/table/search/column_comparison_operators.twig deleted file mode 100644 index b72e530..0000000 --- a/srcs/phpmyadmin/templates/table/search/column_comparison_operators.twig +++ /dev/null @@ -1,3 +0,0 @@ - diff --git a/srcs/phpmyadmin/templates/table/search/fields_table.twig b/srcs/phpmyadmin/templates/table/search/fields_table.twig deleted file mode 100644 index 8b74939..0000000 --- a/srcs/phpmyadmin/templates/table/search/fields_table.twig +++ /dev/null @@ -1,33 +0,0 @@ - - - - {% if geom_column_flag %} - - {% endif %} - - - - - - - - - {% if search_type == 'zoom' %} - {% include 'table/search/rows_zoom.twig' with { - 'self': self, - 'column_names': column_names, - 'keys': keys, - 'criteria_column_names': criteria_column_names, - 'criteria_column_types': criteria_column_types - } only %} - {% else %} - {% include 'table/search/rows_normal.twig' with { - 'self': self, - 'geom_column_flag': geom_column_flag, - 'column_names': column_names, - 'column_types': column_types, - 'column_collations': column_collations - } only %} - {% endif %} - -
{% trans 'Function' %}{% trans 'Column' %}{% trans 'Type' %}{% trans 'Collation' %}{% trans 'Operator' %}{% trans 'Value' %}
diff --git a/srcs/phpmyadmin/templates/table/search/form_tag.twig b/srcs/phpmyadmin/templates/table/search/form_tag.twig deleted file mode 100644 index 1017abd..0000000 --- a/srcs/phpmyadmin/templates/table/search/form_tag.twig +++ /dev/null @@ -1,4 +0,0 @@ -
- {{ get_hidden_inputs(db, table) }} - - diff --git a/srcs/phpmyadmin/templates/table/search/geom_func.twig b/srcs/phpmyadmin/templates/table/search/geom_func.twig deleted file mode 100644 index f7a7415..0000000 --- a/srcs/phpmyadmin/templates/table/search/geom_func.twig +++ /dev/null @@ -1,19 +0,0 @@ -{# Displays 'Function' column if it is present #} - - {% set geom_types = get_gis_datatypes() %} - {% if column_types[column_index] in geom_types %} - - {% else %} -   - {% endif %} - diff --git a/srcs/phpmyadmin/templates/table/search/input_box.twig b/srcs/phpmyadmin/templates/table/search/input_box.twig deleted file mode 100644 index 5c30535..0000000 --- a/srcs/phpmyadmin/templates/table/search/input_box.twig +++ /dev/null @@ -1,97 +0,0 @@ -{# Get inputbox based on different column types (Foreign key, geometrical, enum) #} -{% if foreigners and search_column_in_foreigners(foreigners, column_name) %} - {% if foreign_data['disp_row'] is iterable %} - - {% elseif foreign_data['foreign_link'] == true %} - - - {{ titles['Browse']|replace({"'": "\\'"})|raw }} - - {% endif %} -{% elseif column_type in get_gis_datatypes() %} - - {% if in_fbs %} - {% set edit_url = 'gis_data_editor.php' ~ get_common() %} - {% set edit_str = get_icon('b_edit', 'Edit/Insert'|trans) %} - - {{ link_or_button(edit_url, edit_str, [], '_blank') }} - - {% endif %} -{% elseif column_type starts with 'enum' - or (column_type starts with 'set' and in_zoom_search_edit) %} - {% set in_zoom_search_edit = false %} - {% set value = column_type|e|slice(5, -1)|replace({''': ''})|split(', ') %} - {% set cnt_value = value|length %} - {# - Enum in edit mode --> dropdown - Enum in search mode --> multiselect - Set in edit mode --> multiselect - Set in search mode --> input (skipped here, so the 'else' section would handle it) - #} - {% if (column_type starts with 'enum' and not in_zoom_search_edit) - or (column_type starts with 'set' and in_zoom_search_edit) %} - - {% endif %} - {# Add select options #} - - {% for i in 0..cnt_value - 1 %} - {% if criteria_values[column_index] is defined - and criteria_values[column_index] is iterable - and value[i] in criteria_values[column_index] %} - - {% else %} - - {% endif %} - {% endfor %} - -{% else %} - {% set the_class = 'textfield' %} - {% if column_type == 'date' %} - {% set the_class = the_class ~ ' datefield' %} - {% elseif column_type == 'datetime' or column_type starts with 'timestamp' %} - {% set the_class = the_class ~ ' datetimefield' %} - {% elseif column_type starts with 'bit' %} - {% set the_class = the_class ~ ' bit' %} - {% endif %} - -{% endif %} diff --git a/srcs/phpmyadmin/templates/table/search/replace_preview.twig b/srcs/phpmyadmin/templates/table/search/replace_preview.twig deleted file mode 100644 index e7a2423..0000000 --- a/srcs/phpmyadmin/templates/table/search/replace_preview.twig +++ /dev/null @@ -1,39 +0,0 @@ - - {{ get_hidden_inputs(db, table) }} - - - - - - -
- {% trans 'Find and replace - preview' %} - - - - - - - - - - {% if result is iterable %} - {% for row in result %} - - {# count #} - {# original #} - {# replaced #} - - {% endfor %} - {% endif %} - -
{% trans 'Count' %}{% trans 'Original string' %}{% trans 'Replaced string' %}
{{ row[2] }}{{ row[0] }}{{ row[1] }}
-
- -
- -
-
diff --git a/srcs/phpmyadmin/templates/table/search/rows_normal.twig b/srcs/phpmyadmin/templates/table/search/rows_normal.twig deleted file mode 100644 index 5e21efa..0000000 --- a/srcs/phpmyadmin/templates/table/search/rows_normal.twig +++ /dev/null @@ -1,39 +0,0 @@ -{% for column_index in 0..column_names|length - 1 %} - - {# If 'Function' column is present trying to change comment #} - {% if geom_column_flag %} - {% include 'table/search/geom_func.twig' with { - 'column_index': column_index, - 'column_types': column_types - } only %} - {% endif %} - {# Displays column's name, type, collation and value #} - - {{ column_names[column_index] }} - - {% set properties = self.getColumnProperties(column_index, column_index) %} - - {{ properties['type'] }} - - - {{ properties['collation'] }} - - - {{ properties['func']|raw }} - - {# here, the data-type attribute is needed for a date/time picker #} - - {{ properties['value']|raw }} - {# Displays hidden fields #} - - - - - -{% endfor %} diff --git a/srcs/phpmyadmin/templates/table/search/rows_zoom.twig b/srcs/phpmyadmin/templates/table/search/rows_zoom.twig deleted file mode 100644 index dc46f1d..0000000 --- a/srcs/phpmyadmin/templates/table/search/rows_zoom.twig +++ /dev/null @@ -1,74 +0,0 @@ -{# Get already set search criteria (if any) #} -{% set type = [] %} -{% set collation = [] %} -{% set func = [] %} -{% set value = [] %} - -{% for i in 0..3 %} - {# After X-Axis and Y-Axis column rows, display additional criteria option #} - {% if i == 2 %} - - - {% trans 'Additional search criteria' %} - - - {% endif %} - - - - - {% if criteria_column_names[i] is defined - and criteria_column_names[i] != 'pma_null' %} - {% set key = keys[criteria_column_names[i]] %} - {% set properties = self.getColumnProperties(i, key) %} - {% set type = type|merge({i: properties['type']}) %} - {% set collation = collation|merge({i: properties['collation']}) %} - {% set func = func|merge({i: properties['func']}) %} - {% set value = value|merge({i: properties['value']}) %} - {% endif %} - {# Column type #} - - {{ type[i] is defined ? type[i] }} - - {# Column Collation #} - - {{ collation[i] is defined ? collation[i] }} - - {# Select options for column operators #} - - {{ func[i] is defined ? func[i]|raw }} - - {# Inputbox for search criteria value #} - - - - {{ value[i] is defined ? value[i]|raw }} - {# Displays hidden fields #} - - - - -{% endfor %} diff --git a/srcs/phpmyadmin/templates/table/search/selection_form.twig b/srcs/phpmyadmin/templates/table/search/selection_form.twig deleted file mode 100644 index 2ba4d60..0000000 --- a/srcs/phpmyadmin/templates/table/search/selection_form.twig +++ /dev/null @@ -1,226 +0,0 @@ -{% if search_type == 'zoom' %} - {% include 'table/search/form_tag.twig' with { - 'script_name': 'tbl_zoom_select.php', - 'form_id': 'zoom_search_form', - 'db': db, - 'table': table, - 'goto': goto - } only %} - -{% elseif search_type == 'normal' %} - {% include 'table/search/form_tag.twig' with { - 'script_name': 'tbl_select.php', - 'form_id': 'tbl_search_form', - 'db': db, - 'table': table, - 'goto': goto - } only %} - -{% elseif search_type == 'replace' %} - {% include 'table/search/form_tag.twig' with { - 'script_name': 'tbl_find_replace.php', - 'form_id': 'find_replace_form', - 'db': db, - 'table': table, - 'goto': goto - } only %} -
-
- - {% trans 'Find and replace' %} - {% trans 'Find:' %} - - {% trans 'Replace with:' %} - - - {% trans 'Column:' %} - - - {% include 'checkbox.twig' with { - 'html_field_id': 'useRegex', - 'html_field_name': 'useRegex', - 'label': 'Use regular expression'|trans, - 'checked': false, - 'onclick': false - } only %} -
-
-{% else %} - {% include 'table/search/form_tag.twig' with { - 'script_name': '', - 'form_id': '', - 'db': db, - 'table': table, - 'goto': goto - } only %} -{% endif %} - -{# Displays selection form's footer elements #} -
- -
- -
diff --git a/srcs/phpmyadmin/templates/table/search/zoom_result_form.twig b/srcs/phpmyadmin/templates/table/search/zoom_result_form.twig deleted file mode 100644 index 7543f85..0000000 --- a/srcs/phpmyadmin/templates/table/search/zoom_result_form.twig +++ /dev/null @@ -1,86 +0,0 @@ -
- {{ get_hidden_inputs(db, table) }} - - - -
- {% trans 'Browse/Edit the points' %} - - {# JSON encode the data(query result) #} -
- {% if zoom_submit and data is not empty %} -
-
- - {% trans 'How to use' %} - -
-
- {{ data_json }} -
-
- -
- {% endif %} -
- - {# Displays rows in point edit form #} -
- - - - - - - - - - {% for column_index in 0..column_names|length - 1 %} - {% set field_popup = column_names[column_index] %} - {% set foreign_data = get_foreign_data( - foreigners, - field_popup, - false, - '', - '' - ) %} - - - {# Null checkbox if column can be null #} - - {# Column's Input box #} - - - {% endfor %} - -
{% trans 'Column' %}{% trans 'Null' %}{% trans 'Value' %}
{{ column_names[column_index] }} - {% if column_null_flags[column_index] == 'YES' %} - - {% endif %} - - {% include 'table/search/input_box.twig' with { - 'str': '', - 'column_type': column_types[column_index], - 'column_id': column_types[column_index] ? 'edit_fieldID_' : 'fieldID_', - 'in_zoom_search_edit': true, - 'foreigners': foreigners, - 'column_name': field_popup, - 'column_name_hash': column_name_hashes[field_popup], - 'foreign_data': foreign_data, - 'table': table, - 'column_index': column_index, - 'foreign_max_limit': foreign_max_limit, - 'criteria_values': '', - 'db': db, - 'titles': titles, - 'in_fbs': false - } only %} -
-
- -
-
diff --git a/srcs/phpmyadmin/templates/table/structure/action_row_in_structure_table.twig b/srcs/phpmyadmin/templates/table/structure/action_row_in_structure_table.twig deleted file mode 100644 index d9c629c..0000000 --- a/srcs/phpmyadmin/templates/table/structure/action_row_in_structure_table.twig +++ /dev/null @@ -1,31 +0,0 @@ -
  • -{% if type == 'text' - or type == 'blob' - or tbl_storage_engine == 'ARCHIVE' - or has_field %} - {{ titles['No' ~ action]|raw }} -{% else %} - - {{ titles[action]|raw }} - -{% endif %} -
    • diff --git a/srcs/phpmyadmin/templates/table/structure/display_partitions.twig b/srcs/phpmyadmin/templates/table/structure/display_partitions.twig deleted file mode 100644 index b10a0bc..0000000 --- a/srcs/phpmyadmin/templates/table/structure/display_partitions.twig +++ /dev/null @@ -1,145 +0,0 @@ -
    -
    - - {% trans 'Partitions' %} - {{ show_mysql_docu('partitioning') }} - - {% if partitions is empty %} - {{ 'No partitioning defined!'|trans|notice }} - {% else %} -

    - {% trans 'Partitioned by:' %} - {{ partition_method }}({{ partition_expression }}) -

    - {% if has_sub_partitions %} -

    - {% trans 'Sub partitioned by:' %} - {{ sub_partition_method }}({{ sub_partition_expression }}) -

    - {% endif %} - - - - - - {% if has_description %} - - {% endif %} - - - - - - - - - {% for partition in partitions %} - - {% if has_sub_partitions %} - - - {% else %} - - {% endif %} - - {% if has_description %} - - {% endif %} - - - - - {% for action, icon in action_icons %} - - {% endfor %} - - {% if has_sub_partitions %} - {% for sub_partition in partition.getSubPartitions() %} - - - - - {% if has_description %} - - {% endif %} - - - - - - - {% endfor %} - {% endif %} - - {% endfor %} - -
    #{% trans 'Partition' %}{% trans 'Expression' %}{% trans 'Rows' %}{% trans 'Data length' %}{% trans 'Index length' %}{% trans 'Comment' %} - {% trans 'Action' %} -
    {{ partition.getOrdinal() }}{{ partition.getOrdinal() }}{{ partition.getName() }} - - {{- partition.getExpression() -}} - {{- partition.getMethod() == 'LIST' ? ' IN (' : ' < ' -}} - {{- partition.getDescription() -}} - {{- partition.getMethod() == 'LIST' ? ')' -}} - - {{ partition.getRows() }} - {% set data_length = format_byte_down( - partition.getDataLength(), - 3, - 1 - ) %} - {{ data_length[0] }} - {{ data_length[1] }} - - {% set index_length = format_byte_down( - partition.getIndexLength(), - 3, - 1 - ) %} - {{ index_length[0] }} - {{ index_length[1] }} - {{ partition.getComment() }} - - {{ icon|raw }} - -
    {{ sub_partition.getOrdinal() }}{{ sub_partition.getName() }}{{ sub_partition.getRows() }} - {% set data_length = format_byte_down( - sub_partition.getDataLength(), - 3, - 1 - ) %} - {{ data_length[0] }} - {{ data_length[1] }} - - {% set index_length = format_byte_down( - sub_partition.getIndexLength(), - 3, - 1 - ) %} - {{ index_length[0] }} - {{ index_length[1] }} - {{ sub_partition.getComment() }}
    - {% endif %} -

    -
    -
    - {{ get_hidden_inputs(db, table) }} - - {% if partitions is empty %} - - {% else %} - {{ link_or_button(remove_url, 'Remove partitioning'|trans, { - 'class': 'button ajax', - 'id': 'remove_partitioning' - }) }} - - {% endif %} -
    -
    -
    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 %} diff --git a/srcs/phpmyadmin/templates/table/structure/display_table_stats.twig b/srcs/phpmyadmin/templates/table/structure/display_table_stats.twig deleted file mode 100644 index 01c74ae..0000000 --- a/srcs/phpmyadmin/templates/table/structure/display_table_stats.twig +++ /dev/null @@ -1,169 +0,0 @@ -
      -
      - {% trans 'Information' %} - {% if showtable['TABLE_COMMENT'] %} -

      - {% trans 'Table comments:' %} - {{ showtable['TABLE_COMMENT'] }} -

      - {% endif %} - - - {% if not tbl_is_view and not db_is_system_schema %} - - - - - - - - - - {% if index_size is defined %} - - - - - - {% endif %} - - {% if free_size is defined %} - - - - - - - - - - - {% endif %} - - {% if tot_size is defined and mergetable == false %} - - - - - - {% endif %} - - {# Optimize link if overhead #} - {% if free_size is defined - and (tbl_storage_engine == 'MYISAM' - or tbl_storage_engine == 'ARIA' - or tbl_storage_engine == 'MARIA' - or tbl_storage_engine == 'BDB') - or (tbl_storage_engine == 'INNODB' and innodb_file_per_table == true) %} - - - - {% endif %} - -
      {% trans 'Space usage' %}
      {% trans 'Data' %}{{ data_size }}{{ data_unit }}
      {% trans 'Index' %}{{ index_size }}{{ index_unit }}
      {% trans 'Overhead' %}{{ free_size }}{{ free_unit }}
      {% trans 'Effective' %}{{ effect_size }}{{ effect_unit }}
      {% trans 'Total' %}{{ tot_size }}{{ tot_unit }}
      - - {{ get_icon('b_tbloptimize', 'Optimize table'|trans) }} - -
      - {% endif %} - - {% set avg_size = avg_size is defined ? avg_size : null %} - {% set avg_unit = avg_unit is defined ? avg_unit : null %} - - - - {% if showtable['Row_format'] is defined %} - - - {% if showtable['Row_format'] == 'Fixed' %} - - {% elseif showtable['Row_format'] == 'Dynamic' %} - - {% else %} - - {% endif %} - - {% endif %} - - {% if showtable['Create_options'] is not empty %} - - - {% if showtable['Create_options'] == 'partitioned' %} - - {% else %} - - {% endif %} - - {% endif %} - - {% if table_collation is not empty %} - - - - - {% endif %} - - {% if not is_innodb and showtable['Rows'] is defined %} - - - - - {% endif %} - - {% if not is_innodb - and showtable['Avg_row_length'] is defined - and showtable['Avg_row_length'] > 0 %} - - - {% set avg_row_length = format_byte_down(showtable['Avg_row_length'], 6, 1) %} - - - {% endif %} - - {% if not is_innodb - and showtable['Data_length'] is defined - and showtable['Rows'] is defined - and showtable['Rows'] > 0 - and mergetable == false %} - - - - - {% endif %} - - {% if showtable['Auto_increment'] is defined %} - - - - - {% endif %} - - {% if showtable['Create_time'] is defined %} - - - - - {% endif %} - - {% if showtable['Update_time'] is defined %} - - - - - {% endif %} - - {% if showtable['Check_time'] is defined %} - - - - - {% endif %} - -
      {% trans 'Row statistics' %}
      {% trans 'Format' %}{% trans 'static' %}{% trans 'dynamic' %}{{ showtable['Row_format'] }}
      {% trans 'Options' %}{% trans 'partitioned' %}{{ showtable['Create_options'] }}
      {% trans 'Collation' %} - - {{ table_collation.name }} - -
      {% trans 'Rows' %}{{ format_number(showtable['Rows'], 0) }}
      {% trans 'Row length' %}{{ avg_row_length[0] }} {{ avg_row_length[1] }}
      {% trans 'Row size' %}{{ avg_size }} {{ avg_unit }}
      {% trans 'Next autoindex' %}{{ format_number(showtable['Auto_increment'], 0) }}
      {% trans 'Creation' %}{{ localised_date(showtable['Create_time']|date('U')) }}
      {% trans 'Last update' %}{{ localised_date(showtable['Update_time']|date('U')) }}
      {% trans 'Last check' %}{{ localised_date(showtable['Check_time']|date('U')) }}
      -
      -
      diff --git a/srcs/phpmyadmin/templates/table/structure/partition_definition_form.twig b/srcs/phpmyadmin/templates/table/structure/partition_definition_form.twig deleted file mode 100644 index 7cf5e8d..0000000 --- a/srcs/phpmyadmin/templates/table/structure/partition_definition_form.twig +++ /dev/null @@ -1,14 +0,0 @@ -
      - {{ get_hidden_inputs(db, table) }} - - -
      - {% trans 'Edit partitioning' %} - {% include 'columns_definitions/partitions.twig' with { - 'partition_details': partition_details - } only %} -
      -
      - -
      -
      diff --git a/srcs/phpmyadmin/templates/table/tracking/main.twig b/srcs/phpmyadmin/templates/table/tracking/main.twig deleted file mode 100644 index ff6c5c4..0000000 --- a/srcs/phpmyadmin/templates/table/tracking/main.twig +++ /dev/null @@ -1,132 +0,0 @@ -{% if selectable_tables_num_rows > 0 %} -
      - {{ get_hidden_inputs(db, table) }} - - -
      -{% endif %} -
      -{% if last_version > 0 %} -
      - {{ get_hidden_inputs(db, table) }} - - - - - - - - - - - - - - {% for version in versions %} - - - - - - {% if version['tracking_active'] == 1 %} - {% set last_version_status = 1 %} - - {% else %} - {% set last_version_status = 0 %} - - {% endif %} - - - - {% endfor %} - -
      {% trans 'Version' %}{% trans 'Created' %}{% trans 'Updated' %}{% trans 'Status' %}{% trans 'Action' %}{% trans 'Show' %}
      - - - - {{ version['date_created']|escape }}{{ version['date_updated']|escape }}{% trans 'active' %}{% trans 'not active' %} - - {{ get_icon('b_drop', 'Delete version'|trans) }} - - - - {{ get_icon('b_report', 'Tracking report'|trans) }} - - - {{ get_icon('b_props', 'Structure snapshot'|trans) }} - -
      - {% include 'select_all.twig' with { - 'pma_theme_image': pmaThemeImage, - 'text_dir': text_dir, - 'form_name': 'versionsForm', - } only %} - {{ get_button_or_image( - 'submit_mult', - 'mult_submit', - 'Delete version'|trans, - 'b_drop', - 'delete_version' - ) }} -
      - {% set last_version_element = versions|first %} -
      -
      - {{ get_hidden_inputs(db, table) }} -
      - - {% if last_version_element['tracking_active'] == 0 %} - {% set legend = 'Activate tracking for %s'|trans %} - {% set value = 'activate_now' %} - {% set button = 'Activate now'|trans %} - {% else %} - {% set legend = 'Deactivate tracking for %s'|trans %} - {% set value = 'deactivate_now' %} - {% set button = 'Deactivate now'|trans %} - {% endif %} - - {{ legend|format(db ~ '.' ~ table) }} - - - - -
      -
      -
      -{% endif %} -{% include 'create_tracking_version.twig' with { - 'url_query': url_query, - 'last_version': last_version, - 'db': db, - 'selected': [table], - 'type': type, - 'default_statements': default_statements, -} only %} diff --git a/srcs/phpmyadmin/templates/table/tracking/report_table.twig b/srcs/phpmyadmin/templates/table/tracking/report_table.twig deleted file mode 100644 index fe00526..0000000 --- a/srcs/phpmyadmin/templates/table/tracking/report_table.twig +++ /dev/null @@ -1,27 +0,0 @@ - - - - - - - - - - - - {% for entry in entries %} - - - - - - - - {% endfor %} - -
      {% trans %}#{% context %}Number{% endtrans %}{% trans 'Date' %}{% trans 'Username' %}{{ header_message }}{% trans 'Action' %}
      {{ entry.line_number }}{{ entry.date }}{{ entry.username }}{{ entry.formated_statement|raw }} - - {{ drop_image_or_text|raw }} - -
      diff --git a/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_columns.twig b/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_columns.twig deleted file mode 100644 index 4ef8c21..0000000 --- a/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_columns.twig +++ /dev/null @@ -1,56 +0,0 @@ -

      {% trans 'Structure' %}

      - - - - - - - - - - - - - - - {% set index = 1 %} - {% for field in columns %} - - - {% set index = index + 1 %} - - - - - - - - - {% endfor %} - -
      {% trans %}#{% context %}Number{% endtrans %}{% trans 'Column' %}{% trans 'Type' %}{% trans 'Collation' %}{% trans 'Null' %}{% trans 'Default' %}{% trans 'Extra' %}{% trans 'Comment' %}
      {{ index }} - - {{ field['Field'] }} - {% if field['Key'] == 'PRI' %} - {{ get_image('b_primary', 'Primary'|trans) }} - {% elseif field['Key'] is not empty %} - {{ get_image('bd_primary', 'Index'|trans) }} - {% endif %} - - {{ field['Type'] }}{{ field['Collation'] }}{{ field['Null'] == 'YES' ? 'Yes'|trans : 'No'|trans }} - {% if field['Default'] is defined %} - {% set extracted_columnspec = extract_column_spec(field['Type']) %} - {% if extracted_columnspec['type'] == 'bit' %} - {# here, $field['Default'] contains something like b'010' #} - {{ field['Default']|convert_bit_default_value }} - {% else %} - {{ field['Default'] }} - {% endif %} - {% else %} - {% if field['Null'] == 'YES' %} - NULL - {% else %} - {% trans %}None{% context %}None for default{% endtrans %} - {% endif %} - {% endif %} - {{ field['Extra'] }}{{ field['Comment'] }}
      diff --git a/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_indexes.twig b/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_indexes.twig deleted file mode 100644 index a919252..0000000 --- a/srcs/phpmyadmin/templates/table/tracking/structure_snapshot_indexes.twig +++ /dev/null @@ -1,33 +0,0 @@ -

      {% trans 'Indexes' %}

      - - - - - - - - - - - - - - - - {% for index in indexes %} - - - - - - - - - - - - {% endfor %} - -
      {% trans 'Keyname' %}{% trans 'Type' %}{% trans 'Unique' %}{% trans 'Packed' %}{% trans 'Column' %}{% trans 'Cardinality' %}{% trans 'Collation' %}{% trans 'Null' %}{% trans 'Comment' %}
      - {{ index['Key_name'] }} - {{ index['Index_type'] }}{{ index['Non_unique'] == 0 ? 'Yes'|trans : 'No'|trans }}{{ index['Packed'] != '' ? 'Yes'|trans : 'No'|trans }}{{ index['Column_name'] }}{{ index['Cardinality'] }}{{ index['Collation'] }}{{ index['Null'] }}{{ index['Comment'] }}
      -- cgit