From c39ba800ac0409422431f4b09e9c41771b88df11 Mon Sep 17 00:00:00 2001 From: Aaron Hay Date: Wed, 5 Sep 2018 10:22:26 -0400 Subject: Fix syntax error in SQL statements Change-Id: I4f51de978b66109405f07e9da72b7156e92a2518 Issue-ID: APPC-1191 Signed-off-by: Aaron Hay --- installation/appc/src/main/resources/appcctl.dump | 2 +- installation/appc/src/main/resources/sdnctl.dump | 5 +++++ installation/appc/src/main/resources/sqlData.dump | 2 +- 3 files changed, 7 insertions(+), 2 deletions(-) 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; -- cgit 1.2.3-korg