Changeset 12530

Timestamp:

Mar 21, 2007, 2:58:44 PM (19 years ago)

Author:

jhoblitt

Message:

disable foreign key constraints while dropping tables

File:

• trunk/ippTools/src/pxtables.c (modified) (2 diffs)

trunk/ippTools/src/pxtables.c

@@ -124 +124 @@
     }
 
+    // disable foreign key constrants
+    if (!p_psDBRunQuery(config->dbh, "SET FOREIGN_KEY_CHECKS=0")) {
+        psError(PS_ERR_UNKNOWN, false, "database error");
+        status = false; 
+    }
+
     DROP_TABLE(expTagCounterDropTable);
     DROP_TABLE(summitExpDropTable);
@@ -166 +172 @@
     DROP_TABLE(stackSumSkyfileDropTable);
 
+    // re-enable foreign key constrants
+    if (!p_psDBRunQuery(config->dbh, "SET FOREIGN_KEY_CHECKS=1")) {
+        psError(PS_ERR_UNKNOWN, false, "database error");
+        status = false; 
+    }
+
     return status;
 }