From: Dan Timoney <dtimoney@att.com>
Date: Thu, 24 Aug 2017 14:09:33 +0000 (-0400)
Subject: Install database schema
X-Git-Tag: v0.1.0~30
X-Git-Url: https://gerrit.onap.org/r/gitweb?p=ccsdk%2Fdistribution.git;a=commitdiff_plain;h=a016ea661ff5767a3539734c4c07ef974a6e4614

Install database schema

Fixed bug in database installation script to load database schema

Change-Id: Ie5478a40c7792ee8a5d91ea0a8af753717777971
Issue-ID: CCSDK-27
Signed-off-by: Dan Timoney <dtimoney@att.com>
---

diff --git a/odlsli/src/main/resources/sdnctl.dump b/odlsli/src/main/resources/odlsli.dump
similarity index 78%
rename from odlsli/src/main/resources/sdnctl.dump
rename to odlsli/src/main/resources/odlsli.dump
index 8be4c6a3..f38494c0 100644
--- a/odlsli/src/main/resources/sdnctl.dump
+++ b/odlsli/src/main/resources/odlsli.dump
@@ -17,136 +17,6 @@
 SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;
 SET @@SESSION.SQL_LOG_BIN= 0;
 
---
--- Table structure for table `AGNOSTIC_NOTIFICATION_URL`
---
-
-DROP TABLE IF EXISTS `AGNOSTIC_NOTIFICATION_URL`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `AGNOSTIC_NOTIFICATION_URL` (
-  `service_type` varchar(128) NOT NULL,
-  `service_instance_id` varchar(128) NOT NULL,
-  `request_id` varchar(128) NOT NULL,
-  `svc_notification_url` varchar(256) NOT NULL,
-  PRIMARY KEY (`service_type`,`service_instance_id`,`request_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `AGNOSTIC_TO_SVC_SPCFC_API`
---
-
-DROP TABLE IF EXISTS `AGNOSTIC_TO_SVC_SPCFC_API`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `AGNOSTIC_TO_SVC_SPCFC_API` (
-  `operation` varchar(128) NOT NULL,
-  `service` varchar(128) NOT NULL,
-  `service_specific_api` varchar(128) NOT NULL,
-  `async_process` varchar(15) DEFAULT NULL,
-  PRIMARY KEY (`operation`,`service`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `AIC_AVAIL_ZONE_POOL`
---
-
-DROP TABLE IF EXISTS `AIC_AVAIL_ZONE_POOL`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `AIC_AVAIL_ZONE_POOL` (
-  `aic_site_id` varchar(100) NOT NULL,
-  `status` varchar(40) NOT NULL,
-  `availability_zone` varchar(100) NOT NULL,
-  `token` varchar(5) NOT NULL,
-  `vnf_id` varchar(80) DEFAULT NULL,
-  `service_type` varchar(100) NOT NULL,
-  `vnf_type` varchar(20) DEFAULT NULL,
-  `hypervisor` varchar(10) DEFAULT NULL,
-  PRIMARY KEY (`aic_site_id`,`availability_zone`,`token`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `AIC_HOSTNAME`
---
-
-DROP TABLE IF EXISTS `AIC_HOSTNAME`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `AIC_HOSTNAME` (
-  `hostname` varchar(20) NOT NULL,
-  `cust_id` int(11) NOT NULL,
-  `vendor_code` varchar(1) NOT NULL,
-  `virtual_device_type` varchar(2) DEFAULT NULL,
-  `device_sequence` varchar(3) NOT NULL,
-  `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  PRIMARY KEY (`hostname`),
-  UNIQUE KEY `hostname` (`hostname`),
-  KEY `IN1_AIC_HOSTNAME` (`cust_id`),
-  CONSTRAINT `AC1_HOSTNAME` FOREIGN KEY (`cust_id`) REFERENCES `CUSTOMER` (`cust_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `AIC_NETWORK`
---
-
-DROP TABLE IF EXISTS `AIC_NETWORK`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `AIC_NETWORK` (
-  `network_id` varchar(100) NOT NULL,
-  `network_name` varchar(100) DEFAULT NULL,
-  `status` varchar(20) DEFAULT NULL,
-  `tenant_id` varchar(100) DEFAULT NULL,
-  `switch_uuid` varchar(100) DEFAULT NULL,
-  `portgroup_name` varchar(100) DEFAULT NULL,
-  `portgroup_id` varchar(100) DEFAULT NULL,
-  PRIMARY KEY (`network_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `AIC_SITE`
---
-
-DROP TABLE IF EXISTS `AIC_SITE`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `AIC_SITE` (
-  `name` varchar(100) DEFAULT NULL,
-  `aic_site_id` varchar(100) NOT NULL,
-  `vcenter_url` varchar(200) DEFAULT NULL,
-  `vcenter_username` varchar(40) DEFAULT NULL,
-  `vcenter_passwd` varbinary(255) DEFAULT NULL,
-  `city` varchar(100) DEFAULT NULL,
-  `state` varchar(2) DEFAULT NULL,
-  `operational_status` varchar(20) DEFAULT NULL,
-  `oam_gateway_addr` varchar(20) DEFAULT '',
-  PRIMARY KEY (`aic_site_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `AIC_SWITCH`
---
-
-DROP TABLE IF EXISTS `AIC_SWITCH`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `AIC_SWITCH` (
-  `switch_name` varchar(100) DEFAULT NULL,
-  `physical_network_name` varchar(100) NOT NULL,
-  `aic_site_id` varchar(100) DEFAULT NULL,
-  `uuid` varchar(100) DEFAULT NULL,
-  `availability_zone` varchar(100) DEFAULT NULL,
-  PRIMARY KEY (`physical_network_name`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
 --
 -- Table structure for table `ALLOCATION_ITEM`
 --
@@ -172,54 +42,6 @@ CREATE TABLE `ALLOCATION_ITEM` (
 ) ENGINE=InnoDB AUTO_INCREMENT=10104 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
---
--- Table structure for table `ALTS_CREDENTIALS`
---
-
-DROP TABLE IF EXISTS `ALTS_CREDENTIALS`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `ALTS_CREDENTIALS` (
-  `alts_username` varchar(255) NOT NULL,
-  `alts_password` varbinary(255) NOT NULL,
-  PRIMARY KEY (`alts_username`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `CITY_CODE`
---
-
-DROP TABLE IF EXISTS `CITY_CODE`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `CITY_CODE` (
-  `city_code_id` int(11) NOT NULL AUTO_INCREMENT,
-  `city_code` varchar(3) NOT NULL,
-  `city` varchar(150) NOT NULL,
-  `state` varchar(10) NOT NULL,
-  `country_code` varchar(10) NOT NULL,
-  PRIMARY KEY (`city_code_id`),
-  KEY `IN1_CITY_CODE` (`city`,`state`,`country_code`)
-) ENGINE=InnoDB AUTO_INCREMENT=37773 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `CUSTOMER`
---
-
-DROP TABLE IF EXISTS `CUSTOMER`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `CUSTOMER` (
-  `cust_id` int(11) NOT NULL AUTO_INCREMENT,
-  `customer_name` varchar(60) NOT NULL,
-  `grua` varchar(4) NOT NULL,
-  `create_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  PRIMARY KEY (`cust_id`),
-  UNIQUE KEY `IU1_CUSTOMER` (`customer_name`)
-) ENGINE=InnoDB AUTO_INCREMENT=186 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `DATA_OBJECT_MAPPING`
@@ -733,141 +555,7 @@ CREATE TABLE `MAX_SERVER_SPEED` (
 ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
---
--- Table structure for table `NBNC_BORDER_ELEMENT`
---
-
-DROP TABLE IF EXISTS `NBNC_BORDER_ELEMENT`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `NBNC_BORDER_ELEMENT` (
-  `be_id` varchar(32) NOT NULL,
-  `be_type` varchar(16) NOT NULL,
-  `be_name` varchar(32) DEFAULT NULL,
-  `be_host_vnf_id` varchar(32) DEFAULT NULL,
-  `service_type_array` varchar(512) DEFAULT NULL,
-  `tangibility` varchar(16) DEFAULT NULL,
-  `usage_order` smallint(6) DEFAULT NULL,
-  `vlan_start` smallint(6) DEFAULT NULL,
-  `vlan_end` smallint(6) DEFAULT NULL,
-  `ipv4_subnet` varchar(18) DEFAULT NULL,
-  `ipv6_subnet` varchar(68) DEFAULT NULL,
-  `network_ip` varchar(48) DEFAULT NULL,
-  `be_location` varchar(16) DEFAULT NULL,
-  `description` varchar(128) DEFAULT NULL,
-  `updated_timestamp` timestamp NULL DEFAULT NULL,
-  `log_link_model_uuid` varchar(64) DEFAULT NULL,
-  PRIMARY KEY (`be_id`,`be_type`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `NBNC_IPE`
---
-
-DROP TABLE IF EXISTS `NBNC_IPE`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `NBNC_IPE` (
-  `ipe_name` varchar(32) NOT NULL,
-  `ipe_location` varchar(16) DEFAULT NULL,
-  `ipe_ip_address` varchar(16) DEFAULT NULL,
-  `ipe_id` varchar(8) DEFAULT NULL,
-  `service_type_array` varchar(512) DEFAULT NULL,
-  `ipe_status` varchar(32) DEFAULT NULL,
-  `updated_timestamp` timestamp NULL DEFAULT NULL,
-  PRIMARY KEY (`ipe_name`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `NBNC_IPE_PORT`
---
-
-DROP TABLE IF EXISTS `NBNC_IPE_PORT`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `NBNC_IPE_PORT` (
-  `port_id` varchar(16) NOT NULL,
-  `ipe_name` varchar(32) NOT NULL,
-  `be_id` varchar(32) NOT NULL,
-  `be_type` varchar(16) NOT NULL,
-  `port_type` varchar(16) DEFAULT NULL,
-  `ae_name` varchar(16) DEFAULT NULL,
-  `description` varchar(128) DEFAULT NULL,
-  `updated_timestamp` timestamp NULL DEFAULT NULL,
-  PRIMARY KEY (`port_id`,`ipe_name`,`be_id`,`be_type`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `NBNC_MAPPING_SBG_BGF`
---
 
-DROP TABLE IF EXISTS `NBNC_MAPPING_SBG_BGF`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `NBNC_MAPPING_SBG_BGF` (
-  `asbg_vlan` smallint(6) NOT NULL,
-  `bgf_vlan` smallint(6) NOT NULL,
-  PRIMARY KEY (`asbg_vlan`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `NBNC_SERVICE`
---
-
-DROP TABLE IF EXISTS `NBNC_SERVICE`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `NBNC_SERVICE` (
-  `service_type` varchar(16) NOT NULL,
-  `service_model_uuid` varchar(64) NOT NULL,
-  `description` varchar(128) DEFAULT NULL,
-  `created_timestamp` timestamp NULL DEFAULT NULL,
-  `updated_timestamp` timestamp NULL DEFAULT NULL,
-  PRIMARY KEY (`service_type`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `NBNC_SERVICE_VLAN`
---
-
-DROP TABLE IF EXISTS `NBNC_SERVICE_VLAN`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `NBNC_SERVICE_VLAN` (
-  `be_id` varchar(32) NOT NULL,
-  `vlan` smallint(6) NOT NULL,
-  `service_type` varchar(16) DEFAULT NULL,
-  `be_type` varchar(16) DEFAULT NULL,
-  `be_name` varchar(32) DEFAULT NULL,
-  `be_host_vnf_id` varchar(32) DEFAULT NULL,
-  `be_location` varchar(16) DEFAULT NULL,
-  `be_usage_order` smallint(6) DEFAULT NULL,
-  `vlan_usage_order` smallint(6) DEFAULT NULL,
-  `status` varchar(16) DEFAULT 'AVAILABLE',
-  `request_id` varchar(64) DEFAULT NULL,
-  `service_instance_id` varchar(64) DEFAULT NULL,
-  `vni_id` varchar(16) DEFAULT NULL,
-  `customer_id` varchar(16) DEFAULT NULL,
-  `ipe1_router_name` varchar(32) DEFAULT NULL,
-  `ipe1_port_id` varchar(16) DEFAULT NULL,
-  `ipe1_ae_name` varchar(16) DEFAULT NULL,
-  `ipe2_router_name` varchar(32) DEFAULT NULL,
-  `ipe2_port_id` varchar(16) DEFAULT NULL,
-  `ipe2_ae_name` varchar(16) DEFAULT NULL,
-  `available_timestamp` timestamp NULL DEFAULT NULL,
-  `allocated_timestamp` timestamp NULL DEFAULT NULL,
-  `disabled_timestamp` timestamp NULL DEFAULT NULL,
-  `enabled_timestamp` timestamp NULL DEFAULT NULL,
-  `vpn_id` varchar(12) DEFAULT NULL,
-  `vpn_rt` varchar(16) DEFAULT NULL,
-  PRIMARY KEY (`be_id`,`vlan`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `NETWORK_PROFILE`
@@ -991,43 +679,6 @@ CREATE TABLE `PORTAL_USERS` (
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
---
--- Table structure for table `PRE_LOAD_VNF_DATA`
---
-
-DROP TABLE IF EXISTS `PRE_LOAD_VNF_DATA`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `PRE_LOAD_VNF_DATA` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `svc_request_id` varchar(100) DEFAULT '',
-  `svc_action` varchar(40) DEFAULT '',
-  `status` varchar(10) NOT NULL DEFAULT 'pending',
-  `filename` varchar(100) NOT NULL,
-  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-  `preload_data` longblob,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `PRE_LOAD_VNF_NETWORK_DATA`
---
-
-DROP TABLE IF EXISTS `PRE_LOAD_VNF_NETWORK_DATA`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `PRE_LOAD_VNF_NETWORK_DATA` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
-  `svc_request_id` varchar(100) DEFAULT '',
-  `svc_action` varchar(40) DEFAULT '',
-  `status` varchar(10) NOT NULL DEFAULT 'pending',
-  `filename` varchar(100) NOT NULL,
-  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-  `preload_data` longblob,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `PSERVER`
@@ -1179,59 +830,6 @@ CREATE TABLE `RESOURCE_THRESHOLD` (
 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
---
--- Table structure for table `SERVICE_HOMING`
---
-
-DROP TABLE IF EXISTS `SERVICE_HOMING`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `SERVICE_HOMING` (
-  `service_type` varchar(100) NOT NULL,
-  `lata` int(3) NOT NULL,
-  `hubbing_city_type` varchar(40) NOT NULL,
-  `latitude` float DEFAULT NULL,
-  `longitude` float DEFAULT NULL,
-  `primary_aic_site_name` varchar(100) NOT NULL,
-  `secondary_aic_site_name` varchar(100) DEFAULT NULL,
-  `tertiary_aic_site_name` varchar(100) DEFAULT NULL,
-  PRIMARY KEY (`service_type`,`lata`,`hubbing_city_type`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `SERVICE_HOMING_BACKUP`
---
-
-DROP TABLE IF EXISTS `SERVICE_HOMING_BACKUP`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `SERVICE_HOMING_BACKUP` (
-  `service_type` varchar(100) NOT NULL,
-  `lata` int(3) NOT NULL,
-  `hubbing_city_type` varchar(40) NOT NULL,
-  `latitude` float DEFAULT NULL,
-  `longitude` float DEFAULT NULL,
-  `primary_aic_site_name` varchar(100) NOT NULL,
-  `secondary_aic_site_name` varchar(100) DEFAULT NULL,
-  `tertiary_aic_site_name` varchar(100) DEFAULT NULL,
-  PRIMARY KEY (`service_type`,`lata`,`hubbing_city_type`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `SERVICE_MANAGER_CREDENTIALS`
---
-
-DROP TABLE IF EXISTS `SERVICE_MANAGER_CREDENTIALS`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `SERVICE_MANAGER_CREDENTIALS` (
-  `service_manager_username` varchar(255) NOT NULL,
-  `service_manager_password` varbinary(255) NOT NULL,
-  PRIMARY KEY (`service_manager_username`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- Table structure for table `SERVICE_RESOURCE`
diff --git a/odlsli/src/main/scripts/installSdncDb.sh b/odlsli/src/main/scripts/installSdncDb.sh
index 37329d7b..4966dba4 100644
--- a/odlsli/src/main/scripts/installSdncDb.sh
+++ b/odlsli/src/main/scripts/installSdncDb.sh
@@ -10,9 +10,9 @@
 # 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.
@@ -21,7 +21,7 @@
 # ============LICENSE_END=========================================================
 ###
 
-SDNC_HOME=${SDNC_HOME:-/opt/openecomp/sdnc}
+SDNC_HOME=${SDNC_HOME:-/opt/onap/sdnc}
 MYSQL_PASSWD=${MYSQL_PASSWD:-openECOMP1.0}
 
 SDNC_DB_USER=${SDNC_DB_USER:-sdnctl}
@@ -41,5 +41,5 @@ END
 
 if [ -f ${SDNC_HOME}/data/sdnctl.dump ]
 then
-  mysql -h dbhost -u root -p${MYSQL_PASSWD} sdnctl < ${SDNC_HOME}/data/sdnctl.dump
+mysql -h dbhost -u root -p${MYSQL_PASSWD} sdnctl < ${SDNC_HOME}/data/odlsli.dump
 fi