From 3259378d1c88bf089ca93e0758324cbc809e4771 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Alexis=20de=20Talhou=C3=ABt?= Date: Thu, 4 Oct 2018 23:13:21 -0400 Subject: [PATCH] Fix for a foreign key constraint fails MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit https://stackoverflow.com/a/17828127 Change-Id: I38fb90fd1d6583a259a441f4f67f762724aff5ec Issue-ID: CCSDK-357 Signed-off-by: Alexis de Talhouët Former-commit-id: e221bf44834cb78483855aeadd4554f7f93d7da9 --- installation/sdnc/src/main/resources/blueprint-processor.data.dump | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/installation/sdnc/src/main/resources/blueprint-processor.data.dump b/installation/sdnc/src/main/resources/blueprint-processor.data.dump index 9a4bd3f0..5fd53cbd 100644 --- 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 -- 2.16.6