Fix for a foreign key constraint fails

https://stackoverflow.com/a/17828127

Change-Id: I38fb90fd1d6583a259a441f4f67f762724aff5ec
Issue-ID: CCSDK-357
Signed-off-by: Alexis de Talhouët <adetalhouet89@gmail.com>
Former-commit-id: e221bf44834cb78483855aeadd4554f7f93d7da9

diff --git a/installation/sdnc/src/main/resources/blueprint-processor.data.dump b/installation/sdnc/src/main/resources/blueprint-processor.data.dump
index 9a4bd3f..5fd53cb 100644 (file)
--- a/installation/sdnc/src/main/resources/blueprint-processor.data.dump
+++ b/installation/sdnc/src/main/resources/blueprint-processor.data.dump
@@ -2,11 +2,14 @@
 -- Dropping tables ( One time )
 -- -----------------------------------------------------
 
+SET FOREIGN_KEY_CHECKS=0;
+
 DROP TABLE sdnctl.CONFIG_RESOURCE_ASSIGNMENT_DATA;
 DROP TABLE sdnctl.CONFIG_RESOURCE;
 DROP TABLE sdnctl.CONFIG_RESOURCE_RELATION;
-DROP TABLE sdnctl.CONFIG_TRANSACTION_LOG
+DROP TABLE sdnctl.CONFIG_TRANSACTION_LOG;
 
+SET FOREIGN_KEY_CHECKS=1;
 
 -- -----------------------------------------------------
 -- table sdnctl.CONFIG_TRANSACTION_LOG