aboutsummaryrefslogtreecommitdiff
path: root/common
diff options
context:
space:
mode:
Diffstat (limited to 'common')
-rw-r--r--common/schema/embedded/order/driver.cxx12
1 files changed, 9 insertions, 3 deletions
diff --git a/common/schema/embedded/order/driver.cxx b/common/schema/embedded/order/driver.cxx
index 63d9c35..685693d 100644
--- a/common/schema/embedded/order/driver.cxx
+++ b/common/schema/embedded/order/driver.cxx
@@ -37,9 +37,13 @@ main (int argc, char* argv[])
{
connection_ptr c (db->connection ());
- // Temporarily disable foreign key constraints for SQLite.
+ // Temporarily disable foreign key constraints for MySQL and SQLite.
+ // For MySQL we can actually create the tables in any order. It is
+ // dropping them that's the problem (there is no IF EXISTS).
//
-#if defined(DATABASE_SQLITE)
+#if defined(DATABASE_MYSQL)
+ c->execute ("SET FOREIGN_KEY_CHECKS=0");
+#elif defined(DATABASE_SQLITE)
c->execute ("PRAGMA foreign_keys=OFF");
#endif
@@ -47,7 +51,9 @@ main (int argc, char* argv[])
schema_catalog::create_schema (*db);
t.commit ();
-#if defined(DATABASE_SQLITE)
+#if defined(DATABASE_MYSQL)
+ c->execute ("SET FOREIGN_KEY_CHECKS=1");
+#elif defined(DATABASE_SQLITE)
c->execute ("PRAGMA foreign_keys=ON");
#endif
}