2 files changed, 38 insertions, 0 deletions
diff --git a/platform-logic/installer/src/main/scripts/VNF_DG_MAPPING.sql b/platform-logic/installer/src/main/scripts/VNF_DG_MAPPING.sql
new file mode 100644
index 0000000..764e694
--- /dev/null
+++ b/platform-logic/installer/src/main/scripts/VNF_DG_MAPPING.sql
@@ -0,0 +1,30 @@
+--
+-- Table structure for table `VNF_DG_MAPPING`
+--
+
+USE sdnctl;
+DROP TABLE IF EXISTS `VNF_DG_MAPPING`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `VNF_DG_MAPPING` (
+  `action` varchar(50) NOT NULL,
+  `api_version` varchar(50) DEFAULT NULL,
+  `vnf_type` varchar(50) DEFAULT NULL,
+  `vnf_version` varchar(50) DEFAULT NULL,
+  `dg_name` varchar(50) NOT NULL,
+  `dg_version` varchar(50) DEFAULT NULL,
+  `dg_module` varchar(50) NOT NULL,
+  UNIQUE KEY `INPUT_CONSTRAINT` (`action`,`api_version`,`vnf_type`,`vnf_version`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `VNF_DG_MAPPING`
+--
+
+LOCK TABLES `VNF_DG_MAPPING` WRITE;
+/*!40000 ALTER TABLE `VNF_DG_MAPPING` DISABLE KEYS */;
+INSERT INTO `VNF_DG_MAPPING` VALUES ('Restart','2.01','','','legacy_operation','2.0.0','APPC'), ('Restart','2.00','','','Restart_VNF','2.0.1','APPC');
+
+/*!40000 ALTER TABLE `VNF_DG_MAPPING` ENABLE KEYS */;
+UNLOCK TABLES;
diff --git a/platform-logic/installer/src/main/scripts/install.sh b/platform-logic/installer/src/main/scripts/install.sh
index ddf3933..9711b70 100644
--- a/platform-logic/installer/src/main/scripts/install.sh
+++ b/platform-logic/installer/src/main/scripts/install.sh
@@ -46,3 +46,11 @@ do
   done < <(cat $graphlist)
 done
 
+MYSQL_USER=${MYSQL_USER:-sdnctl}
+MYSQL_PWD=${MYSQL_PWD:-gamma}
+MYSQL_DB=${MYSQL_DB:-sdnctl}
+MYSQL_HOST=${MYSQL_HOST:-dbhost}
+
+mysql --user=${MYSQL_USER} --password=${MYSQL_PWD} --host=${MYSQL_HOST} ${MYSQL_DB} <<-END
+SOURCE VNF_DG_MAPPING.sql
+END