diff options
Diffstat (limited to 'srcs/phpmyadmin/templates/database')
27 files changed, 2871 insertions, 0 deletions
diff --git a/srcs/phpmyadmin/templates/database/central_columns/edit_table_header.twig b/srcs/phpmyadmin/templates/database/central_columns/edit_table_header.twig new file mode 100644 index 0000000..947d841 --- /dev/null +++ b/srcs/phpmyadmin/templates/database/central_columns/edit_table_header.twig @@ -0,0 +1,9 @@ +<table id="table_columns" class="noclick"> + <caption class="tblHeaders">{% trans 'Structure' %}</caption> + <thead> + <tr> + {% for header in headers %} + <th>{{ header }}</th> + {% endfor %} + </tr> + </thead> diff --git a/srcs/phpmyadmin/templates/database/central_columns/main.twig b/srcs/phpmyadmin/templates/database/central_columns/main.twig new file mode 100644 index 0000000..30b7276 --- /dev/null +++ b/srcs/phpmyadmin/templates/database/central_columns/main.twig @@ -0,0 +1,418 @@ +{# getHtmlForAddNewColumn #} +<div id="add_col_div" class="topmargin"> + <a href="#"> + <span>{{ (total_rows > 0) ? '+' : '-' }}</span>{% trans 'Add new column' %} + </a> + <form id="add_new" class="new_central_col{{ (total_rows != 0) ? ' hide' : ''}}" + method="post" action="db_central_columns.php"> + {{ get_hidden_inputs(db) }} + <input type="hidden" name="add_new_column" value="add_new_column"> + <div class="responsivetable"> + <table> + <thead> + <tr> + <th class=""></th> + <th class="hide"></th> + <th class="" title="" data-column="name"> + {% trans 'Name' %} + <div class="sorticon"></div> + </th> + <th class="" title="" data-column="type"> + {% trans 'Type' %} + <div class="sorticon"></div> + </th> + <th class="" title="" data-column="length"> + {% trans 'Length/Value' %} + <div class="sorticon"></div> + </th> + <th class="" title="" data-column="default"> + {% trans 'Default' %} + <div class="sorticon"></div> + </th> + <th class="" title="" data-column="collation"> + {% trans 'Collation' %} + <div class="sorticon"></div> + </th> + <th class="" title="" data-column="attribute"> + {% trans 'Attribute' %} + <div class="sorticon"></div> + </th> + <th class="" title="" data-column="isnull"> + {% trans 'Null' %} + <div class="sorticon"></div> + </th> + <th class="" title="" data-column="extra"> + {% trans 'A_I' %} + <div class="sorticon"></div> + </th> + </tr> + </thead> + <tbody> + <tr> + <td></td> + <td name="col_name" class="nowrap"> + {% include 'columns_definitions/column_name.twig' with { + 'column_number': 0, + 'ci': 0, + 'ci_offset': 0, + 'column_meta': {}, + 'cfg_relation': { + 'centralcolumnswork': false + }, + 'max_rows': max_rows, + } only %} + </td> + <td name="col_type" class="nowrap"> + {% include 'columns_definitions/column_type.twig' with { + 'column_number': 0, + 'ci': 1, + 'ci_offset': 0, + 'type_upper': '', + 'column_meta': {} + } only %} + </td> + <td class="nowrap" name="col_length"> + {% include 'columns_definitions/column_length.twig' with { + 'column_number': 0, + 'ci': 2, + 'ci_offset': 0, + 'length_values_input_size': 8, + 'length_to_display': '' + } only %} + </td> + <td class="nowrap" name="col_default"> + {% include 'columns_definitions/column_default.twig' with { + 'column_number': 0, + 'ci': 3, + 'ci_offset': 0, + 'type_upper': '', + 'column_meta': {}, + 'char_editing': char_editing, + } only %} + </td> + <td name="collation" class="nowrap"> + <select lang="en" dir="ltr" name="field_collation[0]" id="field_0_4"> + <option value=""></option> + {% for charset in charsets %} + <optgroup label="{{ charset.name }}" title="{{ charset.description }}"> + {% for collation in charset.collations %} + <option value="{{ collation.name }}" title="{{ collation.description }}"> + {{- collation.name -}} + </option> + {% endfor %} + </optgroup> + {% endfor %} + </select> + </td> + <td class="nowrap" name="col_attribute"> + {% include 'columns_definitions/column_attribute.twig' with { + 'column_number': 0, + 'ci': 5, + 'ci_offset': 0, + 'extracted_columnspec': {}, + 'column_meta': {}, + 'submit_attribute': false, + 'attribute_types': attribute_types, + } only %} + </td> + <td class="nowrap" name="col_isNull"> + {% include 'columns_definitions/column_null.twig' with { + 'column_number': 0, + 'ci': 6, + 'ci_offset': 0, + 'column_meta': {} + } only %} + </td> + <td class="nowrap" name="col_extra"> + {% include 'columns_definitions/column_extra.twig' with { + 'column_number': 0, + 'ci': 7, + 'ci_offset': 0, + 'column_meta': {} + } only %} + </td> + <td> + <input id="add_column_save" class="btn btn-primary" type="submit" value="Save"> + </td> + </tr> + </tbody> + </table> + </div> + </form> +</div> +{% if total_rows <= 0 %} + <fieldset> + {% trans 'The central list of columns for the current database is empty' %} + </fieldset> +{% else %} + <table style="display:inline-block;max-width:49%" class="navigation nospacing nopadding"> + <tr> + <td class="navigation_separator"></td> + {% if pos - max_rows >= 0 %} + <td> + <form action="db_central_columns.php" method="post"> + {{ get_hidden_inputs(db) }} + <input type="hidden" name="pos" value="{{ pos - max_rows }}"> + <input type="hidden" name="total_rows" value="{{ total_rows }}"> + <input class="btn btn-secondary ajax" type="submit" name="navig" value="<"> + </form> + </td> + {% endif %} + {% if tn_nbTotalPage > 1 %} + <td> + <form action="db_central_columns.php" method="post"> + {{ get_hidden_inputs(db) }} + <input type="hidden" name="total_rows" value="{{ total_rows }}"> + {{ tn_page_selector | raw }} + </form> + </td> + {% endif %} + {% if pos + max_rows < total_rows %} + <td> + <form action="db_central_columns.php" method="post"> + {{ get_hidden_inputs(db) }} + <input type="hidden" name="pos" value="{{ pos + max_rows }}"> + <input type="hidden" name="total_rows" value="{{ total_rows }}"> + <input class="btn btn-secondary ajax" type="submit" name="navig" value=">"> + </form> + </td> + {% endif %} + <td class="navigation_separator"></td> + <td> + <span>{% trans 'Filter rows' %}:</span> + <input type="text" class="filter_rows" placeholder="{% trans 'Search this table' %}"> + </td> + <td class="navigation_separator"></td> + </tr> + </table> +{% endif %} +{# getHtmlForAddColumn #} +<table class="central_columns_add_column" class="navigation nospacing nopadding"> + <tr> + <td class="navigation_separator largescreenonly"></td> + <td class="central_columns_navigation"> + {{ get_icon('centralColumns_add', 'Add column' | trans)|raw }} + <form id="add_column" action="db_central_columns.php" method="post"> + {{ get_hidden_inputs(db) | raw }} + <input type="hidden" name="add_column" value="add"> + <input type="hidden" name="pos" value="{{ pos }}"> + <input type="hidden" name="total_rows" value="{{ total_rows }}"> + {# getHtmlForTableDropdown #} + <select name="table-select" id="table-select"> + <option value="" disabled="disabled" selected="selected"> + {% trans 'Select a table' %} + </option> + {% for table in tables %} + <option value="{{ table|e }}">{{ table|e }}</option> + {% endfor %} + </select> + <select name="column-select" id="column-select"> + <option value="" selected="selected">{% trans 'Select a column.' %}</option> + </select> + <input class="btn btn-primary" type="submit" value="{% trans 'Add' %}"> + </form> + </td> + <td class="navigation_separator largescreenonly"></td> + </tr> +</table> +{% if total_rows > 0 %} + <form method="post" id="del_form" action="db_central_columns.php"> + {{ get_hidden_inputs(db) }} + <input id="del_col_name" type="hidden" name="col_name" value=""> + <input type="hidden" name="pos" value="{{ pos }}"> + <input type="hidden" name="delete_save" value="delete"> + </form> + <div id="tableslistcontainer"> + <form name="tableslistcontainer"> + <table id="table_columns" class="tablesorter" class="data"> + {% set class = 'column_heading' %} + {% set title = 'Click to sort.' | trans %} + <thead> + <tr> + <th class="{{ class }}"></th> + <th class="hide"></th> + <th class="column_action" colspan="2">{% trans 'Action' %}</th> + <th class="{{ class }}" title="{{ title }}" data-column="name"> + {% trans 'Name' %} + <div class="sorticon"></div> + </th> + <th class="{{ class }}" title="{{ title }}" data-column="type"> + {% trans 'Type' %} + <div class="sorticon"></div> + </th> + <th class="{{ class }}" title="{{ title }}" data-column="length"> + {% trans 'Length/Value' %} + <div class="sorticon"></div> + </th> + <th class="{{ class }}" title="{{ title }}" data-column="default"> + {% trans 'Default' %} + <div class="sorticon"></div> + </th> + <th class="{{ class }}" title="{{ title }}" data-column="collation"> + {% trans 'Collation' %} + <div class="sorticon"></div> + </th> + <th class="{{ class }}" title="{{ title }}" data-column="attribute"> + {% trans 'Attribute' %} + <div class="sorticon"></div> + </th> + <th class="{{ class }}" title="{{ title }}" data-column="isnull"> + {% trans 'Null' %} + <div class="sorticon"></div> + </th> + <th class="{{ class }}" title="{{ title }}" data-column="extra"> + {% trans 'A_I' %} + <div class="sorticon"></div> + </th> + </tr> + </thead> + <tbody> + {% set row_num = 0 %} + {% for row in rows_list %} + {# getHtmlForTableRow #} + <tr data-rownum="{{ row_num }}" id="{{ 'f_' ~ row_num }}"> + {{ get_hidden_inputs(db) }} + <input type="hidden" name="edit_save" value="save"> + <td class="nowrap"> + <input type="checkbox" class="checkall" name="selected_fld[]" + value="{{ row['col_name'] }}" id="{{ 'checkbox_row_' ~ row_num }}"> + </td> + <td id="{{ 'edit_' ~ row_num }}" class="edit center"> + <a href="#"> {{ get_icon('b_edit', 'Edit' | trans) | raw }}</a> + </td> + <td class="del_row" data-rownum = "{{ row_num }}"> + <a hrf="#">{{ get_icon('b_drop', 'Delete' | trans) }}</a> + <input type="submit" data-rownum = "{{ row_num }}" class="btn btn-secondary edit_cancel_form" value="Cancel"> + </td> + <td id="{{ 'save_' ~ row_num }}" class="hide"> + <input type="submit" data-rownum="{{ row_num }}" class="btn btn-primary edit_save_form" value="Save"> + </td> + <td name="col_name" class="nowrap"> + <span>{{ row['col_name'] }}</span> + <input name="orig_col_name" type="hidden" value="{{ row['col_name'] }}"> + {% include 'columns_definitions/column_name.twig' with { + 'column_number': row_num, + 'ci': 0, + 'ci_offset': 0, + 'column_meta': { + 'Field': row['col_name'] + }, + 'cfg_relation': { + 'centralcolumnswork': false + }, + 'max_rows': max_rows + } only %} + </td> + <td name = "col_type" class="nowrap"> + <span>{{ row['col_type'] }}</span> + {% include 'columns_definitions/column_type.twig' with { + 'column_number': row_num, + 'ci': 1, + 'ci_offset': 0, + 'type_upper': types_upper[row_num], + 'column_meta': {} + } only %} + </td> + <td class="nowrap" name="col_length"> + <span>{{ (row['col_length']?(row['col_length']):'') }}</span> + {% include 'columns_definitions/column_length.twig' with { + 'column_number': row_num, + 'ci': 2, + 'ci_offset': 0, + 'length_values_input_size': 8, + 'length_to_display': row['col_length'] + } only %} + </td> + <td class="nowrap" name="col_default"> + {% if row['col_default'] is defined %} + <span>{{ row['col_default'] }}</span> + {% else %} + <span>None</span> + {% endif %} + {% include 'columns_definitions/column_default.twig' with { + 'column_number': row_num, + 'ci': 3, + 'ci_offset': 0, + 'type_upper': types_upper[row_num], + 'column_meta': rows_meta[row_num], + 'char_editing': char_editing, + } only %} + </td> + <td name="collation" class="nowrap"> + <span>{{ row['col_collation'] }}</span> + <select lang="en" dir="ltr" name="field_collation[{{ row_num }}]" id="field_{{ row_num }}_4"> + <option value=""></option> + {% for charset in charsets %} + <optgroup label="{{ charset.name }}" title="{{ charset.description }}"> + {% for collation in charset.collations %} + <option value="{{ collation.name }}" title="{{ collation.description }}" + {{- collation.name == row['col_collation'] ? ' selected' }}> + {{- collation.name -}} + </option> + {% endfor %} + </optgroup> + {% endfor %} + </select> + </td> + <td class="nowrap" name="col_attribute"> + <span>{{ row['col_attribute']?(row['col_attribute']):"" }}</span> + {% include 'columns_definitions/column_attribute.twig' with { + 'column_number': row_num, + 'ci': 5, + 'ci_offset': 0, + 'extracted_columnspec': {}, + 'column_meta': row['col_attribute'], + 'submit_attribute': false, + 'attribute_types': attribute_types, + } only %} + </td> + <td class="nowrap" name="col_isNull"> + <span>{{ row['col_isNull'] ? 'Yes' | trans : 'No' | trans }}</span> + {% include 'columns_definitions/column_null.twig' with { + 'column_number': row_num, + 'ci': 6, + 'ci_offset': 0, + 'column_meta': { + 'Null': row['col_isNull'] + } + } only %} + </td> + <td class="nowrap" name="col_extra"> + <span>{{ row['col_extra'] }}</span> + {% include 'columns_definitions/column_extra.twig' with { + 'column_number': row_num, + 'ci': 7, + 'ci_offset': 0, + 'column_meta': { + 'Extra': row['col_extra'] + } + } only %} + </td> + </tr> + {% set row_num = row_num + 1 %} + {% endfor %} + </tbody> + </table> + {# getTableFooter #} + {% include 'select_all.twig' with { + 'pma_theme_image': pmaThemeImage, + 'text_dir' : text_dir, + 'form_name' : 'tableslistcontainer', + } only %} + {{ get_button_or_image( + 'edit_central_columns', + 'mult_submit change_central_columns', + 'Edit' | trans, + 'b_edit', + 'edit central columns' + ) | raw }} + {{ get_button_or_image( + 'delete_central_columns', + 'mult_submit', + 'Delete' | trans, + 'b_drop', + 'remove_from_central_columns' + ) | raw }} + </form> + </div> +{% endif %} diff --git a/srcs/phpmyadmin/templates/database/create_table.twig b/srcs/phpmyadmin/templates/database/create_table.twig new file mode 100644 index 0000000..e57d93a --- /dev/null +++ b/srcs/phpmyadmin/templates/database/create_table.twig @@ -0,0 +1,23 @@ +<form id="create_table_form_minimal" method="post" action="tbl_create.php" class="lock-page"> + <fieldset> + <legend> + {% if show_icons('ActionLinksMode') -%} + {{ get_image('b_table_add') }} + {%- endif %} + {% trans "Create table" %} + </legend> + {{ get_hidden_inputs(db) }} + <div class="formelement"> + {% trans "Name" %}: + <input type="text" name="table" maxlength="64" size="30" required="required"> + </div> + <div class="formelement"> + {% trans "Number of columns" %}: + <input type="number" min="1" name="num_fields" value="4" required="required"> + </div> + <div class="clearfloat"></div> + </fieldset> + <fieldset class="tblFooters"> + <input class="btn btn-primary" type="submit" value="{% trans "Go" %}"> + </fieldset> +</form> diff --git a/srcs/phpmyadmin/templates/database/data_dictionary/index.twig b/srcs/phpmyadmin/templates/database/data_dictionary/index.twig new file mode 100644 index 0000000..2f5dc5a --- /dev/null +++ b/srcs/phpmyadmin/templates/database/data_dictionary/index.twig @@ -0,0 +1,65 @@ +<h1>{{ database }}</h1> +{% if comment is not empty %} + <p>{% trans 'Database comment:' %} <em>{{ comment }}</em></p> +{% endif %} + +<div> + {% for table in tables %} + <div> + <h2>{{ table.name }}</h2> + {% if table.comment is not empty %} + <p>{% trans 'Table comments:' %} <em>{{ table.comment }}</em></p> + {% endif %} + + <table class="print"> + <tr> + <th>{% trans 'Column' %}</th> + <th>{% trans 'Type' %}</th> + <th>{% trans 'Null' %}</th> + <th>{% trans 'Default' %}</th> + {% if table.has_relation %} + <th>{% trans 'Links to' %}</th> + {% endif %} + <th>{% trans 'Comments' %}</th> + {% if table.has_mime %} + <th>{% trans 'Media (MIME) type' %}</th> + {% endif %} + </tr> + {% for column in table.columns %} + <tr> + <td class="nowrap"> + {{ column.name }} + {% if column.has_primary_key %} + <em>({% trans 'Primary' %})</em> + {% endif %} + </td> + <td lang="en" dir="ltr"{{ 'set' != column.type and 'enum' != column.type ? ' class="nowrap"' }}> + {{ column.print_type }} + </td> + <td>{{ column.is_nullable ? 'Yes'|trans : 'No'|trans }}</td> + <td class="nowrap"> + {% if column.default is null and column.is_nullable %} + <em>NULL</em> + {% else %} + {{ column.default }} + {% endif %} + </td> + {% if table.has_relation %} + <td>{{ column.relation }}</td> + {% endif %} + <td>{{ column.comment }}</td> + {% if table.has_mime %} + <td>{{ column.mime }}</td> + {% endif %} + </tr> + {% endfor %} + </table> + + {{ table.indexes_table|raw }} + </div> + {% endfor %} +</div> + +<p class="print_ignore"> + <input type="button" class="btn btn-secondary button" id="print" value="{% trans 'Print' %}"> +</p> diff --git a/srcs/phpmyadmin/templates/database/designer/database_tables.twig b/srcs/phpmyadmin/templates/database/designer/database_tables.twig new file mode 100644 index 0000000..5453bb5 --- /dev/null +++ b/srcs/phpmyadmin/templates/database/designer/database_tables.twig @@ -0,0 +1,121 @@ +{% for designerTable in tables %} + {% set i = loop.index0 %} + {% set t_n_url = designerTable.getDbTableString()|escape('url') %} + {% set db = designerTable.getDatabaseName() %} + {% set db_url = db|escape('url') %} + {% set t_n = designerTable.getDbTableString() %} + {% set table_name = designerTable.getTableName()|escape('html') %} + <input name="t_x[{{ t_n_url }}]" type="hidden" id="t_x_{{ t_n_url }}_" /> + <input name="t_y[{{ t_n_url }}]" type="hidden" id="t_y_{{ t_n_url }}_" /> + <input name="t_v[{{ t_n_url }}]" type="hidden" id="t_v_{{ t_n_url }}_" /> + <input name="t_h[{{ t_n_url }}]" type="hidden" id="t_h_{{ t_n_url }}_" /> + <table id="{{ t_n_url }}" + db_url="{{ designerTable.getDatabaseName()|escape('url') }}" + table_name_url="{{ designerTable.getTableName()|escape('url') }}" + cellpadding="0" + cellspacing="0" + class="designer_tab" + style="position:absolute; left: + {{- tab_pos[t_n] is defined ? tab_pos[t_n]['X'] : random(range(20, 700)) }}px; top: + {{- tab_pos[t_n] is defined ? tab_pos[t_n]['Y'] : random(range(20, 550)) }}px; display: + {{- tab_pos[t_n] is defined or display_page == -1 ? 'block' : 'none' }}; z-index: 1;"> <!--"--> + <thead> + <tr class="header"> + {% if has_query %} + <td class="select_all"> + <input class="select_all_1" + type="checkbox" + style="margin: 0;" + value="select_all_{{ t_n_url }}" + id="select_all_{{ i }}" + title="{% trans 'Select all' %}" + table_name="{{ table_name }}" + db_name="{{ db }}"> + </td> + {% endif %} + <td class="small_tab" + title="{% trans 'Show/hide columns' %}" + id="id_hide_tbody_{{ t_n_url }}" + table_name="{{ t_n_url }}">{{ tab_pos[t_n] is not defined or tab_pos[t_n]['V'] is not empty ? 'v' : '>' }}</td> + <td class="small_tab_pref small_tab_pref_1" + db="{{ designerTable.getDatabaseName() }}" + db_url="{{ designerTable.getDatabaseName()|escape('url') }}" + table_name="{{ designerTable.getTableName() }}" + table_name_url="{{ designerTable.getTableName()|escape('url') }}"> + <img src="{{ theme.getImgPath('designer/exec_small.png') }}" + title="{% trans 'See table structure' %}"> + </td> + <td id="id_zag_{{ t_n_url }}" + class="tab_zag nowrap tab_zag_noquery" |