Update initialization of VNF_DG_MAPPING table

Update the data to be loaded into the table
Move source location of the data to the sqlData.dump file
Remove old source location (VNF_DG_MAPPING.sql)
Update install.sh to remove call to VNF_DG_MAPPING.sql

Issue-ID: [APPC-295]
Change-Id: I525fb0f717237388d04989fe49eca3e6498b09ef
Signed-off-by: Skip Wonnell <skip@att.com>

2 files changed, 0 insertions, 59 deletions

diff --git a/platform-logic/installer/src/main/resources/VNF_DG_MAPPING.sql b/platform-logic/installer/src/main/resources/VNF_DG_MAPPING.sql
deleted file mode 100644
index c54e06a..0000000
--- a/platform-logic/installer/src/main/resources/VNF_DG_MAPPING.sql
+++ /dev/null
@@ -1,50 +0,0 @@
-
--- ============LICENSE_START=======================================================
--- APPC
--- ================================================================================
--- Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
--- ================================================================================
--- Licensed under the Apache License, Version 2.0 (the "License");
--- you may not use this file 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=========================================================
-
-
---
--- 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','','','Generic_Restart','3.0.0','APPC'), ('Restart','2.00','','','Generic_Restart','3.0.0','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 77052ae..a557711 100644
--- a/platform-logic/installer/src/main/scripts/install.sh
+++ b/platform-logic/installer/src/main/scripts/install.sh
@@ -45,12 +45,3 @@ do
      $BASEDIR/bin/svclogic.sh activate $module $rpc $version $mode $BASEDIR/config/svclogic.properties
   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 /opt/openecomp/appc/svclogic/config/VNF_DG_MAPPING.sql
-END