/** * 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; }