Adding row to ASDC_ARTIFACTS table

[appc/deployment.git] / installation / appc / src / main / resources / sqlData.dump

diff --git a/installation/appc/src/main/resources/sqlData.dump b/installation/appc/src/main/resources/sqlData.dump
index 0e8b223..9d28eb5 100644 (file)
--- a/installation/appc/src/main/resources/sqlData.dump
+++ b/installation/appc/src/main/resources/sqlData.dump
@@ -25,7 +25,7 @@ USE sdnctl;
 
 
 LOCK TABLES `VNF_DG_MAPPING` WRITE;
-INSERT INTO `VNF_DG_MAPPING` VALUES ('','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'),('','DistributeTraffic',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC'),('','DistributeTrafficCheck',NULL,NULL,NULL,'DGOrchestrator','4.0.0','APPC');
+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');
 UNLOCK TABLES;
 
 
@@ -50,3 +50,11 @@ INSERT INTO DOWNLOAD_DG_REFERENCE (DOWNLOAD_DG_REFERENCE_ID, PROTOCOL, DOWNLOAD_
 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;