<tr id="row_tbl_{{ curr }}"{{ table_is_view ? ' class="is_view"' }} data-filter-row="{{ current_table['TABLE_NAME']|upper }}"> <td class="text-center d-print-none"> <input type="checkbox" name="selected_tbl[]" class="{{ input_class }}" value="{{ current_table['TABLE_NAME'] }}" id="checkbox_tbl_{{ curr }}"> </td> <th> <a href="{{ url('/sql', table_url_params|merge({'pos': 0})) }}" title="{{ browse_table_label_title }}"> {{- browse_table_label_truename -}} </a> {{ tracking_icon|raw }} </th> {% if server_replica_status %} <td class="text-center"> {{ ignored ? get_image('s_cancel', 'Not replicated'|trans) }} {{ do ? get_image('s_success', 'Replicated'|trans) }} </td> {% endif %} {# Favorite table anchor #} {% if num_favorite_tables > 0 %} <td class="text-center d-print-none"> {# Check if current table is already in favorite list #} {% set fav_params = { 'db': db, 'ajax_request': true, 'favorite_table': current_table['TABLE_NAME'], ((already_favorite ? 'remove' : 'add') ~ '_favorite'): true } %} {% include 'database/structure/favorite_anchor.twig' with { 'table_name_hash': table_name_hash, 'db_table_name_hash': db_table_name_hash, 'fav_params': fav_params, 'already_favorite': already_favorite, } only %} </td> {% endif %} <td class="text-center d-print-none"> <a href="{{ url('/sql', table_url_params|merge({'pos': 0})) }}"> {{ may_have_rows ? get_icon('b_browse', 'Browse'|trans) : get_icon('bd_browse', 'Browse'|trans) }} </a> </td> <td class="text-center d-print-none"> <a href="{{ url('/table/structure', table_url_params) }}"> {{ get_icon('b_props', 'Structure'|trans) }} </a> </td> <td class="text-center d-print-none"> <a href="{{ url('/table/search', table_url_params) }}"> {{ may_have_rows ? get_icon('b_select', 'Search'|trans) : get_icon('bd_select', 'Search'|trans) }} </a> </td> {% if not db_is_system_schema %} <td class="insert_table text-center d-print-none"> <a href="{{ url('/table/change', table_url_params) }}">{{ get_icon('b_insrow', 'Insert'|trans) }}</a> </td> {% if table_is_view %} <td class="text-center d-print-none"> <a href="{{ url('/view/create', { 'db': db, 'table': current_table['TABLE_NAME'] }) }}">{{ get_icon('b_edit', 'Edit'|trans) }}</a> </td> {% else %} <td class="text-center d-print-none"> <a class="truncate_table_anchor ajax" href="{{ url('/sql') }}" data-post="{{ get_common(table_url_params|merge({ 'sql_query': empty_table_sql_query, 'message_to_show': empty_table_message_to_show }), '') }}"> {{ may_have_rows ? get_icon('b_empty', 'Empty'|trans) : get_icon('bd_empty', 'Empty'|trans) }} </a> </td> {% endif %} <td class="text-center d-print-none"> <a class="ajax drop_table_anchor {{- table_is_view or current_table['ENGINE'] == null ? ' view' }}" href="{{ url('/sql') }}" data-post=" {{- get_common(table_url_params|merge({ 'reload': 1, 'purge': 1, 'sql_query': drop_query, 'message_to_show': drop_message }), '') }}"> {{ get_icon('b_drop', 'Drop'|trans) }} </a> </td> {% endif %} {% if current_table['TABLE_ROWS'] is defined and (current_table['ENGINE'] != null or table_is_view) %} {# Get the row count #} {% set row_count = format_number(current_table['TABLE_ROWS'], 0) %} {# Content to be appended into 'tbl_rows' cell. If row count is approximate, display it as an anchor to get real count. #} <td class="value tbl_rows font-monospace text-end" data-table="{{ current_table['TABLE_NAME'] }}"> {% if approx_rows %} <a href="{{ url('/database/structure/real-row-count', { 'ajax_request': true, 'db': db, 'table': current_table['TABLE_NAME'] }) }}" class="ajax real_row_count"> <bdi> ~{{ row_count }} </bdi> </a> {% else %} {{ row_count }} {% endif %} {{ show_superscript|raw }} </td> {% if not (properties_num_columns > 1) %} <td class="text-nowrap"> {% if current_table['ENGINE'] is not empty %} {{ current_table['ENGINE'] }} {% elseif table_is_view %} {% trans 'View' %} {% endif %} </td> {% if collation|length > 0 %} <td class="text-nowrap"> {{ collation|raw }} </td> {% endif %} {% endif %} {% if is_show_stats %} <td class="value tbl_size font-monospace text-end"> <a href="{{ url('/table/structure', table_url_params) }}#showusage"> <span>{{ formatted_size }}</span>&nbsp;<span class="unit">{{ unit }}</span> </a> </td> <td class="value tbl_overhead font-monospace text-end"> {{ overhead|raw }} </td> {% endif %} {% if not (show_charset > 1) %} {% if charset|length > 0 %} <td class="text-nowrap"> {{ charset|raw }} </td> {% endif %} {% endif %} {% if show_comment %} {% set comment = current_table['Comment'] %} <td> {% if comment|length > limit_chars %} <abbr title="{{ comment }}"> {{ comment|slice(0, limit_chars) }} ... </abbr> {% else %} {{ comment }} {% endif %} </td> {% endif %} {% if show_creation %} <td class="value tbl_creation font-monospace text-end"> {{ create_time }} </td> {% endif %} {% if show_last_update %} <td class="value tbl_last_update font-monospace text-end"> {{ update_time }} </td> {% endif %} {% if show_last_check %} <td class="value tbl_last_check font-monospace text-end"> {{ check_time }} </td> {% endif %} {% elseif table_is_view %} <td class="value tbl_rows font-monospace text-end">-</td> <td class="text-nowrap"> {% trans 'View' %} </td> <td class="text-nowrap">---</td> {% if is_show_stats %} <td class="value tbl_size font-monospace text-end">-</td> <td class="value tbl_overhead font-monospace text-end">-</td> {% endif %} {% if show_charset %} <td></td> {% endif %} {% if show_comment %} <td></td> {% endif %} {% if show_creation %} <td class="value tbl_creation font-monospace text-end">-</td> {% endif %} {% if show_last_update %} <td class="value tbl_last_update font-monospace text-end">-</td> {% endif %} {% if show_last_check %} <td class="value tbl_last_check font-monospace text-end">-</td> {% endif %} {% else %} {% if db_is_system_schema %} {% set action_colspan = 3 %} {% else %} {% set action_colspan = 6 %} {% endif %} {% if num_favorite_tables > 0 %} {% set action_colspan = action_colspan + 1 %} {% endif %} {% set colspan_for_structure = action_colspan + 3 %} <td colspan="{{ colspan_for_structure - db_is_system_schema ? 6 : 9 }}" class="text-center"> {% trans 'in use' %} </td> {% endif %} </tr>