diff --git a/htdocs/sql/pmd_relation_upd.php b/htdocs/sql/pmd_relation_upd.php new file mode 100755 --- /dev/null +++ b/htdocs/sql/pmd_relation_upd.php @@ -0,0 +1,56 @@ += 40013 && isset($existrel_innodb[$F2]['constraint'])) { + $upd_query = 'ALTER TABLE ' . PMA_backquote($T2) + . ' DROP FOREIGN KEY ' + . PMA_backquote($existrel_innodb[$F2]['constraint']); + $upd_rs = PMA_DBI_query($upd_query); + } +} else { + // internal relations + PMA_query_as_cu('DELETE FROM '.$cfg['Server']['relation'].' WHERE ' + . 'master_db = \'' . PMA_sqlAddslashes($DB2) . '\'' + . 'AND master_table = \'' . PMA_sqlAddslashes($T2) . '\'' + . 'AND master_field = \'' . PMA_sqlAddslashes($F2) . '\'' + . 'AND foreign_db = \'' . PMA_sqlAddslashes($DB1) . '\'' + . 'AND foreign_table = \'' . PMA_sqlAddslashes($T1) . '\'' + . 'AND foreign_field = \'' . PMA_sqlAddslashes($F1) . '\'' + , FALSE, PMA_DBI_QUERY_STORE); +} +PMD_return(1, 'strRelationDeleted'); + +function PMD_return($b,$ret) +{ + global $K; + header("Content-Type: text/xml; charset=utf-8"); + header("Cache-Control: no-cache"); + die(''); +} +?>