-CREATE DATABASE IF NOT EXISTS `sdnctl` /*!40100 DEFAULT CHARACTER SET latin1 */;
-USE `sdnctl`;
+-- ============LICENSE_START==========================================
+-- ONAP : APPC
+-- ===================================================================
+-- Copyright (C) 2018-2019 AT&T Intellectual Property. All rights reserved.
+-- ===================================================================
+--
+-- Unless otherwise specified, all software contained herein is licensed
+-- under the Apache License, Version 2.0 (the License);
+-- you may not use this software 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.
+--
+-- ECOMP is a trademark and service mark of AT&T Intellectual Property.
+-- ============LICENSE_END============================================
+
+--
+-- Current Database: `sdnctl`
+--
+
+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `sdnctl` /*!40100 DEFAULT CHARACTER SET latin1 */;
-SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;
-SET @@SESSION.SQL_LOG_BIN= 0;
+USE `sdnctl`;
--
-- Table structure for table `ACTION_LEVEL_REFERENCE`
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
+--
+-- Table structure for table `APPC_APP_PARAM`
+--
+
+DROP TABLE IF EXISTS `APPC_APP_PARAM`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `APPC_APP_PARAM` (
+ `APPC_APP_PARAM_ID` int(11) NOT NULL AUTO_INCREMENT,
+ `PARAM_KEY` varchar(50) NOT NULL,
+ `PARAM_VALUE` varchar(50) NOT NULL,
+ UNIQUE KEY `APPC_APP_PARAM_ID` (`APPC_APP_PARAM_ID`)
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `APPC_HEALTH`
+--
+
+DROP TABLE IF EXISTS `APPC_HEALTH`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `APPC_HEALTH` (
+ `APPC_HEALTH_ID` int(11) NOT NULL AUTO_INCREMENT,
+ `HEALTHY` varchar(30) NOT NULL,
+ PRIMARY KEY (`APPC_HEALTH_ID`)
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
--
-- Table structure for table `ASDC_ARTIFACTS`
--
`ARTIFACT_CONTENT` longtext,
PRIMARY KEY (`ASDC_ARTIFACTS_ID`),
UNIQUE KEY `ASDC_ARTIFACTS_ID` (`ASDC_ARTIFACTS_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=1412 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=5093 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ASDC_REFERENCE` (
`ASDC_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
- `VNF_TYPE` varchar(50) DEFAULT NULL,
+ `VNF_TYPE` varchar(150) DEFAULT NULL,
`VNFC_TYPE` varchar(50) DEFAULT NULL,
`FILE_CATEGORY` varchar(50) DEFAULT NULL,
`ACTION` varchar(50) DEFAULT NULL,
`ARTIFACT_NAME` varchar(255) DEFAULT NULL,
PRIMARY KEY (`ASDC_REFERENCE_ID`),
UNIQUE KEY `ASDC_REFERENCE_ID` (`ASDC_REFERENCE_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=352 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
`DATA_SOURCE` varchar(25) DEFAULT NULL,
`CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
- `VNF_TYPE` varchar(50) DEFAULT NULL,
+ `VNF_TYPE` varchar(150) DEFAULT NULL,
`VNFC_TYPE` varchar(50) DEFAULT NULL,
`FILE_CATEGORY` varchar(50) DEFAULT NULL,
`FILE_NAME` varchar(255) DEFAULT NULL,
`VNF_NAME` varchar(50) DEFAULT NULL,
PRIMARY KEY (`CONFIG_FILE_ID`),
UNIQUE KEY `CONFIG_FILE_ID` (`CONFIG_FILE_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=688 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=5751 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CONFIGURE_ACTION_DG` (
`CONFIGURE_ACTION_DG_ID` int(11) NOT NULL AUTO_INCREMENT,
- `VNF_TYPE` varchar(50) DEFAULT NULL,
+ `VNF_TYPE` varchar(150) DEFAULT NULL,
`ACTION` varchar(50) DEFAULT NULL,
`GENERATE_CONFIG_DG` varchar(50) DEFAULT NULL,
`DOWNLOAD_CONFIG_DG` varchar(50) DEFAULT NULL,
PRIMARY KEY (`CONFIGURE_ACTION_DG_ID`),
UNIQUE KEY ` CONFIGURE_ACTION_DG_ID` (`CONFIGURE_ACTION_DG_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
CREATE TABLE `CONFIG_FILE_REFERENCE` (
`CONFIG_FILE_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
`SITE_LOCATION` varchar(50) DEFAULT NULL,
- `VNF_TYPE` varchar(50) DEFAULT NULL,
+ `VNF_TYPE` varchar(150) DEFAULT NULL,
`IMPORT_TYPE` varchar(50) DEFAULT NULL,
`FILE_TYPE` varchar(50) DEFAULT NULL,
`SOURCE_SERVER_NAME` varchar(255) DEFAULT NULL,
`FILE_NAME` varchar(255) DEFAULT NULL,
PRIMARY KEY (`CONFIG_FILE_REFERENCE_ID`),
UNIQUE KEY `CONFIG_FILE_REFERENCE_ID` (`CONFIG_FILE_REFERENCE_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
`MESSAGE` longtext,
PRIMARY KEY (`CONFIG_TRANSACTION_LOG_ID`),
UNIQUE KEY ` CONFIG_TRANSACTION_LOG_ID` (`CONFIG_TRANSACTION_LOG_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=1074 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=40247 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DEVICE_AUTHENTICATION` (
`DEVICE_AUTHENTICATION_ID` int(11) NOT NULL AUTO_INCREMENT,
- `VNF_TYPE` varchar(50) DEFAULT NULL,
- `USER_NAME` varchar(50) DEFAULT NULL,
- `PASSWORD` varchar(100) DEFAULT NULL,
+ `VNF_TYPE` varchar(255) NOT NULL,
+ `PROTOCOL` varchar(255) NOT NULL,
+ `ACTION` varchar(255) NOT NULL,
+ `USER_NAME` varchar(255) DEFAULT NULL,
+ `PASSWORD` varchar(255) DEFAULT NULL,
`PORT_NUMBER` int(11) DEFAULT NULL,
+ `URL` varchar(256) DEFAULT NULL,
PRIMARY KEY (`DEVICE_AUTHENTICATION_ID`),
- UNIQUE KEY `DEVICE_AUTHENTICATION_ID` (`DEVICE_AUTHENTICATION_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
+ UNIQUE KEY `VNF_TYPE_UNIQ` (`VNF_TYPE`,`PROTOCOL`,`ACTION`,`URL`),
+ KEY `PROTOCOL` (`PROTOCOL`),
+ KEY `ACTION` (`ACTION`)
+) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- Temporary view structure for view `DEVICE_CONFIGURATION`
+-- Temporary table structure for view `DEVICE_CONFIGURATION`
--
DROP TABLE IF EXISTS `DEVICE_CONFIGURATION`;
`DEVICE_INTERFACE_LOG_ID` int(11) NOT NULL AUTO_INCREMENT,
`SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
`REQUEST_ID` varchar(50) DEFAULT NULL,
- `CREATION_DATE` datetime NOT NULL,
+ `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`LOG` longtext,
PRIMARY KEY (`DEVICE_INTERFACE_LOG_ID`),
UNIQUE KEY `DEVICE_INTERFACE_LOG_ID` (`DEVICE_INTERFACE_LOG_ID`)
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DEVICE_INTERFACE_PROTOCOL` (
`DEVICE_INTERFACE_PROTOCOL_ID` int(11) NOT NULL AUTO_INCREMENT,
- `VNF_TYPE` varchar(50) DEFAULT NULL,
+ `VNF_TYPE` varchar(150) DEFAULT NULL,
`PROTOCOL` varchar(50) DEFAULT NULL,
`MODULE` varchar(50) DEFAULT NULL,
`DG_RPC` varchar(50) DEFAULT NULL,
PRIMARY KEY (`DEVICE_INTERFACE_PROTOCOL_ID`),
- UNIQUE KEY `DEVICE_INTERFACE_PROTOCOL_ID` (`DEVICE_INTERFACE_PROTOCOL_ID`),
- UNIQUE KEY `VNF_TYPE` (`VNF_TYPE`)
-) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
+ UNIQUE KEY `DEVICE_INTERFACE_PROTOCOL_ID` (`DEVICE_INTERFACE_PROTOCOL_ID`)
+) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DOWNLOAD_CONFIG_TEMPLATE` (
`DOWNLOAD_CONFIG_TEMPLATE_ID` int(11) NOT NULL AUTO_INCREMENT,
- `VNF_TYPE` varchar(50) NOT NULL,
+ `VNF_TYPE` varchar(150) DEFAULT NULL,
`PROTOCOL` varchar(50) NOT NULL,
`TEMPLATE` longtext,
PRIMARY KEY (`DOWNLOAD_CONFIG_TEMPLATE_ID`),
UNIQUE KEY `DOWNLOAD_CONFIG_TEMPLATE_ID` (`DOWNLOAD_CONFIG_TEMPLATE_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
CREATE TABLE `DT_ACTION_STATUS` (
`DT_ACTION_STATUS_ID` int(11) NOT NULL AUTO_INCREMENT,
`ACTION` varchar(50) NOT NULL,
- `VNF_TYPE` varchar(50) DEFAULT NULL,
+ `VNF_TYPE` varchar(150) DEFAULT NULL,
`VNFC_TYPE` varchar(50) DEFAULT NULL,
`USER` varchar(50) NOT NULL,
`TECHNOLOGY` varchar(50) DEFAULT NULL,
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `GET_CONFIG_TEMPLATE` (
`GET_CONFIG_TEMPLATE_ID` int(11) NOT NULL AUTO_INCREMENT,
- `VNF_TYPE` varchar(50) NOT NULL,
+ `VNF_TYPE` varchar(150) DEFAULT NULL,
`DEVICE_INTERFACE_PROTOCOL_ID` int(11) NOT NULL,
`XML_PROCESSING` varchar(1) DEFAULT NULL,
`XML_PROTOCOL` varchar(30) DEFAULT NULL,
UNIQUE KEY `GET_CONFIG_TEMPLATE_ID` (`GET_CONFIG_TEMPLATE_ID`),
KEY `get_config_template_ibfk_1` (`DEVICE_INTERFACE_PROTOCOL_ID`),
CONSTRAINT `get_config_template_ibfk_1` FOREIGN KEY (`DEVICE_INTERFACE_PROTOCOL_ID`) REFERENCES `DEVICE_INTERFACE_PROTOCOL` (`DEVICE_INTERFACE_PROTOCOL_ID`) ON DELETE NO ACTION ON UPDATE CASCADE
-) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
`MULTISTEP_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
`ACTION` varchar(50) NOT NULL,
`ACTION_LEVEL` varchar(50) DEFAULT NULL,
- `VNF_TYPE` varchar(50) DEFAULT NULL,
+ `VNF_TYPE` varchar(150) DEFAULT NULL,
`SEQUENCE_TYPE` varchar(50) DEFAULT NULL,
`CATEGORY` varchar(50) DEFAULT NULL,
`GENERATION_NODE` varchar(50) DEFAULT NULL,
`CREATOR` varchar(50) DEFAULT NULL,
`UPDATED_DATE` datetime DEFAULT NULL,
UNIQUE KEY ` MULTISTEP_FLOW_REFERENCE_ID` (`MULTISTEP_FLOW_REFERENCE_ID`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
+--
+-- Table structure for table `OPS_AIC_REGIONS`
+--
+
+DROP TABLE IF EXISTS `OPS_AIC_REGIONS`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_AIC_REGIONS` (
+ `REGION_ID` varchar(16) NOT NULL,
+ `IDENTITY_URL` varchar(256) NOT NULL,
+ `HOST_DISCOVERY` varchar(3) NOT NULL DEFAULT 'NO',
+ `ADMIN_TENANT_ID` varchar(64) DEFAULT NULL,
+ `ADMIN_TENANT_NAME` varchar(64) DEFAULT 'admin',
+ `CREATED` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATED` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
+ PRIMARY KEY (`REGION_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `OPS_AIC_HOSTS`
+--
+
+DROP TABLE IF EXISTS `OPS_AIC_HOSTS`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_AIC_HOSTS` (
+ `REGION_ID` varchar(16) NOT NULL,
+ `HOST` varchar(64) NOT NULL,
+ `HOST_IP` varchar(64) DEFAULT NULL,
+ `EQUIPMENT_VENDOR` varchar(32) DEFAULT NULL,
+ `EQUIPMENT_PRODUCT` varchar(32) DEFAULT NULL,
+ `EQUIPMENT_MODEL` varchar(32) DEFAULT NULL,
+ `EQUIPMENT_VERSION` varchar(32) DEFAULT NULL,
+ `CREATED` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATED` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
+ PRIMARY KEY (`REGION_ID`,`HOST`),
+ CONSTRAINT `fk_aic_hosts` FOREIGN KEY (`REGION_ID`) REFERENCES `OPS_AIC_REGIONS` (`REGION_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `OPS_AIC_SCHEDULER_EVENTS`
+--
+
+DROP TABLE IF EXISTS `OPS_AIC_SCHEDULER_EVENTS`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_AIC_SCHEDULER_EVENTS` (
+ `REGION_ID` varchar(16) NOT NULL,
+ `HOST` varchar(64) NOT NULL DEFAULT '',
+ `STATE` enum('COMPLETE','PROGRESS') DEFAULT NULL,
+ `STATUS` enum('SUCCESS','FAILED','PARTIAL') DEFAULT NULL,
+ `CREATED` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATED` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
+ `RUNTIME` varchar(8) NOT NULL DEFAULT '',
+ `RETRIES` int(11) NOT NULL DEFAULT '0',
+ `ERROR` varchar(256) DEFAULT NULL,
+ PRIMARY KEY (`REGION_ID`,`HOST`),
+ CONSTRAINT `fk_aic_sch_events` FOREIGN KEY (`REGION_ID`) REFERENCES `OPS_AIC_REGIONS` (`REGION_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `OPS_EXPORT_SCRIPT`
+--
+
+DROP TABLE IF EXISTS `OPS_EXPORT_SCRIPT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_EXPORT_SCRIPT` (
+ `ID` varchar(15) NOT NULL,
+ `SCRIPT` text NOT NULL,
+ `CREATEDON` datetime NOT NULL,
+ `CREATEDBY` varchar(10) NOT NULL,
+ PRIMARY KEY (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `OPS_HCAGGMETRICS`
+--
+
+DROP TABLE IF EXISTS `OPS_HCAGGMETRICS`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_HCAGGMETRICS` (
+ `ID` int(11) NOT NULL AUTO_INCREMENT,
+ `AGG_TIME` datetime DEFAULT NULL,
+ `CNT` int(11) DEFAULT NULL,
+ `HCCODE` varchar(45) DEFAULT NULL,
+ `SUCCESS` varchar(20) DEFAULT NULL,
+ `MIN_DUR` float DEFAULT NULL,
+ `AVG_DUR` float DEFAULT NULL,
+ `MAX_DUR` float DEFAULT NULL,
+ `STDDEV_DUR` float DEFAULT NULL,
+ `SDNOINSTANCE` varchar(45) DEFAULT NULL,
+ `HCNODETYPE` varchar(45) DEFAULT NULL,
+ `CLIENTNAME` varchar(45) DEFAULT NULL,
+ PRIMARY KEY (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `OPS_HCGROUPS`
+--
+
+DROP TABLE IF EXISTS `OPS_HCGROUPS`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_HCGROUPS` (
+ `HCGROUPID` int(11) NOT NULL AUTO_INCREMENT,
+ `HCCODE` varchar(45) NOT NULL,
+ `CHCCODE` varchar(45) NOT NULL,
+ `EXECPRIORITY` int(11) DEFAULT NULL,
+ `CREATEDBY` varchar(45) DEFAULT NULL,
+ `CREATEDON` datetime DEFAULT NULL,
+ `UPDATEDON` datetime DEFAULT NULL,
+ `UPDATEDBY` varchar(45) DEFAULT NULL,
+ PRIMARY KEY (`HCGROUPID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `OPS_HCRESPARCHIVE`
+--
+
+DROP TABLE IF EXISTS `OPS_HCRESPARCHIVE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_HCRESPARCHIVE` (
+ `HCRESPONSEID` int(11) NOT NULL AUTO_INCREMENT,
+ `HCTRANSID` varchar(128) DEFAULT NULL,
+ `REFHCTRANSID` varchar(128) DEFAULT NULL,
+ `SDNOTRANSID` varchar(255) DEFAULT NULL,
+ `HOSTIP` varchar(45) DEFAULT NULL,
+ `HCRESPONSESTATUS` varchar(20) DEFAULT NULL,
+ `HCRESPONSE` longtext,
+ `CREATEDON` datetime DEFAULT NULL,
+ `SDNOINSTANCE` varchar(45) NOT NULL,
+ `SDNOINSTANCESERVER` varchar(45) DEFAULT NULL,
+ `DMAAPSENT` varchar(1) NOT NULL DEFAULT 'N',
+ `NODETYPE` varchar(45) DEFAULT NULL,
+ `HCCODE` varchar(45) DEFAULT NULL,
+ `USERID` varchar(10) DEFAULT NULL,
+ `CLIENTNAME` varchar(45) DEFAULT NULL,
+ `HDSTARTTIME` datetime DEFAULT NULL,
+ `HDENDTIME` datetime DEFAULT NULL,
+ PRIMARY KEY (`HCRESPONSEID`),
+ KEY `hctransid_idx` (`HCTRANSID`),
+ KEY `sdnotransid_idx` (`SDNOTRANSID`),
+ KEY `clientname_idx` (`CLIENTNAME`),
+ KEY `nodetype_idx` (`NODETYPE`),
+ KEY `hccode_idx` (`HCCODE`),
+ KEY `hostip_idx` (`HOSTIP`),
+ KEY `createdon_idx` (`CREATEDON`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `OPS_HCRESPCACHE`
+--
+
+DROP TABLE IF EXISTS `OPS_HCRESPCACHE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_HCRESPCACHE` (
+ `HCRESPONSEID` int(11) NOT NULL AUTO_INCREMENT,
+ `SDNOTRANSID` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
+ `HOSTIP` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
+ `HCRESPONSESTATUS` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
+ `HCRESPONSE` longtext CHARACTER SET utf8,
+ `CREATEDON` datetime DEFAULT NULL,
+ `SDNOINSTANCE` varchar(45) CHARACTER SET utf8 NOT NULL,
+ `SDNOINSTANCESERVER` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
+ `DMAAPSENT` varchar(1) CHARACTER SET utf8 NOT NULL DEFAULT 'N',
+ `NODETYPE` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
+ `HCCODE` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
+ `USERID` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
+ `CLIENTNAME` varchar(45) CHARACTER SET utf8 DEFAULT NULL,
+ `HDSTARTTIME` datetime DEFAULT NULL,
+ `HDENDTIME` datetime DEFAULT NULL,
+ `CACHEEXPIRETIME` datetime DEFAULT NULL,
+ `HDEXPECTEDENDTIME` datetime DEFAULT NULL,
+ PRIMARY KEY (`HCRESPONSEID`),
+ KEY `cacheexpiretime_idx` (`CACHEEXPIRETIME`),
+ KEY `hdexpectedendtime_idx` (`HDEXPECTEDENDTIME`),
+ KEY `hdendtime_idx` (`HDENDTIME`),
+ KEY `hdstarttime_idx` (`HDSTARTTIME`)
+) ENGINE=InnoDB AUTO_INCREMENT=383 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Temporary table structure for view `OPS_HCRESPCACHEVIEW`
+--
+
+DROP TABLE IF EXISTS `OPS_HCRESPCACHEVIEW`;
+/*!50001 DROP VIEW IF EXISTS `OPS_HCRESPCACHEVIEW`*/;
+SET @saved_cs_client = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE VIEW `OPS_HCRESPCACHEVIEW` AS SELECT
+ 1 AS `ACTIVE`,
+ 1 AS `HCRESPONSEID`,
+ 1 AS `SDNOTRANSID`,
+ 1 AS `HOSTIP`,
+ 1 AS `HCRESPONSESTATUS`,
+ 1 AS `HCRESPONSE`,
+ 1 AS `CREATEDON`,
+ 1 AS `SDNOINSTANCE`,
+ 1 AS `SDNOINSTANCESERVER`,
+ 1 AS `DMAAPSENT`,
+ 1 AS `NODETYPE`,
+ 1 AS `HCCODE`,
+ 1 AS `USERID`,
+ 1 AS `CLIENTNAME`,
+ 1 AS `HDSTARTTIME`,
+ 1 AS `HDENDTIME`,
+ 1 AS `CACHEEXPIRETIME`,
+ 1 AS `HDEXPECTEDENDTIME`*/;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Table structure for table `OPS_HCRESPCOMPACT`
+--
+
+DROP TABLE IF EXISTS `OPS_HCRESPCOMPACT`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_HCRESPCOMPACT` (
+ `HCRESPONSEID` int(11) NOT NULL AUTO_INCREMENT,
+ `HCTRANSID` varchar(128) DEFAULT NULL,
+ `HOSTIP` varchar(45) DEFAULT NULL,
+ `HCRESPONSESTATUS` varchar(20) DEFAULT NULL,
+ `SDNOINSTANCE` varchar(45) NOT NULL,
+ `SDNOINSTANCESERVER` varchar(45) DEFAULT NULL,
+ `NODETYPE` varchar(45) DEFAULT NULL,
+ `HCCODE` varchar(45) DEFAULT NULL,
+ `USERID` varchar(10) DEFAULT NULL,
+ `CLIENTNAME` varchar(45) DEFAULT NULL,
+ `HDSTARTTIME` datetime DEFAULT NULL,
+ `HDENDTIME` datetime DEFAULT NULL,
+ PRIMARY KEY (`HCRESPONSEID`),
+ KEY `clientname_idx` (`CLIENTNAME`),
+ KEY `nodetype_idx` (`NODETYPE`),
+ KEY `hccode_idx` (`HCCODE`),
+ KEY `hcresponsestatus_idx` (`HCRESPONSESTATUS`),
+ KEY `hdstarttime_idx` (`HDSTARTTIME`),
+ KEY `hdendtime_idx` (`HDENDTIME`)
+) ENGINE=InnoDB AUTO_INCREMENT=15378 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `OPS_HCTYPES`
+--
+
+DROP TABLE IF EXISTS `OPS_HCTYPES`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_HCTYPES` (
+ `HCTYPEID` int(11) NOT NULL AUTO_INCREMENT,
+ `HCCODE` varchar(45) DEFAULT NULL,
+ `HCDESCR` varchar(45) DEFAULT NULL,
+ `HCNODETYPE` varchar(45) DEFAULT NULL,
+ `NODETYPEVERSION` varchar(15) DEFAULT NULL,
+ `STACKLEVEL` varchar(15) DEFAULT 'VM',
+ `ACTIVE` varchar(5) DEFAULT NULL,
+ `EXECPRIORITY` int(11) DEFAULT NULL,
+ `SBINTERFACE` varchar(45) DEFAULT 'ssh',
+ `SELECTABLE` varchar(2) DEFAULT 'Y',
+ `EXECTIME` int(11) DEFAULT '10' COMMENT 'expected execution time in secs',
+ `DEFAULT4NODETYPE` varchar(2) DEFAULT 'N' COMMENT 'default HD for this nodetype',
+ `CACHEDURATION` int(5) DEFAULT '2' COMMENT 'cache default is in minutes',
+ `LOGCMDRESP2DB` varchar(2) DEFAULT 'Y',
+ `VERSIONCHKHD` varchar(45) DEFAULT NULL,
+ `SBIALTSRVR` varchar(255) DEFAULT NULL,
+ `CREATEDON` datetime DEFAULT NULL,
+ `CREATEDBY` varchar(15) DEFAULT NULL,
+ `UPDATEDON` datetime DEFAULT NULL,
+ `UPDATEDBY` varchar(15) DEFAULT NULL,
+ PRIMARY KEY (`HCTYPEID`),
+ KEY `hcnodetype_idx` (`HCNODETYPE`),
+ KEY `hccode_idx` (`HCCODE`),
+ KEY `active_idx` (`ACTIVE`),
+ KEY `default4nodetype_idx` (`DEFAULT4NODETYPE`)
+) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Temporary table structure for view `OPS_HCVIEW`
+--
+
+DROP TABLE IF EXISTS `OPS_HCVIEW`;
+/*!50001 DROP VIEW IF EXISTS `OPS_HCVIEW`*/;
+SET @saved_cs_client = @@character_set_client;
+SET character_set_client = utf8;
+/*!50001 CREATE VIEW `OPS_HCVIEW` AS SELECT
+ 1 AS `HCCODE`,
+ 1 AS `CHCCODE`,
+ 1 AS `HCNODETYPE2`,
+ 1 AS `STACKLEVEL`,
+ 1 AS `SBINTERFACE`,
+ 1 AS `COMMAND`,
+ 1 AS `COMMANDDESC`,
+ 1 AS `EXITONFAIL`,
+ 1 AS `PATTERNMATCH`,
+ 1 AS `TIMEOUT`,
+ 1 AS `PROMPTCHECK`,
+ 1 AS `SENDCMDRESP`,
+ 1 AS `MANUALEFFORT`,
+ 1 AS `FLIPRXRSLT`,
+ 1 AS `EXECPRIORITY`,
+ 1 AS `VERSION`,
+ 1 AS `GPRIORITY`,
+ 1 AS `HCNODETYPE`*/;
+SET character_set_client = @saved_cs_client;
+
+--
+-- Table structure for table `OPS_HEALTHCHECK`
+--
+
+DROP TABLE IF EXISTS `OPS_HEALTHCHECK`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_HEALTHCHECK` (
+ `HCID` int(11) NOT NULL AUTO_INCREMENT,
+ `HCCODE` varchar(45) DEFAULT NULL,
+ `COMMAND` varchar(512) DEFAULT NULL,
+ `ACTIVE` varchar(1) DEFAULT 'N',
+ `PROMPTCHECK` varchar(32) DEFAULT NULL,
+ `EXECPRIORITY` int(11) DEFAULT NULL,
+ `TIMEOUT` int(11) DEFAULT NULL,
+ `PATTERNMATCH` varchar(512) DEFAULT NULL,
+ `FLIPRXRSLT` varchar(45) NOT NULL DEFAULT 'N',
+ `EXITONFAIL` varchar(6) DEFAULT 'N',
+ `SENDCMDRESP` varchar(5) DEFAULT 'Y',
+ `MANUALEFFORT` int(11) DEFAULT '2' COMMENT 'manual execution estimate in mins',
+ `COMMANDDESC` varchar(100) DEFAULT NULL,
+ `VERSION` varchar(45) DEFAULT 'none',
+ `CREATEDON` datetime DEFAULT NULL,
+ `CREATEDBY` varchar(15) DEFAULT NULL,
+ `UPDATEDON` datetime DEFAULT NULL,
+ `UPDATEDBY` varchar(15) DEFAULT NULL,
+ PRIMARY KEY (`HCID`),
+ KEY `hccode_idx` (`HCCODE`),
+ KEY `active_idx` (`ACTIVE`)
+) ENGINE=InnoDB AUTO_INCREMENT=445 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `OPS_HEALTHCHECKRESPONSE`
+--
+
+DROP TABLE IF EXISTS `OPS_HEALTHCHECKRESPONSE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_HEALTHCHECKRESPONSE` (
+ `HCRESPONSEID` int(11) NOT NULL AUTO_INCREMENT,
+ `HCTRANSID` varchar(128) DEFAULT NULL,
+ `REFHCTRANSID` varchar(128) DEFAULT NULL,
+ `SDNOTRANSID` varchar(255) DEFAULT NULL,
+ `HOSTIP` varchar(45) DEFAULT NULL,
+ `HCRESPONSESTATUS` varchar(20) DEFAULT NULL,
+ `HCRESPONSE` longtext,
+ `CREATEDON` datetime DEFAULT NULL,
+ `SDNOINSTANCE` varchar(45) NOT NULL,
+ `SDNOINSTANCESERVER` varchar(45) DEFAULT NULL,
+ `DMAAPSENT` varchar(1) NOT NULL DEFAULT 'N',
+ `NODETYPE` varchar(45) DEFAULT NULL,
+ `HCCODE` varchar(45) DEFAULT NULL,
+ `USERID` varchar(10) DEFAULT NULL,
+ `CLIENTNAME` varchar(45) DEFAULT NULL,
+ `HDSTARTTIME` datetime DEFAULT NULL,
+ `HDENDTIME` datetime DEFAULT NULL,
+ PRIMARY KEY (`HCRESPONSEID`),
+ KEY `hctransid_idx` (`HCTRANSID`),
+ KEY `sdnotransid_idx` (`SDNOTRANSID`),
+ KEY `clientname_idx` (`CLIENTNAME`),
+ KEY `nodetype_idx` (`NODETYPE`),
+ KEY `hccode_idx` (`HCCODE`),
+ KEY `hostip_idx` (`HOSTIP`),
+ KEY `createdon_idx` (`CREATEDON`)
+) ENGINE=InnoDB AUTO_INCREMENT=15380 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!50003 SET @saved_cs_client = @@character_set_client */ ;
+/*!50003 SET @saved_cs_results = @@character_set_results */ ;
+/*!50003 SET @saved_col_connection = @@collation_connection */ ;
+/*!50003 SET character_set_client = latin1 */ ;
+/*!50003 SET character_set_results = latin1 */ ;
+/*!50003 SET collation_connection = latin1_swedish_ci */ ;
+/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
+/*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
+DELIMITER ;;
+/*!50003 CREATE*/ /*!50017 DEFINER=`sdnctl`@`%`*/ /*!50003 TRIGGER `OPS_HEALTHCHECKRESPONSE_BEFORE_INSERT` BEFORE INSERT ON `OPS_HEALTHCHECKRESPONSE` FOR EACH ROW
+BEGIN
+ declare reftransid varchar(128);
+ declare ccount int;
+ declare ahostip varchar(45);
+ declare ahdcode varchar(45);
+ declare ahdendtime datetime;
+ declare ahdstarttime datetime;
+ declare acacheexpiretime datetime;
+ declare hdexectime INT DEFAULT 5;
+ declare hdexpectedendtime datetime;
+ declare nowtime datetime;
+ declare acacheduration INT;
+ declare maxtimeintbl INT DEFAULT 1800;
+
+ SET nowtime:=utc_timestamp();
+ SET ahdcode:=NEW.HCCODE;
+ SET ahostip:=NEW.HOSTIP;
+ SET reftransid:=trim(NEW.REFHCTRANSID);
+ SET new.CREATEDON = nowtime;
+ SET new.HDSTARTTIME = nowtime;
+
+ delete from OPS_HCRESPCACHE where HDENDTIME is null AND time_to_sec(timediff(nowtime, HDSTARTTIME))>maxtimeintbl;
+
+ IF (reftransid is null) then
+ select CACHEDURATION, EXECTIME into acacheduration, hdexectime from OPS_HCTYPES where HCCODE=ahdcode;
+ select count(*) into ccount from OPS_HCRESPCACHE where HCCODE=ahdcode and hostip=ahostip AND HDENDTIME is not null AND HCRESPONSEID>0;
+ if (ccount > 0) then
+ select HDSTARTTIME, HDENDTIME, CACHEEXPIRETIME into ahdstarttime, ahdendtime, acacheexpiretime from OPS_HCRESPCACHE where
+ HCCODE=ahdcode and hostip=ahostip AND HDENDTIME is not null AND HCRESPONSEID>0 order by HDENDTIME desc limit 1 ;
+ select time_to_sec(timediff(ahdendtime, ahdstarttime)) into hdexectime;
+ end if;
+
+ if (acacheduration > 0) then
+ set hdexpectedendtime = nowtime + INTERVAL hdexectime second;
+ insert into OPS_HCRESPCACHE(HCRESPONSEID,SDNOTRANSID,HOSTIP,HCRESPONSESTATUS,HCRESPONSE,CREATEDON,SDNOINSTANCE,SDNOINSTANCESERVER,DMAAPSENT,
+ NODETYPE,HCCODE,USERID,CLIENTNAME,HDSTARTTIME,HDENDTIME,CACHEEXPIRETIME,HDEXPECTEDENDTIME)
+ VALUES(NEW.HCRESPONSEID,NEW.SDNOTRANSID,NEW.HOSTIP,null,null,nowtime,NEW.SDNOINSTANCE,NEW.SDNOINSTANCESERVER,NEW.DMAAPSENT,
+ NEW.NODETYPE,NEW.HCCODE,NEW.USERID,NEW.CLIENTNAME,NEW.HDSTARTTIME,null,null,hdexpectedendtime);
+ end if;
+
+ END IF;
+END */;;
+DELIMITER ;
+/*!50003 SET sql_mode = @saved_sql_mode */ ;
+/*!50003 SET character_set_client = @saved_cs_client */ ;
+/*!50003 SET character_set_results = @saved_cs_results */ ;
+/*!50003 SET collation_connection = @saved_col_connection */ ;
+/*!50003 SET @saved_cs_client = @@character_set_client */ ;
+/*!50003 SET @saved_cs_results = @@character_set_results */ ;
+/*!50003 SET @saved_col_connection = @@collation_connection */ ;
+/*!50003 SET character_set_client = latin1 */ ;
+/*!50003 SET character_set_results = latin1 */ ;
+/*!50003 SET collation_connection = latin1_swedish_ci */ ;
+/*!50003 SET @saved_sql_mode = @@sql_mode */ ;
+/*!50003 SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ;
+DELIMITER ;;
+/*!50003 CREATE*/ /*!50017 DEFINER=`sdnctl`@`%`*/ /*!50003 TRIGGER `sdnctl`.`OPS_HEALTHCHECKRESPONSE_BEFORE_UPDATE` BEFORE UPDATE ON `OPS_HEALTHCHECKRESPONSE` FOR EACH ROW
+BEGIN
+ Declare aduration INT;
+ declare reftransid varchar(128);
+ DECLARE cachetime datetime;
+ declare ahostip varchar(45);
+ declare ahdcode varchar(45);
+ declare ahdendtime datetime;
+
+ SET ahdcode:=NEW.HCCODE;
+ SET ahostip:=NEW.HOSTIP;
+ SET ahdendtime:=NEW.HDENDTIME;
+ SET reftransid:=trim(NEW.REFHCTRANSID);
+
+ if (NEW.DMAAPSENT in ('U','Y')) then
+ update OPS_HCRESPCACHE
+ set DMAAPSENT=NEW.DMAAPSENT where OLD.SDNOTRANSID=NEW.SDNOTRANSID and OLD.CREATEDON=NEW.CREATEDON;
+ ELSEIF (reftransid is null and OLD.HCRESPONSESTATUS is null) then
+ select cacheduration into aduration from OPS_HCTYPES where HCCODE=ahdcode;
+ if (aduration > 0) then
+ select ahdendtime + INTERVAL aduration MINUTE into cachetime from OPS_HCTYPES where HCCODE=ahdcode;
+ update OPS_HCRESPCACHE
+ set HCRESPONSESTATUS=NEW.HCRESPONSESTATUS,HCRESPONSE=NEW.HCRESPONSE,HDENDTIME=NEW.HDENDTIME,CACHEEXPIRETIME=cachetime,HDEXPECTEDENDTIME=null
+ where SDNOTRANSID=NEW.SDNOTRANSID and CREATEDON=NEW.CREATEDON;
+ insert into OPS_HCRESPCOMPACT (HCRESPONSEID, HCTRANSID, HOSTIP, HCRESPONSESTATUS, SDNOINSTANCE, SDNOINSTANCESERVER, NODETYPE, HCCODE, USERID, CLIENTNAME, HDSTARTTIME, HDENDTIME)
+ values(NEW.HCRESPONSEID, NEW.HCTRANSID, NEW.HOSTIP, NEW.HCRESPONSESTATUS, NEW.SDNOINSTANCE, NEW.SDNOINSTANCESERVER, NEW.NODETYPE, NEW.HCCODE, NEW.USERID, NEW.CLIENTNAME, NEW.HDSTARTTIME, NEW.HDENDTIME);
+ end if;
+ END IF;
+END */;;
+DELIMITER ;
+/*!50003 SET sql_mode = @saved_sql_mode */ ;
+/*!50003 SET character_set_client = @saved_cs_client */ ;
+/*!50003 SET character_set_results = @saved_cs_results */ ;
+/*!50003 SET collation_connection = @saved_col_connection */ ;
+
+--
+-- Table structure for table `OPS_MAPNODETYPES`
+--
+
+DROP TABLE IF EXISTS `OPS_MAPNODETYPES`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_MAPNODETYPES` (
+ `ID` int(11) NOT NULL AUTO_INCREMENT,
+ `INNODETYPE` varchar(45) DEFAULT NULL COMMENT 'nodetype value in incoming API',
+ `TBLNODETYPE` varchar(45) DEFAULT NULL COMMENT 'nodetype value as stored in db',
+ PRIMARY KEY (`ID`),
+ KEY `tablnodetype_idx` (`TBLNODETYPE`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `OPS_NODEINFO`
+--
+
+DROP TABLE IF EXISTS `OPS_NODEINFO`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_NODEINFO` (
+ `NODEID` int(11) NOT NULL AUTO_INCREMENT,
+ `NODETYPE` varchar(255) DEFAULT NULL,
+ `HOSTIP` varchar(45) DEFAULT NULL,
+ `STACKLEVEL` varchar(15) DEFAULT 'VM',
+ `HOSTUSER` varchar(45) DEFAULT NULL,
+ `HOSTPASSWORD` varchar(45) DEFAULT NULL,
+ `PROMPTCMD` varchar(256) DEFAULT NULL,
+ `PREPROMPTSTRS` varchar(45) DEFAULT NULL COMMENT 'Strings to send before login prompt',
+ `LABNODETYPE` varchar(256) DEFAULT NULL,
+ `MULTIVERSIONS` varchar(2) DEFAULT 'N',
+ `JUMPSERVERIP` varchar(45) DEFAULT NULL,
+ `JUMPSERVERUSER` varchar(45) DEFAULT NULL,
+ `JUMPSERVERPASSWORD` varchar(45) DEFAULT NULL,
+ `VSERVERID` varchar(128) DEFAULT NULL,
+ `SELFSERVLINK` varchar(1024) DEFAULT NULL,
+ `TENANTID` varchar(128) DEFAULT NULL,
+ `IDENTITYURL` varchar(1024) DEFAULT NULL,
+ PRIMARY KEY (`NODEID`),
+ KEY `hostname_idx` (`NODETYPE`)
+) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `OPS_NODETYPE2SDNO`
+--
+
+DROP TABLE IF EXISTS `OPS_NODETYPE2SDNO`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_NODETYPE2SDNO` (
+ `VNFTYPEID` int(11) NOT NULL AUTO_INCREMENT,
+ `VNFTYPECODE` varchar(45) DEFAULT NULL,
+ `VNFTYPENAME` varchar(256) DEFAULT NULL,
+ `VNFCLLI` varchar(20) DEFAULT NULL,
+ `DEFAULT_4_UNK_CLLI` varchar(2) DEFAULT NULL,
+ `SDNOINSTANCE` varchar(45) NOT NULL,
+ PRIMARY KEY (`VNFTYPEID`)
+) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `OPS_NODE_PROPERTIES`
+--
+
+DROP TABLE IF EXISTS `OPS_NODE_PROPERTIES`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_NODE_PROPERTIES` (
+ `NODETYPE` varchar(64) NOT NULL,
+ `PROPERTY` varchar(64) NOT NULL,
+ `VALUE` varchar(128) NOT NULL,
+ `CREATED` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `UPDATED` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
+ PRIMARY KEY (`NODETYPE`,`PROPERTY`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `OPS_SDNOINFO`
+--
+
+DROP TABLE IF EXISTS `OPS_SDNOINFO`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_SDNOINFO` (
+ `SDNOID` int(11) NOT NULL AUTO_INCREMENT,
+ `SDNOINSTANCE` varchar(45) DEFAULT NULL,
+ `URI` varchar(1000) NOT NULL,
+ PRIMARY KEY (`SDNOID`),
+ UNIQUE KEY `SDNOINSTANCE_UNIQUE` (`SDNOINSTANCE`)
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `OPS_SQLMGR`
+--
+
+DROP TABLE IF EXISTS `OPS_SQLMGR`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_SQLMGR` (
+ `SQLID` int(11) NOT NULL AUTO_INCREMENT,
+ `SQLTEXT` longtext,
+ `SQLSTATUS` int(11) DEFAULT '0',
+ `COMMENTS` varchar(255) DEFAULT NULL,
+ `CREATEDBY` varchar(15) DEFAULT NULL,
+ `CREATEDON` datetime DEFAULT NULL,
+ PRIMARY KEY (`SQLID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `OPS_TRUSTED_PARTNER`
+--
+
+DROP TABLE IF EXISTS `OPS_TRUSTED_PARTNER`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `OPS_TRUSTED_PARTNER` (
+ `PARTNERID` int(11) NOT NULL AUTO_INCREMENT,
+ `PARTNER_NAME` varchar(256) NOT NULL,
+ `PARTNER_PUBLIC_KEY` varchar(1024) DEFAULT NULL,
+ PRIMARY KEY (`PARTNERID`)
+) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
--
-- Table structure for table `PREPARE_FILE_RELATIONSHIP`
--
KEY `ie2_prepare_file_relationship` (`ASDC_ARTIFACTS_ID`),
CONSTRAINT `prepare_file_relationship_ibfk_2` FOREIGN KEY (`ASDC_ARTIFACTS_ID`) REFERENCES `ASDC_ARTIFACTS` (`ASDC_ARTIFACTS_ID`) ON DELETE NO ACTION ON UPDATE CASCADE,
CONSTRAINT `prepare_file_replationship_ibfk_1` FOREIGN KEY (`CONFIG_FILE_ID`) REFERENCES `CONFIGFILES` (`CONFIG_FILE_ID`) ON DELETE NO ACTION ON UPDATE CASCADE
-) ENGINE=InnoDB AUTO_INCREMENT=558 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=8607 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
`GET_RUNNING_CONFIG` varchar(50) DEFAULT NULL,
PRIMARY KEY (`PROCESS_FLOW_REFERENCE_ID`),
UNIQUE KEY `PROCESS_FLOW_REFERENCE_ID` (`PROCESS_FLOW_REFERENCE_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
CREATE TABLE `PROTOCOL_REFERENCE` (
`PROTOCOL_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
`ACTION` varchar(50) NOT NULL,
- `VNF_TYPE` varchar(50) DEFAULT NULL,
+ `VNF_TYPE` varchar(150) DEFAULT NULL,
`PROTOCOL` varchar(50) DEFAULT NULL,
`UPDATED_DATE` datetime DEFAULT NULL,
`TEMPLATE` varchar(45) DEFAULT NULL,
`ACTION_LEVEL` varchar(45) DEFAULT NULL,
PRIMARY KEY (`PROTOCOL_REFERENCE_ID`),
UNIQUE KEY ` PROTOCOL_REFERENCE_ID` (`PROTOCOL_REFERENCE_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
`REQUEST_ID` varchar(50) NOT NULL,
`ACTION` varchar(50) NOT NULL,
`ACTION_LEVEL` varchar(50) DEFAULT NULL,
- `VNF_TYPE` varchar(50) DEFAULT NULL,
+ `VNF_TYPE` varchar(150) DEFAULT NULL,
`CATEGORY` varchar(50) NOT NULL,
`ARTIFACT_CONTENT` longtext,
`UPDATED_DATE` datetime DEFAULT NULL,
PRIMARY KEY (`REQUEST_ARTIFACTS_ID`),
UNIQUE KEY `REQUEST_ARTIFACTS_ID` (`REQUEST_ARTIFACTS_ID`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=10273 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
`mode` varchar(5) NOT NULL,
`active` varchar(1) NOT NULL,
`graph` longblob,
+ `md5sum` varchar(32) NOT NULL DEFAULT '',
PRIMARY KEY (`module`,`rpc`,`version`,`mode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
+--
+-- Table structure for table `TRANSACTIONS`
+--
+
+DROP TABLE IF EXISTS `TRANSACTIONS`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `TRANSACTIONS` (
+ `TRANSACTION_ID` varchar(75) NOT NULL,
+ `ORIGIN_TIMESTAMP` datetime(3) NOT NULL,
+ `REQUEST_ID` varchar(256) NOT NULL,
+ `SUBREQUEST_ID` varchar(256) DEFAULT NULL,
+ `ORIGINATOR_ID` varchar(256) DEFAULT NULL,
+ `START_TIME` datetime(3) NOT NULL,
+ `END_TIME` datetime(3) DEFAULT NULL,
+ `TARGET_ID` varchar(256) DEFAULT NULL,
+ `TARGET_TYPE` varchar(256) DEFAULT NULL,
+ `OPERATION` varchar(256) NOT NULL,
+ `RESULT_CODE` int(11) DEFAULT NULL,
+ `DESCRIPTION` text,
+ `STATE` varchar(50) NOT NULL,
+ `SERVICE_INSTANCE_ID` varchar(256) DEFAULT NULL,
+ `VNFC_NAME` varchar(256) DEFAULT NULL,
+ `VSERVER_ID` varchar(256) DEFAULT NULL,
+ `VF_MODULE_ID` varchar(256) DEFAULT NULL,
+ `MODE` varchar(50) NOT NULL,
+ PRIMARY KEY (`TRANSACTION_ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
--
-- Table structure for table `UPLOAD_CONFIG`
--
`VNF_ID` varchar(50) DEFAULT NULL,
`VNF_NAME` varchar(50) DEFAULT NULL,
`VM_NAME` varchar(50) DEFAULT NULL,
- `VNF_TYPE` varchar(50) DEFAULT NULL,
+ `VNF_TYPE` varchar(150) DEFAULT NULL,
`VNFC_TYPE` varchar(50) DEFAULT NULL,
`HOST_IP_ADDRESS` varchar(50) DEFAULT NULL,
`CONFIG_INDICATOR` varchar(25) DEFAULT NULL,
`PENDING_DELETE` varchar(1) DEFAULT NULL,
`CONTENT` longtext,
PRIMARY KEY (`UPLOAD_CONFIG_ID`),
- UNIQUE KEY `UPLOAD_CONFIG_ID` (`UPLOAD_CONFIG_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=224 DEFAULT CHARSET=latin1;
+ UNIQUE KEY `UPLOAD_CONFIG_ID` (`UPLOAD_CONFIG_ID`),
+ KEY `VNF_ID` (`VNF_ID`)
+) ENGINE=InnoDB AUTO_INCREMENT=1656 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `VNFC_DG_MAPPING` (
+ `VNFC_DG_MAPPING_ID` int(11) NOT NULL AUTO_INCREMENT,
`ACTION` varchar(50) DEFAULT NULL,
`API_VERSION` varchar(10) DEFAULT NULL,
- `VNF_TYPE` varchar(50) DEFAULT NULL,
+ `VNF_TYPE` varchar(150) DEFAULT NULL,
`VNFC_TYPE` 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`,`VNFC_TYPE`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+ PRIMARY KEY (`VNFC_DG_MAPPING_ID`)
+) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
CREATE TABLE `VNFC_REFERENCE` (
`VNFC_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
`ACTION` varchar(50) NOT NULL,
- `VNF_TYPE` varchar(50) NOT NULL,
+ `VNF_TYPE` varchar(150) DEFAULT NULL,
`VM_INSTANCE` int(11) NOT NULL,
`VNFC_INSTANCE` int(11) NOT NULL,
`VNFC_TYPE` varchar(50) NOT NULL,
`VNFC_FUNCTION_CODE` varchar(50) NOT NULL,
`IPADDRESS_V4_OAM_VIP` varchar(50) DEFAULT NULL,
- `TEMPLATE_ID` varchar(100) DEFAULT NULL,
`GROUP_NOTATION_TYPE` varchar(50) DEFAULT NULL,
`GROUP_NOTATION_VALUE` varchar(50) DEFAULT NULL,
+ `TEMPLATE_ID` varchar(100) DEFAULT NULL,
PRIMARY KEY (`VNFC_REFERENCE_ID`),
UNIQUE KEY ` VNFC_REFERENCE_ID` (`VNFC_REFERENCE_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=688 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
/*!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;
+ `VNF_DG_MAPPING_ID` int(11) NOT NULL AUTO_INCREMENT,
+ `ACTION` varchar(50) NOT NULL,
+ `API_VERSION` varchar(50) DEFAULT NULL,
+ `VNF_TYPE` varchar(150) 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,
+ PRIMARY KEY (`VNF_DG_MAPPING_ID`)
+) ENGINE=InnoDB AUTO_INCREMENT=576 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `VNF_LOCK_MANAGEMENT` (
`RESOURCE_ID` varchar(50) NOT NULL,
- `OWNER_ID` varchar(50) DEFAULT NULL,
+ `OWNER_ID` varchar(255) DEFAULT NULL,
`UPDATED` bigint(20) unsigned NOT NULL,
`TIMEOUT` int(10) unsigned NOT NULL,
`VER` int(10) unsigned NOT NULL DEFAULT '1',
`VER` int(10) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`VNF_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+SET FOREIGN_KEY_CHECKS = 1;
+--
+-- Current Database: `sdnctl`
+--
+
+USE `sdnctl`;
+
+--
+-- Final view structure for view `DEVICE_CONFIGURATION`
+--
+
+/*!50001 DROP VIEW IF EXISTS `DEVICE_CONFIGURATION`*/;
+/*!50001 SET @saved_cs_client = @@character_set_client */;
+/*!50001 SET @saved_cs_results = @@character_set_results */;
+/*!50001 SET @saved_col_connection = @@collation_connection */;
+/*!50001 SET character_set_client = utf8 */;
+/*!50001 SET character_set_results = utf8 */;
+/*!50001 SET collation_connection = utf8_general_ci */;
+/*!50001 CREATE ALGORITHM=UNDEFINED */
+/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
+/*!50001 VIEW `DEVICE_CONFIGURATION` AS select 1 AS `UPLOAD_CONFIG_ID`,1 AS `REQUEST_ID`,1 AS `ORIGINATOR_ID`,1 AS `SERVICE_DESCRIPTION`,1 AS `ACTION`,1 AS `UPLOAD_DATE`,1 AS `VNF_ID`,1 AS `VNF_NAME`,1 AS `VM_NAME`,1 AS `VNF_TYPE`,1 AS `VNFC_TYPE`,1 AS `HOST_IP_ADDRESS`,1 AS `CONFIG_INDICATOR`,1 AS `PENDING_DELETE`,1 AS `CONTENT` */;
+/*!50001 SET character_set_client = @saved_cs_client */;
+/*!50001 SET character_set_results = @saved_cs_results */;
+/*!50001 SET collation_connection = @saved_col_connection */;
+
+--
+-- Final view structure for view `OPS_HCRESPCACHEVIEW`
+--
+
+/*!50001 DROP VIEW IF EXISTS `OPS_HCRESPCACHEVIEW`*/;
+/*!50001 SET @saved_cs_client = @@character_set_client */;
+/*!50001 SET @saved_cs_results = @@character_set_results */;
+/*!50001 SET @saved_col_connection = @@collation_connection */;
+/*!50001 SET character_set_client = utf8 */;
+/*!50001 SET character_set_results = utf8 */;
+/*!50001 SET collation_connection = utf8_general_ci */;
+/*!50001 CREATE ALGORITHM=UNDEFINED */
+/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
+/*!50001 VIEW `OPS_HCRESPCACHEVIEW` AS select 1 AS `ACTIVE`,1 AS `HCRESPONSEID`,1 AS `SDNOTRANSID`,1 AS `HOSTIP`,1 AS `HCRESPONSESTATUS`,1 AS `HCRESPONSE`,1 AS `CREATEDON`,1 AS `SDNOINSTANCE`,1 AS `SDNOINSTANCESERVER`,1 AS `DMAAPSENT`,1 AS `NODETYPE`,1 AS `HCCODE`,1 AS `USERID`,1 AS `CLIENTNAME`,1 AS `HDSTARTTIME`,1 AS `HDENDTIME`,1 AS `CACHEEXPIRETIME`,1 AS `HDEXPECTEDENDTIME` */;
+/*!50001 SET character_set_client = @saved_cs_client */;
+/*!50001 SET character_set_results = @saved_cs_results */;
+/*!50001 SET collation_connection = @saved_col_connection */;
+
+--
+-- Final view structure for view `OPS_HCVIEW`
+--
+
+/*!50001 DROP VIEW IF EXISTS `OPS_HCVIEW`*/;
+/*!50001 SET @saved_cs_client = @@character_set_client */;
+/*!50001 SET @saved_cs_results = @@character_set_results */;
+/*!50001 SET @saved_col_connection = @@collation_connection */;
+/*!50001 SET character_set_client = utf8 */;
+/*!50001 SET character_set_results = utf8 */;
+/*!50001 SET collation_connection = utf8_general_ci */;
+/*!50001 CREATE ALGORITHM=UNDEFINED */
+/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
+/*!50001 VIEW `OPS_HCVIEW` AS select 1 AS `HCCODE`,1 AS `CHCCODE`,1 AS `HCNODETYPE2`,1 AS `STACKLEVEL`,1 AS `SBINTERFACE`,1 AS `COMMAND`,1 AS `COMMANDDESC`,1 AS `EXITONFAIL`,1 AS `PATTERNMATCH`,1 AS `TIMEOUT`,1 AS `PROMPTCHECK`,1 AS `SENDCMDRESP`,1 AS `MANUALEFFORT`,1 AS `FLIPRXRSLT`,1 AS `EXECPRIORITY`,1 AS `VERSION`,1 AS `GPRIORITY`,1 AS `HCNODETYPE` */;
+/*!50001 SET character_set_client = @saved_cs_client */;
+/*!50001 SET character_set_results = @saved_cs_results */;
+/*!50001 SET collation_connection = @saved_col_connection */;
+
-SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;