Initial commit of intern.ccwn.org contentsHEADmaster

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>');
+}
+?>