aboutsummaryrefslogtreecommitdiffstats
path: root/platform-logic/installer/src
diff options
context:
space:
mode:
Diffstat (limited to 'platform-logic/installer/src')
-rw-r--r--platform-logic/installer/src/main/scripts/VNF_DG_MAPPING.sql30
-rw-r--r--platform-logic/installer/src/main/scripts/install.sh8
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