From c9c33c13768f0c4c39bb9831353cbe97b519a949 Mon Sep 17 00:00:00 2001 From: Alexis de Talhouët Date: Mon, 12 Nov 2018 16:35:30 -0500 Subject: Drop CDS tables only if they exist MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit During the initialization of SDNC, SDNC tries to install all the SQL dump provided. While processing the one for CDS, it was failing to execute the first statement as the table is not existent; hence was exiting that dump and processing with the next one. In order to make sure the process creates CDS tables, make the DROP statement work even if table doesn't exist. Change-Id: Ifa99b8e1a13ac3828828e8b2a9f9674556f84ced Issue-ID: CCSDK-682 Signed-off-by: Alexis de Talhouët Former-commit-id: 2f69e233c4143fb6bf5939bf4db26ea76805c933 --- .../sdnc/src/main/resources/blueprint-processor.data.dump | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/installation/sdnc/src/main/resources/blueprint-processor.data.dump b/installation/sdnc/src/main/resources/blueprint-processor.data.dump index 5fd53cbd..9a19863c 100644 --- a/installation/sdnc/src/main/resources/blueprint-processor.data.dump +++ b/installation/sdnc/src/main/resources/blueprint-processor.data.dump @@ -4,10 +4,10 @@ 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 IF EXISTS sdnctl.CONFIG_RESOURCE_ASSIGNMENT_DATA; +DROP TABLE IF EXISTS sdnctl.CONFIG_RESOURCE; +DROP TABLE IF EXISTS sdnctl.CONFIG_RESOURCE_RELATION; +DROP TABLE IF EXISTS sdnctl.CONFIG_TRANSACTION_LOG; SET FOREIGN_KEY_CHECKS=1; -- cgit 1.2.3-korg