diff options
Diffstat (limited to 'hugo/pmd_relation_new.php')
| -rw-r--r-- | hugo/pmd_relation_new.php | 119 |
1 files changed, 119 insertions, 0 deletions
diff --git a/hugo/pmd_relation_new.php b/hugo/pmd_relation_new.php new file mode 100644 index 0000000..27572f1 --- /dev/null +++ b/hugo/pmd_relation_new.php @@ -0,0 +1,119 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * + * @package PhpMyAdmin-Designer + */ + +/** + * + */ +require_once './libraries/common.inc.php'; + +PMA_Response::getInstance()->disable(); + +require_once 'libraries/pmd_common.php'; +$die_save_pos = 0; +require_once 'pmd_save_pos.php'; +extract($_POST, EXTR_SKIP); + +$tables = PMA_DBI_get_tables_full($db, $T1); +$type_T1 = strtoupper($tables[$T1]['ENGINE']); +$tables = PMA_DBI_get_tables_full($db, $T2); +$type_T2 = strtoupper($tables[$T2]['ENGINE']); + +// native foreign key +if (PMA_Util::isForeignKeySupported($type_T1) + && PMA_Util::isForeignKeySupported($type_T2) + && $type_T1 == $type_T2 +) { + // relation exists? + $existrel_foreign = PMA_getForeigners($db, $T2, '', 'foreign'); + if (isset($existrel_foreign[$F2]) + && isset($existrel_foreign[$F2]['constraint']) + ) { + PMD_return_new(0, __('Error: relation already exists.')); + } + // note: in InnoDB, the index does not requires to be on a PRIMARY + // or UNIQUE key + // improve: check all other requirements for InnoDB relations + $result = PMA_DBI_query( + 'SHOW INDEX FROM ' . PMA_Util::backquote($db) + . '.' . PMA_Util::backquote($T1) . ';' + ); + $index_array1 = array(); // will be use to emphasis prim. keys in the table view + while ($row = PMA_DBI_fetch_assoc($result)) { + $index_array1[$row['Column_name']] = 1; + } + PMA_DBI_free_result($result); + + $result = PMA_DBI_query( + 'SHOW INDEX FROM ' . PMA_Util::backquote($db) + . '.' . PMA_Util::backquote($T2) . ';' + ); + $index_array2 = array(); // will be used to emphasis prim. keys in the table view + while ($row = PMA_DBI_fetch_assoc($result)) { + $index_array2[$row['Column_name']] = 1; + } + PMA_DBI_free_result($result); + + if (! empty($index_array1[$F1]) && ! empty($index_array2[$F2])) { + $upd_query = 'ALTER TABLE ' . PMA_Util::backquote($db) + . '.' . PMA_Util::backquote($T2) + . ' ADD FOREIGN KEY (' + . PMA_Util::backquote($F2) . ')' + . ' REFERENCES ' + . PMA_Util::backquote($db) . '.' + . PMA_Util::backquote($T1) . '(' + . PMA_Util::backquote($F1) . ')'; + + if ($on_delete != 'nix') { + $upd_query .= ' ON DELETE ' . $on_delete; + } + if ($on_update != 'nix') { + $upd_query .= ' ON UPDATE ' . $on_update; + } + $upd_query .= ';'; + PMA_DBI_try_query($upd_query) or PMD_return_new(0, __('Error: Relation not added.')); + PMD_return_new(1, __('FOREIGN KEY relation added')); + } +} else { // internal (pmadb) relation + if ($GLOBALS['cfgRelation']['relwork'] == false) { + PMD_return_new(0, __('General relation features') . ':' . __('Disabled')); + } else { + // no need to recheck if the keys are primary or unique at this point, + // this was checked on the interface part + + $q = 'INSERT INTO ' . PMA_Util::backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_Util::backquote($cfgRelation['relation']) + . '(master_db, master_table, master_field, foreign_db, foreign_table, foreign_field)' + . ' values(' + . '\'' . PMA_Util::sqlAddSlashes($db) . '\', ' + . '\'' . PMA_Util::sqlAddSlashes($T2) . '\', ' + . '\'' . PMA_Util::sqlAddSlashes($F2) . '\', ' + . '\'' . PMA_Util::sqlAddSlashes($db) . '\', ' + . '\'' . PMA_Util::sqlAddSlashes($T1) . '\',' + . '\'' . PMA_Util::sqlAddSlashes($F1) . '\')'; + + if (PMA_queryAsControlUser($q, false, PMA_DBI_QUERY_STORE)) { + PMD_return_new(1, __('Internal relation added')); + } else { + PMD_return_new(0, __('Error: Relation not added.')); + } + } +} + +function PMD_return_new($b,$ret) +{ + global $db,$T1,$F1,$T2,$F2; + header("Content-Type: text/xml; charset=utf-8"); + header("Cache-Control: no-cache"); + die('<root act="relation_new" return="'.$ret.'" b="'.$b. + '" DB1="'.urlencode($db). + '" T1="'.urlencode($T1). + '" F1="'.urlencode($F1). + '" DB2="'.urlencode($db). + '" T2="'.urlencode($T2). + '" F2="'.urlencode($F2). + '"></root>'); +} +?> |