pmd_relation_new.php

   1 <?php
   2 /* $Id$ */
   3 // vim: expandtab sw=4 ts=4 sts=4:
   4
   5 include_once 'pmd_common.php';
   6 $die_save_pos = 0;
   7 include_once 'pmd_save_pos.php';
   8 require_once './libraries/relation.lib.php';
   9 extract($_POST);
  10
  11 $tables = PMA_DBI_get_tables_full($db, $T1);
  12 $type_T1 = strtoupper($tables[$T1]['ENGINE']);
  13 $tables = PMA_DBI_get_tables_full($db, $T2);
  14 $type_T2 = strtoupper($tables[$T2]['ENGINE']);
  15
  16 //  I n n o D B
  17 if ($type_T1 == 'INNODB' and $type_T2 == 'INNODB') {
  18     // relation exists?
  19     $existrel_innodb = PMA_getForeigners($db, $T2, '', 'innodb');
  20     if (isset($existrel_innodb[$F2])
  21      && isset($existrel_innodb[$F2]['constraint'])) {
  22              PMD_return(0,'ERROR : Relation already exists!');
  23     }
  24 // note: in InnoDB, the index does not requires to be on a PRIMARY
  25 // or UNIQUE key
  26 // improve: check all other requirements for InnoDB relations
  27     $result      = PMA_DBI_query('SHOW INDEX FROM ' . PMA_backquote($T1) . ';');
  28     $index_array1   = array(); // will be use to emphasis prim. keys in the table view
  29     while ($row = PMA_DBI_fetch_assoc($result))
  30         $index_array1[$row['Column_name']] = 1;
  31     PMA_DBI_free_result($result);
  32
  33     $result     = PMA_DBI_query('SHOW INDEX FROM ' . PMA_backquote($T2) . ';');
  34     $index_array2  = array(); // will be used to emphasis prim. keys in the table view
  35     while ($row = PMA_DBI_fetch_assoc($result))
  36         $index_array2[$row['Column_name']] = 1;
  37     PMA_DBI_free_result($result);
  38
  39     if (! empty($index_array1[$F1]) && ! empty($index_array2[$F2])) {
  40         $upd_query  = 'ALTER TABLE ' . PMA_backquote($T2)
  41                  . ' ADD FOREIGN KEY ('
  42                  . PMA_backquote($F2) . ')'
  43                  . ' REFERENCES '
  44                  . PMA_backquote($db) . '.'
  45                  . PMA_backquote($T1) . '('
  46                  . PMA_backquote($F1) . ')';
  47
  48         if ($on_delete != 'nix') {
  49             $upd_query   .= ' ON DELETE ' . $on_delete;
  50         }
  51         if ($on_update != 'nix') {
  52             $upd_query   .= ' ON UPDATE ' . $on_update;
  53         }
  54         PMA_DBI_try_query($upd_query) or PMD_return(0,'ERROR : Relation not added!!!');
  55     PMD_return(1,$strInnoDBRelationAdded);
  56     }
  57
  58 //  n o n - I n n o D B
  59 } else {
  60     if ($GLOBALS['cfgRelation']['relwork'] == false) {
  61         PMD_return(0, $strGeneralRelationFeat . ' : ' . $strDisabled);
  62     } else {
  63         // no need to recheck if the keys are primary or unique at this point,
  64         // this was checked on the interface part
  65
  66         $q = "INSERT INTO ".PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['relation'])."
  67         (master_db, master_table, master_field, foreign_db, foreign_table, foreign_field)
  68         VALUES ('".$db."','".$T2."','$F2','".
  69         $db."','".$T1."','$F1')";
  70         PMA_query_as_cu( $q , true, PMA_DBI_QUERY_STORE);// or PMD_return(0,'ERROR : Relation not added!');
  71
  72         PMD_return(1, $strInternalRelationAdded);
  73    }
  74 }
  75
  76 function PMD_return($b,$ret)
  77 {
  78     global $db,$T1,$F1,$T2,$F2;
  79     die('<root act="relation_new" return="'.$ret.'" b="'.$b.'" DB1="'.$db.'" T1="'.$T1.'" F1="'.$F1.'" DB2="'.$db.'" T2="'.$T2.'" F2="'.$F2.'"></root>');
  80 }
  81 ?>