You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
226 lines
8.3 KiB
226 lines
8.3 KiB
<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> <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>
|
|
|