$val) { $target[$key] = $row["target"][$key]; } $row["target"] = $target; } if (JUSH == "sqlite") { $result = recreate_table($TABLE, $TABLE, array(), array(), array(" $name" => ($row["drop"] ? "" : " " . format_foreign_key($row)))); } else { $alter = "ALTER TABLE " . table($TABLE); $result = ($name == "" || queries("$alter DROP " . (JUSH == "sql" ? "FOREIGN KEY " : "CONSTRAINT ") . idf_escape($name))); if (!$row["drop"]) { $result = queries("$alter ADD" . format_foreign_key($row)); } } queries_redirect( ME . "table=" . urlencode($TABLE), ($row["drop"] ? lang('Foreign key has been dropped.') : ($name != "" ? lang('Foreign key has been altered.') : lang('Foreign key has been created.'))), $result ); if (!$row["drop"]) { $error = lang('Source and target columns must have the same data type, there must be an index on the target columns and referenced data must exist.'); //! no partitioning } } page_header(lang('Foreign key'), $error, array("table" => $TABLE), h($TABLE)); if ($_POST) { ksort($row["source"]); if ($_POST["add"]) { $row["source"][] = ""; } elseif ($_POST["change"] || $_POST["change-js"]) { $row["target"] = array(); } } elseif ($name != "") { $foreign_keys = foreign_keys($TABLE); $row = $foreign_keys[$name]; $row["source"][] = ""; } else { $row["table"] = $TABLE; $row["source"] = array(""); } ?>
select_db($row["db"]); } if ($row["ns"] != "") { $orig_schema = get_schema(); set_schema($row["ns"]); } $referencable = array_keys(array_filter(table_status('', true), 'Adminer\fk_support')); $target = array_keys(fields(in_array($row["table"], $referencable) ? $row["table"] : reset($referencable))); $onchange = "this.form['change-js'].value = '1'; this.form.submit();"; echo "

\n"; if (support("scheme")) { $schemas = array_filter(adminer()->schemas(), function ($schema) { return !preg_match('~^information_schema$~i', $schema); }); echo ""; if ($row["ns"] != "") { set_schema($orig_schema); } } elseif (JUSH != "sqlite") { $dbs = array(); foreach (adminer()->databases() as $db) { if (!information_schema($db)) { $dbs[] = $db; } } echo ""; } echo input_hidden("change-js"); ?>

$val) { echo ""; echo "
" . html_select("source[" . (+$key) . "]", array(-1 => "") + $source, $val, ($j == count($row["source"]) - 1 ? "foreignAddRow.call(this);" : ""), "label-source"); echo "" . html_select("target[" . (+$key) . "]", $target, idx($row["target"], $key), "", "label-target"); $j++; } ?>

"innodb-foreign-key-constraints.html", 'mariadb' => "foreign-keys/", 'pgsql' => "sql-createtable.html#SQL-CREATETABLE-REFERENCES", 'mssql' => "t-sql/statements/create-table-transact-sql", 'oracle' => "SQLRF01111", )); ?>