summaryrefslogtreecommitdiffstats
path: root/odlsli
diff options
context:
space:
mode:
Diffstat (limited to 'odlsli')
-rw-r--r--odlsli/src/main/resources/odlsli.dump (renamed from odlsli/src/main/resources/sdnctl.dump)402
-rw-r--r--odlsli/src/main/scripts/installSdncDb.sh8
2 files changed, 4 insertions, 406 deletions
diff --git a/odlsli/src/main/resources/sdnctl.dump b/odlsli/src/main/resources/odlsli.dump
index 8be4c6a3..f38494c0 100644
--- a/odlsli/src/main/resources/sdnctl.dump
+++ b/odlsli/src/main/resources/odlsli.dump
@@ -18,136 +18,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