DB Changes for ScaleOut feature

Updated DB insert statements for
adding reference data for the Scaleout
feature.

Issue-ID: APPC-481
Change-Id: I0beaa8f5f675b45395bee7e36d3617ce62624895
Signed-off-by: Ramya Balaji <rb111y@att.com>

1 files changed, 2 insertions, 2 deletions

diff --git a/installation/appc/src/main/resources/sqlData.dump b/installation/appc/src/main/resources/sqlData.dump
index 05545ac..afb1fc3 100644
--- a/installation/appc/src/main/resources/sqlData.dump
+++ b/installation/appc/src/main/resources/sqlData.dump
@@ -2,7 +2,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');
+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;
 
 
@@ -15,5 +15,5 @@ INSERT INTO `MULTISTEP_FLOW_REFERENCE` VALUES (1,'Restart','vnf','vFW',NULL,'mul
 UNLOCK TABLES;
 
 LOCK TABLES `PROCESS_FLOW_REFERENCE` WRITE;
-INSERT INTO `PROCESS_FLOW_REFERENCE` VALUES (12,'Configure','vnf','CLI','graph','APPC','Generic_Configure','2017-08-25 19:40:04',NULL),(13,'Configure','vnf','NETCONF-XML','graph','APPC','Generic_Configure','2017-08-25 19:40:04',NULL),(14,'ConfigRestore','vnf','CLI','graph','APPC','Generic_Configure','2017-08-25 19:40:04',NULL),(15,'ConfigureRestore','vnf','NETCONF-XML','graph','APPC','Generic_Configure','2017-08-25 19:40:04',NULL),(16,'ConfigModify','vnf','CLI','graph','APPC','Generic_Configure','2017-08-25 19:40:05',NULL),(17,'ConfigModify','vnf','NETCONF-XML','graph','APPC','Generic_Configure','2017-08-25 19:40:05',NULL),(19,'rebuild','vm','OS','graph','APPC','RebuildVM','2017-08-25 19:40:05',NULL),(21,'migrate','vm','OS','graph','APPC','MigrateVM','2017-08-25 19:40:05',NULL),(22,'restart','vm','OS','graph','APPC','RestartVMVNFCommonFlow','2017-08-25 19:40:05',NULL),(23,'Configure','vnf','Chef','graph','APPC','Generic_Configure','2017-08-25 19:40:05',NULL),(24,'Configure','vnf','Ansible','graph','APPC','Generic_Configure','2017-08-25 19:40:05',NULL),(25,'HealthCheck','vnf','REST','graph','APPC','healthcheck','2017-08-25 19:40:06',NULL),(26,'HealthCheck','vnf','Chef','graph','APPC','Generic_ChefDG','2017-08-25 19:40:06',NULL),(27,'HealthCheck','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-08-25 19:40:06',NULL),(28,'StopApplication','vnf','Chef','graph','APPC','Generic_ChefDG','2017-08-25 19:40:06',NULL),(29,'StopApplication','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-08-25 19:40:06',NULL),(30,'StartApplication','vnf','Chef','graph','APPC','Generic_ChefDG','2017-08-25 19:40:06',NULL),(31,'StartApplication','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-08-25 19:40:06',NULL),(32,'ConfigRestore','vnf','Chef','graph','APPC','Generic_ChefDG','2017-08-25 19:40:06',NULL),(33,'ConfigRestore','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-08-25 19:40:06',NULL),(34,'ConfigBackup','vnf','Chef','graph','APPC','Generic_ChefDG','2017-08-25 19:40:07',NULL),(35,'ConfigBackup','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-08-25 19:40:07',NULL),(38,'ConfigRestore','vnf','CLI','graph','APPC','Generic_Configure','2017-09-12 13:33:14',NULL),(39,'ConfigRestore','vnf','CLI','graph','APPC','Generic_Configure','2017-09-12 13:35:11',NULL),(40,'Configure','vnf','CLI','graph','APPC','Generic_Configure','2017-09-12 16:49:54',NULL),(41,'Configure','vnf','NETCONF-XML','graph','APPC','Generic_Configure','2017-09-12 16:49:54',NULL),(42,'ConfigureRestore','vnf','CLI','graph','APPC','Generic_Configure','2017-09-12 16:49:54',NULL),(43,'ConfigureRestore','vnf','NETCONF-XML','graph','APPC','Generic_Configure','2017-09-12 16:49:54',NULL),(44,'ConfigModify','vnf','CLI','graph','APPC','Generic_Configure','2017-09-12 16:49:54',NULL),(45,'ConfigModify','vnf','NETCONF-XML','graph','APPC','Generic_Configure','2017-09-12 16:49:54',NULL),(46,'evacuate','vm','OS','graph','APPC','EvacuateVM','2017-09-12 16:49:54',NULL),(47,'rebuild','vm','OS','graph','APPC','RebuildVM','2017-09-12 16:49:54',NULL),(48,'snapshot','vm','OS','graph','APPC','CreateSnapShotVM','2017-09-12 16:49:54',NULL),(49,'migrate','vm','OS','graph','APPC','MigrateVM','2017-09-12 16:49:54',NULL),(50,'restart','vm','OS','graph','APPC','RestartVMVNFCommonFlow','2017-09-12 16:49:54',NULL),(51,'Configure','vnf','Chef','graph','APPC','Generic_Configure','2017-09-12 16:49:54',NULL),(52,'Configure','vnf','Ansible','graph','APPC','Generic_Configure','2017-09-12 16:49:54',NULL),(53,'HealthCheck','vnf','REST','graph','APPC','healthcheck','2017-09-12 16:49:54',NULL),(54,'HealthCheck','vnf','Chef','graph','APPC','Generic_ChefDG','2017-09-12 16:49:54',NULL),(55,'HealthCheck','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-09-12 16:49:54',NULL),(56,'StopApplication','vnf','Chef','graph','APPC','Generic_ChefDG','2017-09-12 16:49:54',NULL),(57,'StopApplication','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-09-12 16:49:54',NULL),(58,'StartApplication','vnf','Chef','graph','APPC','Generic_ChefDG','2017-09-12 16:49:54',NULL),(59,'StartApplication','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-09-12 16:49:54',NULL),(60,'ConfigRestore','vnf','Chef','graph','APPC','Generic_ChefDG','2017-09-12 16:49:54',NULL),(61,'ConfigRestore','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-09-12 16:49:54',NULL),(62,'ConfigBackup','vnf','Chef','graph','APPC','Generic_ChefDG','2017-09-12 16:49:54',NULL),(63,'ConfigBackup','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-09-12 16:49:54',NULL),(64,'Start','vm','OS','graph','APPC','VM_Start','2017-09-12 16:49:54',NULL),(65,'Stop','vm','OS','graph','APPC','VM_Stop','2017-09-12 16:49:54',NULL),(67,'ConfigModify','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-10-17 15:35:29','Y'),(68,'ConfigModify','vnf','Chef','graph','APPC','Generic_ChefDG','2017-10-17 15:35:33','Y'),(70,'Restart','vm','OS','graph','APPC','RestartVMVNFCommonFlow','2017-10-17 15:50:00',NULL),(71,'Rebuild','vm','OS','graph','APPC','RebuildVM','2017-10-17 15:51:03',NULL),(73,'Restart','vnf','OS','graph','APPC','RestartVMVNFCommonFlow','2017-10-24 16:48:06',NULL);
+INSERT INTO `PROCESS_FLOW_REFERENCE` VALUES (12,'Configure','vnf','CLI','graph','APPC','Generic_Configure','2017-08-25 19:40:04',NULL),(13,'Configure','vnf','NETCONF-XML','graph','APPC','Generic_Configure','2017-08-25 19:40:04',NULL),(14,'ConfigRestore','vnf','CLI','graph','APPC','Generic_Configure','2017-08-25 19:40:04',NULL),(15,'ConfigureRestore','vnf','NETCONF-XML','graph','APPC','Generic_Configure','2017-08-25 19:40:04',NULL),(16,'ConfigModify','vnf','CLI','graph','APPC','Generic_Configure','2017-08-25 19:40:05',NULL),(17,'ConfigModify','vnf','NETCONF-XML','graph','APPC','Generic_Configure','2017-08-25 19:40:05',NULL),(19,'rebuild','vm','OS','graph','APPC','RebuildVM','2017-08-25 19:40:05',NULL),(21,'migrate','vm','OS','graph','APPC','MigrateVM','2017-08-25 19:40:05',NULL),(22,'restart','vm','OS','graph','APPC','RestartVMVNFCommonFlow','2017-08-25 19:40:05',NULL),(23,'Configure','vnf','Chef','graph','APPC','Generic_Configure','2017-08-25 19:40:05',NULL),(24,'Configure','vnf','Ansible','graph','APPC','Generic_Configure','2017-08-25 19:40:05',NULL),(25,'HealthCheck','vnf','REST','graph','APPC','healthcheck','2017-08-25 19:40:06',NULL),(26,'HealthCheck','vnf','Chef','graph','APPC','Generic_ChefDG','2017-08-25 19:40:06',NULL),(27,'HealthCheck','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-08-25 19:40:06',NULL),(28,'StopApplication','vnf','Chef','graph','APPC','Generic_ChefDG','2017-08-25 19:40:06',NULL),(29,'StopApplication','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-08-25 19:40:06',NULL),(30,'StartApplication','vnf','Chef','graph','APPC','Generic_ChefDG','2017-08-25 19:40:06',NULL),(31,'StartApplication','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-08-25 19:40:06',NULL),(32,'ConfigRestore','vnf','Chef','graph','APPC','Generic_ChefDG','2017-08-25 19:40:06',NULL),(33,'ConfigRestore','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-08-25 19:40:06',NULL),(34,'ConfigBackup','vnf','Chef','graph','APPC','Generic_ChefDG','2017-08-25 19:40:07',NULL),(35,'ConfigBackup','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-08-25 19:40:07',NULL),(38,'ConfigRestore','vnf','CLI','graph','APPC','Generic_Configure','2017-09-12 13:33:14',NULL),(39,'ConfigRestore','vnf','CLI','graph','APPC','Generic_Configure','2017-09-12 13:35:11',NULL),(40,'Configure','vnf','CLI','graph','APPC','Generic_Configure','2017-09-12 16:49:54',NULL),(41,'Configure','vnf','NETCONF-XML','graph','APPC','Generic_Configure','2017-09-12 16:49:54',NULL),(42,'ConfigureRestore','vnf','CLI','graph','APPC','Generic_Configure','2017-09-12 16:49:54',NULL),(43,'ConfigureRestore','vnf','NETCONF-XML','graph','APPC','Generic_Configure','2017-09-12 16:49:54',NULL),(44,'ConfigModify','vnf','CLI','graph','APPC','Generic_Configure','2017-09-12 16:49:54',NULL),(45,'ConfigModify','vnf','NETCONF-XML','graph','APPC','Generic_Configure','2017-09-12 16:49:54',NULL),(46,'evacuate','vm','OS','graph','APPC','EvacuateVM','2017-09-12 16:49:54',NULL),(47,'rebuild','vm','OS','graph','APPC','RebuildVM','2017-09-12 16:49:54',NULL),(48,'snapshot','vm','OS','graph','APPC','CreateSnapShotVM','2017-09-12 16:49:54',NULL),(49,'migrate','vm','OS','graph','APPC','MigrateVM','2017-09-12 16:49:54',NULL),(50,'restart','vm','OS','graph','APPC','RestartVMVNFCommonFlow','2017-09-12 16:49:54',NULL),(51,'Configure','vnf','Chef','graph','APPC','Generic_Configure','2017-09-12 16:49:54',NULL),(52,'Configure','vnf','Ansible','graph','APPC','Generic_Configure','2017-09-12 16:49:54',NULL),(53,'HealthCheck','vnf','REST','graph','APPC','healthcheck','2017-09-12 16:49:54',NULL),(54,'HealthCheck','vnf','Chef','graph','APPC','Generic_ChefDG','2017-09-12 16:49:54',NULL),(55,'HealthCheck','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-09-12 16:49:54',NULL),(56,'StopApplication','vnf','Chef','graph','APPC','Generic_ChefDG','2017-09-12 16:49:54',NULL),(57,'StopApplication','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-09-12 16:49:54',NULL),(58,'StartApplication','vnf','Chef','graph','APPC','Generic_ChefDG','2017-09-12 16:49:54',NULL),(59,'StartApplication','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-09-12 16:49:54',NULL),(60,'ConfigRestore','vnf','Chef','graph','APPC','Generic_ChefDG','2017-09-12 16:49:54',NULL),(61,'ConfigRestore','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-09-12 16:49:54',NULL),(62,'ConfigBackup','vnf','Chef','graph','APPC','Generic_ChefDG','2017-09-12 16:49:54',NULL),(63,'ConfigBackup','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-09-12 16:49:54',NULL),(64,'Start','vm','OS','graph','APPC','VM_Start','2017-09-12 16:49:54',NULL),(65,'Stop','vm','OS','graph','APPC','VM_Stop','2017-09-12 16:49:54',NULL),(67,'ConfigModify','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2017-10-17 15:35:29','Y'),(68,'ConfigModify','vnf','Chef','graph','APPC','Generic_ChefDG','2017-10-17 15:35:33','Y'),(70,'Restart','vm','OS','graph','APPC','RestartVMVNFCommonFlow','2017-10-17 15:50:00',NULL),(71,'Rebuild','vm','OS','graph','APPC','RebuildVM','2017-10-17 15:51:03',NULL),(73,'Restart','vnf','OS','graph','APPC','RestartVMVNFCommonFlow','2017-10-24 16:48:06',NULL),(74,'ConfigScaleOut','vnf','Chef','graph','APPC','Generic_Configure','2018-01-26 15:00:00','Y'),(75,'ConfigScaleOut','vnf','Ansible','graph','APPC','Generic_Configure','2018-01-26 15:00:00','Y'),(76,'ConfigScaleOut','vnf','NETCONF-XML','graph','APPC','Generic_Configure','2018-01-26 15:00:00','Y');
 UNLOCK TABLES;