Server IP : 85.214.239.14 / Your IP : 3.142.199.54 Web Server : Apache/2.4.62 (Debian) System : Linux h2886529.stratoserver.net 4.9.0 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : www-data ( 33) PHP Version : 7.4.18 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /proc/2/task/2/cwd/var/www/wordpress/phpMyAdmin/templates/table/relation/ |
Upload File : |
<tr> {# Drop key anchor #} <td> {% 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 %} <input type="hidden" class="drop_foreign_key_msg" value=" {{- js_msg }}"> {% 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 %} </td> <td> <span class="formelement clearfloat"> <input type="text" name="constraint_name[{{ i }}]" value=" {{- one_key['constraint'] is defined ? one_key['constraint'] -}} " placeholder="{% trans 'Constraint name' %}" maxlength="64"> </span> <div class="floatleft"> {# 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' %} <span class="formelement"> {% include 'table/relation/dropdown_generate.twig' with { 'dropdown_question': 'ON DELETE', 'select_name': 'on_delete[' ~ i ~ ']', 'choices': options_array, 'selected_value': on_delete } only %} </span> <span class="formelement"> {% include 'table/relation/dropdown_generate.twig' with { 'dropdown_question': 'ON UPDATE', 'select_name': 'on_update[' ~ i ~ ']', 'choices': options_array, 'selected_value': on_update } only %} </span> </div> </td> <td> {% if one_key['index_list'] is defined %} {% for key, column in one_key['index_list'] %} <span class="formelement clearfloat"> {% include 'table/relation/dropdown_generate.twig' with { 'dropdown_question': '', 'select_name': 'foreign_key_fields_name[' ~ i ~ '][]', 'choices': column_array, 'selected_value': column } only %} </span> {% endfor %} {% else %} <span class="formelement clearfloat"> {% include 'table/relation/dropdown_generate.twig' with { 'dropdown_question': '', 'select_name': 'foreign_key_fields_name[' ~ i ~ '][]', 'choices': column_array, 'selected_value': '' } only %} </span> {% endif %} <a class="formelement clearfloat add_foreign_key_field" data-index=" {{- i }}" href=""> {% trans '+ Add column' %} </a> </td> {% set tables = [] %} {% if foreign_db %} {% set tables = get_tables(foreign_db, tbl_storage_engine) %} {% endif %} <td> <span class="formelement clearfloat"> {% include 'table/relation/relational_dropdown.twig' with { 'name': 'destination_foreign_db[' ~ i ~ ']', 'title': 'Database'|trans, 'values': databases, 'foreign': foreign_db } only %} </span> </td> <td> <span class="formelement clearfloat"> {% include 'table/relation/relational_dropdown.twig' with { 'name': 'destination_foreign_table[' ~ i ~ ']', 'title': 'Table'|trans, 'values': tables, 'foreign': foreign_table } only %} </span> </td> <td> {% if foreign_db and foreign_table %} {% for foreign_column in one_key['ref_index_list'] %} <span class="formelement clearfloat"> {% include 'table/relation/relational_dropdown.twig' with { 'name': 'destination_foreign_column[' ~ i ~ '][]', 'title': 'Column'|trans, 'values': unique_columns, 'foreign': foreign_column } only %} </span> {% endfor %} {% else %} <span class="formelement clearfloat"> {% include 'table/relation/relational_dropdown.twig' with { 'name': 'destination_foreign_column[' ~ i ~ '][]', 'title': 'Column'|trans, 'values': [], 'foreign': '' } only %} </span> {% endif %} </td> </tr>