home *** CD-ROM | disk | FTP | other *** search
- <?php
- /* vim: set expandtab sw=4 ts=4 sts=4: */
- /**
- *
- * @version $Id: pmd_relation_new.php 11132 2008-02-21 17:42:07Z lem9 $
- * @package phpMyAdmin-Designer
- */
-
- /**
- *
- */
- include_once 'pmd_common.php';
- $die_save_pos = 0;
- include_once 'pmd_save_pos.php';
- require_once './libraries/relation.lib.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);
- //print_r($tables);
- //die();
- $type_T2 = strtoupper($tables[$T2]['ENGINE']);
-
- // I n n o D B
- if ($type_T1 == 'INNODB' and $type_T2 == 'INNODB') {
- // relation exists?
- $existrel_innodb = PMA_getForeigners($db, $T2, '', 'innodb');
- if (isset($existrel_innodb[$F2])
- && isset($existrel_innodb[$F2]['constraint'])) {
- PMD_return(0,'strErrorRelationExists');
- }
- // 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_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_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_backquote($T2)
- . ' ADD FOREIGN KEY ('
- . PMA_backquote($F2) . ')'
- . ' REFERENCES '
- . PMA_backquote($db) . '.'
- . PMA_backquote($T1) . '('
- . PMA_backquote($F1) . ')';
-
- if ($on_delete != 'nix') {
- $upd_query .= ' ON DELETE ' . $on_delete;
- }
- if ($on_update != 'nix') {
- $upd_query .= ' ON UPDATE ' . $on_update;
- }
- PMA_DBI_try_query($upd_query) or PMD_return(0,'strErrorRelationAdded');
- PMD_return(1,'strInnoDBRelationAdded');
- }
-
- // n o n - I n n o D B
- } else {
- if ($GLOBALS['cfgRelation']['relwork'] == false) {
- PMD_return(0, 'strGeneralRelationFeat:strDisabled');
- } 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_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['relation'])
- . '(master_db, master_table, master_field, foreign_db, foreign_table, foreign_field)'
- . ' values('
- . '\'' . PMA_sqlAddslashes($db) . '\', '
- . '\'' . PMA_sqlAddslashes($T2) . '\', '
- . '\'' . PMA_sqlAddslashes($F2) . '\', '
- . '\'' . PMA_sqlAddslashes($db) . '\', '
- . '\'' . PMA_sqlAddslashes($T1) . '\','
- . '\'' . PMA_sqlAddslashes($F1) . '\')';
-
- if (PMA_query_as_cu($q , false, PMA_DBI_QUERY_STORE)) {
- PMD_return(1, 'strInternalRelationAdded');
- } else {
- PMD_return(0, 'strErrorRelationAdded');
- }
- }
- }
-
- function PMD_return($b,$ret)
- {
- global $db,$T1,$F1,$T2,$F2;
- header("Content-Type: text/xml; charset=utf-8");//utf-8 .$_GLOBALS['charset']
- 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>');
- }
- ?>
-