/**
* remove all foreign key constraints and return
* sql constraints query for full database
*
* @param array $tables_full array of all tables in given db or dbs
* @param instance $export_sql_plugin export plugin instance
* @param boolean $move whether databse name is empty or not
* @param $db database name
*/
function PMA_getSqlConstraintsQueryForFullDb($tables_full, $export_sql_plugin, $move, $db)
{
$sql_constraints_query_full_db = array();
foreach ($tables_full as $each_table => $tmp) {
$sql_constraints = '';
$sql_drop_foreign_keys = '';
$sql_structure = $export_sql_plugin->getTableDef($db, $each_table, "\n", '', false, false);
if ($move && !empty($sql_drop_foreign_keys)) {
PMA_DBI_query($sql_drop_foreign_keys);
}
// keep the constraint we just dropped
if (!empty($sql_constraints)) {
$sql_constraints_query_full_db[] = $sql_constraints;
}
}
return $sql_constraints_query_full_db;
}
