diff options
| author |   Skip Wonnell <skip@att.com> | 2017-11-01 14:21:31 -0500 |
|---|---|---|
| committer | Skip Wonnell <skip@att.com> | 2017-11-01 14:40:17 -0500 |
| commit | 380e19d353dada1515d82ad349e053da1958f4cb (patch) | |
| tree | fd0e6794683cf1213caba9866170fde2608eed1d /installation | |
| parent | c36a12027b1d95a402787a20c55a87aea5cebec5 (diff) | |
Update initialization of VNF_DG_MAPPING table
Update the data to be loaded into the table
Move source location of the data to the sqlData.dump file
Remove old source location (VNF_DG_MAPPING.sql)
Update install.sh to remove call to VNF_DG_MAPPING.sql
Issue-ID: [APPC-295]
Change-Id: I525fb0f717237388d04989fe49eca3e6498b09ef
Signed-off-by: Skip Wonnell <skip@att.com>
Diffstat (limited to 'installation')
| -rw-r--r-- | installation/appc/src/main/resources/sqlData.dump | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/installation/appc/src/main/resources/sqlData.dump b/installation/appc/src/main/resources/sqlData.dump index 88355d9..05545ac 100644 --- a/installation/appc/src/main/resources/sqlData.dump +++ b/installation/appc/src/main/resources/sqlData.dump @@ -1,10 +1,17 @@ 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'); +UNLOCK TABLES; + + LOCK TABLES `ACTION_LEVEL_REFERENCE` WRITE; INSERT INTO `ACTION_LEVEL_REFERENCE` VALUES (1,'vnf-id','vnf'),(2,'vserver-id','vm'),(3,'vnfc-name','vnfc'),(4,'vf-module-id','vf-module'); UNLOCK TABLES; LOCK TABLES `MULTISTEP_FLOW_REFERENCE` WRITE; -INSERT INTO `MULTISTEP_FLOW_REFERENCE` VALUES (1,'Restart','vnf','vFW',NULL,'multistep_flow_reference.category',NULL,NULL,'ac204h','2017-10-30 19:23:07'); +INSERT INTO `MULTISTEP_FLOW_REFERENCE` VALUES (1,'Restart','vnf','vFW',NULL,'multistep_flow_reference.category',NULL,NULL,'userid','2017-10-30 19:23:07'); UNLOCK TABLES; LOCK TABLES `PROCESS_FLOW_REFERENCE` WRITE; |