--  ============LICENSE_START==========================================
--  ONAP : APPC
--  ===================================================================
--  Copyright (C) 2017-2018 AT&T Intellectual Property. All rights reserved.
--  ===================================================================
--  Modifications Copyright (C) 2019 Orange
--  ===================================================================
--
--  Unless otherwise specified, all software contained herein is licensed
--  under the Apache License, Version 2.0 (the License);
--  you may not use this software except in compliance with the License.
--  You may obtain a copy of the License at
--
--     http://www.apache.org/licenses/LICENSE-2.0
--
--  Unless required by applicable law or agreed to in writing, software
--  distributed under the License is distributed on an "AS IS" BASIS,
--  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--  See the License for the specific language governing permissions and
--  limitations under the License.
--
--  ============LICENSE_END============================================

USE sdnctl;


LOCK TABLES `VNF_DG_MAPPING` WRITE;
INSERT INTO `VNF_DG_MAPPING` VALUES (1,'Restart','2.00','','','Generic_Restart','3.0.0','APPC'),(2,'Configure',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(3,'ConfigModify',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(4,'Rebuild',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(5,'Restart',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(6,'HealthCheck',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(7,'StartApplication',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(8,'StopApplication',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(9,'Migrate',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(10,'Snapshot',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(11,'ConfigRestore',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(12,'ConfigBackup',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(13,'Evacuate',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(14,'Stop',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(15,'Start',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(16,'ConfigScaleOut',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(17,'DistributeTraffic',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(18,'DistributeTrafficCheck',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(19,'UpgradeSoftware',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(20,'UpgradePreCheck',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(21,'UpgradePostCheck',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(22,'UpgradeBackout',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(23,'UpgradeBackup',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(24,'LicenseManagement',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(25,'PreConfigure',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(26,'GetConfig',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(27,'PostRebuild',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(28,'PreRebuild',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(29,'PreEvacuate',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(30,'PostEvacuate',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(31,'PreMigrate',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(32,'PostMigrate',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(33,'Provisioning',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(34,'StartTraffic',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(35,'StatusTraffic',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(36,'StopTraffic',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(37,'DownloadNESw',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(38,'ActivateNESw',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),(39,'ConfigScaleIn',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,'userid','2017-10-30 19:23:07');
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),(74,'ConfigScaleOut','vnf','Chef','graph','APPC','Generic_Configure','2018-01-26 15:00:00','Y'),(75,'ConfigScaleOut','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2018-09-06 15:00:00',NULL),(76,'ConfigScaleOut','vnf','NETCONF-XML','graph','APPC','Generic_Configure','2018-01-26 15:00:00','Y'),(77,'DistributeTraffic','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2018-09-06 15:00:00',NULL),(78,'DistributeTraffic','vnf','Chef','graph','APPC','Generic_ChefDG','2017-09-06 15:00:00',NULL),(79,'DistributeTrafficCheck','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-03-06 15:00:00',NULL),(80,'DistributeTrafficCheck','vnf','Chef','graph','APPC','Generic_ChefDG','2019-03-06 15:00:00',NULL),(81,'UpgradeSoftware','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-09-26 11:00:00',NULL),(82,'UpgradeSoftware','vnf','Chef','graph','APPC','Generic_ChefDG','2019-09-26 11:00:00',NULL),(83,'UpgradePreCheck','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-09-26 11:00:00',NULL),(84,'UpgradePreCheck','vnf','Chef','graph','APPC','Generic_ChefDG','2019-09-26 11:00:00',NULL),(85,'UpgradePostCheck','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-09-26 11:00:00',NULL),(86,'UpgradePostCheck','vnf','Chef','graph','APPC','Generic_ChefDG','2019-09-26 11:00:00',NULL),(87,'UpgradeBackout','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-09-26 11:00:00',NULL),(88,'UpgradeBackout','vnf','Chef','graph','APPC','Generic_ChefDG','2019-09-26 11:00:00',NULL),(89,'UpgradeBackup','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-09-26 11:00:00',NULL),(90,'UpgradeBackup','vnf','Chef','graph','APPC','Generic_ChefDG','2019-09-26 11:00:00',NULL),(91,'LicenseManagement','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-12-18 11:00:00',NULL),(92,'PreConfigure','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-12-18 11:00:00',NULL),(93,'GetConfig','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-12-18 11:00:00',NULL),(94,'PostRebuild','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-12-18 11:00:00',NULL),(95,'PreRebuild','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-12-18 11:00:00',NULL),(96,'PreEvacuate','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-12-18 11:00:00',NULL),(97,'PostEvacuate','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-12-18 11:00:00',NULL),(98,'PreMigrate','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-12-18 11:00:00',NULL),(99,'PostMigrate','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-12-18 11:00:00',NULL),(100,'Provisioning','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-12-18 11:00:00',NULL),(101,'StartTraffic','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-12-18 11:00:00',NULL),(102,'StatusTraffic','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-12-18 11:00:00',NULL),(103,'StopTraffic','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-12-18 11:00:00',NULL),(104,'DownloadNESw','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2020-01-06 11:30:00',NULL),(105,'ActivateNESw','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2020-01-06 11:30:00',NULL),(106,'ConfigScaleIn','vnf','Chef','graph','APPC','Generic_Configure','2019-12-09 11:00:00','Y'),(107,'ConfigScaleIn','vnf','Ansible','graph','APPC','Generic_AnsibleDG','2019-12-09 11:00:00',NULL),(108,'ConfigScaleIn','vnf','NETCONF-XML','graph','APPC','Generic_Configure','2019-12-09 11:00:00','Y');
UNLOCK TABLES;

LOCK TABLES `DOWNLOAD_DG_REFERENCE` WRITE;
INSERT INTO `DOWNLOAD_DG_REFERENCE` VALUES (1,'NETCONF-XML','DownloadXmlConfig');
INSERT INTO DOWNLOAD_DG_REFERENCE (DOWNLOAD_DG_REFERENCE_ID, PROTOCOL, DOWNLOAD_CONFIG_DG) VALUES (0, 'ANSIBLE', 'DownloadAnsibleConfig');
INSERT INTO DOWNLOAD_DG_REFERENCE (DOWNLOAD_DG_REFERENCE_ID, PROTOCOL, DOWNLOAD_CONFIG_DG) VALUES (0, 'CHEF', 'Generic_ChefDG');
INSERT INTO DOWNLOAD_DG_REFERENCE (DOWNLOAD_DG_REFERENCE_ID, PROTOCOL, DOWNLOAD_CONFIG_DG) VALUES (0, 'CLI', 'DownloadIsbcConfig');
INSERT INTO DOWNLOAD_DG_REFERENCE (DOWNLOAD_DG_REFERENCE_ID, PROTOCOL, DOWNLOAD_CONFIG_DG) VALUES (0, 'RESTCONF', 'DownloadRestconfConfig');
INSERT INTO DOWNLOAD_DG_REFERENCE (DOWNLOAD_DG_REFERENCE_ID, PROTOCOL, DOWNLOAD_CONFIG_DG) VALUES (0, 'NETCONF', 'DownloadXmlConfig');
UNLOCK TABLES;

LOCK TABLES `DEVICE_AUTHENTICATION` WRITE;
INSERT INTO DEVICE_AUTHENTICATION  (PROTOCOL, VNF_TYPE, ACTION, USER_NAME, PASSWORD, URL) VALUES ('ANSIBLE', '', '', 'admin','admin', 'http://appc-ansible-server:8000/Dispatch');
UNLOCK TABLES;

LOCK TABLES `ASDC_ARTIFACTS` WRITE;
INSERT INTO ASDC_ARTIFACTS (SERVICE_UUID, DISTRIBUTION_ID, SERVICE_NAME, SERVICE_DESCRIPTION, RESOURCE_UUID, RESOURCE_INSTANCE_NAME, RESOURCE_NAME, RESOURCE_VERSION, RESOURCE_TYPE, ARTIFACT_UUID, ARTIFACT_TYPE, ARTIFACT_VERSION, ARTIFACT_DESCRIPTION, INTERNAL_VERSION, CREATION_DATE, ARTIFACT_NAME, ARTIFACT_CONTENT)
VALUES (null, null, null, null, null, null, null, null, null, null, null, null, null, 0, '2017-11-11 08:46:19', 'request_validation_policy','{"request-validation-policies":[{"name" : "ActionInProgress","rules":[{"action-received": "Audit","validation-rule": "Reject","in-progress-action-exclusion-list": ["HealthCheck","Test","CheckLock"]},{"action-received": "Sync","validation-rule": "Reject","in-progress-action-exclusion-list": ["HealthCheck","Test","CheckLock"]},{"action-received": "Test","validation-rule": "Reject","in-progress-action-exclusion-list": ["HealthCheck","CheckLock"]},{"action-received": "HealthCheck","validation-rule": "Accept","in-progress-action-inclusion-list": ["Audit","Sync","CheckLock"]},{"action-received": "Default","validation-rule": "Reject","in-progress-action-exclusion-list": ["CheckLock"]}]}]}');
UNLOCK TABLES;