diff options
| -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.sh | 8 |
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 |