{% if not hide_order_table %} {% endif %}

{{ get_hidden_inputs(db, table) }} {% if has_auto_increment %} {% endif %}

{% trans 'Table options' %}

{% trans 'Rename table to' %}

{% trans 'Adjust privileges' %} {{ show_docu('faq', 'faq6-39') }}

{% trans 'Table comments' %}

{% trans 'Storage engine' %} {{ show_mysql_docu('Storage_engines') }}

{% trans 'Collation' %}

{% trans 'Change all column collations' %}

{% if has_pack_keys %}

PACK_KEYS

{% endif %} {% if has_checksum_and_delay_key_write %}

CHECKSUM

DELAY_KEY_WRITE

{% endif %} {% if has_transactional_and_page_checksum %}

TRANSACTIONAL

PAGE_CHECKSUM

{% endif %} {% if has_auto_increment %}

AUTO_INCREMENT

{% endif %} {% if row_formats is not empty %}

ROW_FORMAT

{% endif %}

{% trans 'Copy table to (database.table)' %}

{% if database_list is not empty %} {% else %} {% endif %} .

{% trans 'Structure only' %}

{% trans 'Structure and data' %}

{% trans 'Data only' %}

{% trans 'Add AUTO_INCREMENT value' %}

{% if has_foreign_keys %}

{% trans 'Add constraints' %}

{% endif %}

{% trans 'Adjust privileges' %} {{ show_docu('faq', 'faq6-39') }}

{% trans 'Switch to copied table' %}

{% trans 'Table maintenance' %}

{% trans 'Analyze table' %} {{ show_mysql_docu('ANALYZE_TABLE') }}
{% trans 'Check table' %} {{ show_mysql_docu('CHECK_TABLE') }}
{% trans 'Checksum table' %} {{ show_mysql_docu('CHECKSUM_TABLE') }}
{% trans 'Defragment table' %} {{ show_mysql_docu('InnoDB_File_Defragmenting') }}
{% trans 'Flush the table (FLUSH)' %} {{ show_mysql_docu('FLUSH') }}
{% trans 'Optimize table' %} {{ show_mysql_docu('OPTIMIZE_TABLE') }}
{% trans 'Repair table' %} {{ show_mysql_docu('REPAIR_TABLE') }}

{% if not is_system_schema %}

{% trans 'Delete data or table' %}

{{ link_or_button( url('/sql'), url_params|merge({ 'sql_query': 'TRUNCATE TABLE ' ~ backquote(db) ~ '.' ~ backquote(table), 'goto': url('/table/structure'), 'reload': true, 'message_to_show': 'Table %s has been emptied.'|trans|format(table)|e }), 'Empty the table (TRUNCATE)'|trans, { 'id': 'truncate_tbl_anchor', 'class': 'text-danger ajax', 'data-query': 'TRUNCATE TABLE ' ~ backquote(db) ~ '.' ~ backquote(table) } ) }} {{ show_mysql_docu('TRUNCATE_TABLE') }}
{{ link_or_button( url('/sql'), url_params|merge({ 'sql_query': 'DELETE FROM ' ~ backquote(db) ~ '.' ~ backquote(table), 'goto': url('/table/structure'), 'reload': true, 'message_to_show': 'Table %s has been emptied.'|trans|format(table)|e }), 'Empty the table (DELETE FROM)'|trans, { 'id': 'delete_tbl_anchor', 'class': 'text-danger ajax', 'data-query': 'DELETE FROM ' ~ backquote(db) ~ '.' ~ backquote(table) } ) }} {{ show_mysql_docu('DELETE') }}
{{ link_or_button( url('/sql'), url_params|merge({ 'sql_query': 'DROP TABLE ' ~ backquote(db) ~ '.' ~ backquote(table), 'goto': url('/database/operations'), 'reload': true, 'purge': true, 'message_to_show': is_view ? 'View %s has been dropped.'|trans|format(table)|e : 'Table %s has been dropped.'|trans|format(table)|e, 'table': table }), 'Delete the table (DROP)'|trans, { 'id': 'drop_tbl_anchor', 'class': 'text-danger ajax', 'data-query': 'DROP TABLE ' ~ backquote(db) ~ '.' ~ backquote(table) } ) }} {{ show_mysql_docu('DROP_TABLE') }}

{% endif %} {% if partitions is not empty %} {% endif %} {% if foreigners is not empty %}

{% trans 'Check referential integrity' %}

{% endif %}