From: Aaron Hay <ah415j@att.com>
Date: Wed, 5 Sep 2018 14:22:26 +0000 (-0400)
Subject: Fix syntax error in SQL statements
X-Git-Tag: 1.4.4~41
X-Git-Url: https://gerrit.onap.org/r/gitweb?p=appc%2Fdeployment.git;a=commitdiff_plain;h=c39ba800ac0409422431f4b09e9c41771b88df11

Fix syntax error in SQL statements

Change-Id: I4f51de978b66109405f07e9da72b7156e92a2518
Issue-ID: APPC-1191
Signed-off-by: Aaron Hay <ah415j@att.com>
---

diff --git a/installation/appc/src/main/resources/appcctl.dump b/installation/appc/src/main/resources/appcctl.dump
index 69bcc5a..4973a46 100644
--- a/installation/appc/src/main/resources/appcctl.dump
+++ b/installation/appc/src/main/resources/appcctl.dump
@@ -46,4 +46,4 @@ CREATE TABLE `transactions` (
     varchar(256) DEFAULT NULL,
     `DESCRIPTION`
     text
-) ENGINE = InnoDB DEFAULT CHARSET = latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
diff --git a/installation/appc/src/main/resources/sdnctl.dump b/installation/appc/src/main/resources/sdnctl.dump
index b3c2333..094095b 100644
--- a/installation/appc/src/main/resources/sdnctl.dump
+++ b/installation/appc/src/main/resources/sdnctl.dump
@@ -24,6 +24,8 @@ CREATE DATABASE /*!32312 IF NOT EXISTS*/ `sdnctl` /*!40100 DEFAULT CHARACTER SET
 
 USE `sdnctl`;
 
+SET FOREIGN_KEY_CHECKS = 0;
+
 --
 -- Table structure for table `ACTION_LEVEL_REFERENCE`
 --
@@ -1340,3 +1342,6 @@ CREATE TABLE `VNF_STATE_MANAGEMENT` (
   PRIMARY KEY (`VNF_ID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
+
+SET FOREIGN_KEY_CHECKS = 1;
+
diff --git a/installation/appc/src/main/resources/sqlData.dump b/installation/appc/src/main/resources/sqlData.dump
index 28baa8b..765704e 100644
--- a/installation/appc/src/main/resources/sqlData.dump
+++ b/installation/appc/src/main/resources/sqlData.dump
@@ -23,7 +23,7 @@ USE sdnctl;
 
 
 LOCK TABLES `VNF_DG_MAPPING` WRITE;
-INSERT INTO `VNF_DG_MAPPING` VALUES ('Restart','2.01','','','Generic_Restart','3.0.0','APPC'),('Restart','2.00','','','Generic_Restart','3.0.0','APPC'),('Configure',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('ConfigModify',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('Rebuild',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('Restart',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('HealthCheck',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('StartApplication',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('StopApplication',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('Migrate',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('Snapshot',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('ConfigRestore',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('ConfigBackup',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('Evacuate',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('Stop',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('Start',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('ConfigScaleOut',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC');
+INSERT INTO `VNF_DG_MAPPING` VALUES ('','Restart','2.01','','','Generic_Restart','3.0.0','APPC'),('','Restart','2.00','','','Generic_Restart','3.0.0','APPC'),('','Configure',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('','ConfigModify',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('','Rebuild',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('','Restart',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('','HealthCheck',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('','StartApplication',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('','StopApplication',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('','Migrate',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('','Snapshot',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('','ConfigRestore',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('','ConfigBackup',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('','Evacuate',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('','Stop',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('','Start',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('','ConfigScaleOut',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC');
 UNLOCK TABLES;