-- ============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 */;

USE `sdnctl`;

--
-- Table structure for table `ACTION_LEVEL_REFERENCE`
--

DROP TABLE IF EXISTS `ACTION_LEVEL_REFERENCE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ACTION_LEVEL_REFERENCE` (
  `ACTION_LEVEL_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ACTION_IDENTIFIER` varchar(50) NOT NULL,
  `ACTION_LEVEL` varchar(50) NOT NULL,
  UNIQUE KEY `ACTION_LEVEL_REFERENCE_ID` (`ACTION_LEVEL_REFERENCE_ID`)
) 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`
--

DROP TABLE IF EXISTS `ASDC_ARTIFACTS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ASDC_ARTIFACTS` (
  `ASDC_ARTIFACTS_ID` int(11) NOT NULL AUTO_INCREMENT,
  `SERVICE_UUID` varchar(50) DEFAULT NULL,
  `DISTRIBUTION_ID` varchar(50) DEFAULT NULL,
  `SERVICE_NAME` varchar(255) DEFAULT NULL,
  `SERVICE_DESCRIPTION` varchar(255) DEFAULT NULL,
  `RESOURCE_UUID` varchar(255) DEFAULT NULL,
  `RESOURCE_INSTANCE_NAME` varchar(255) DEFAULT NULL,
  `RESOURCE_NAME` varchar(255) DEFAULT NULL,
  `RESOURCE_VERSION` varchar(50) DEFAULT NULL,
  `RESOURCE_TYPE` varchar(50) DEFAULT NULL,
  `ARTIFACT_UUID` varchar(50) DEFAULT NULL,
  `ARTIFACT_TYPE` varchar(50) DEFAULT NULL,
  `ARTIFACT_VERSION` varchar(25) DEFAULT NULL,
  `ARTIFACT_DESCRIPTION` varchar(255) DEFAULT NULL,
  `INTERNAL_VERSION` int(11) DEFAULT NULL,
  `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ARTIFACT_NAME` varchar(255) DEFAULT NULL,
  `ARTIFACT_CONTENT` longtext,
  PRIMARY KEY (`ASDC_ARTIFACTS_ID`),
  UNIQUE KEY `ASDC_ARTIFACTS_ID` (`ASDC_ARTIFACTS_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5093 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `ASDC_REFERENCE`
--

DROP TABLE IF EXISTS `ASDC_REFERENCE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ASDC_REFERENCE` (
  `ASDC_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `VNF_TYPE` varchar(150) DEFAULT NULL,
  `VNFC_TYPE` varchar(50) DEFAULT NULL,
  `FILE_CATEGORY` varchar(50) DEFAULT NULL,
  `ACTION` varchar(50) DEFAULT NULL,
  `ARTIFACT_TYPE` 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=352 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CONFIGFILES`
--

DROP TABLE IF EXISTS `CONFIGFILES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CONFIGFILES` (
  `CONFIG_FILE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `EXTERNAL_VERSION` varchar(50) DEFAULT NULL,
  `DATA_SOURCE` varchar(25) DEFAULT NULL,
  `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `SERVICE_INSTANCE_ID` 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,
  `FILE_CONTENT` longtext,
  `ACTION` varchar(50) DEFAULT NULL,
  `VNF_ID` varchar(50) DEFAULT NULL,
  `VM_NAME` varchar(50) 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=5751 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CONFIGURE_ACTION_DG`
--

DROP TABLE IF EXISTS `CONFIGURE_ACTION_DG`;
/*!40101 SET @saved_cs_client     = @@character_set_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(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=65 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CONFIG_FILE_REFERENCE`
--

DROP TABLE IF EXISTS `CONFIG_FILE_REFERENCE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CONFIG_FILE_REFERENCE` (
  `CONFIG_FILE_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `SITE_LOCATION` 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,
  `SOURCE_FILE_PATH` varchar(255) DEFAULT NULL,
  `TARGET_FILE_PATH` varchar(255) DEFAULT NULL,
  `NAME` varchar(50) 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=16 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `CONFIG_TRANSACTION_LOG`
--

DROP TABLE IF EXISTS `CONFIG_TRANSACTION_LOG`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `CONFIG_TRANSACTION_LOG` (
  `CONFIG_TRANSACTION_LOG_ID` int(11) NOT NULL AUTO_INCREMENT,
  `REQUEST_ID` varchar(50) DEFAULT NULL,
  `MESSAGE_TYPE` varchar(50) DEFAULT NULL,
  `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `MESSAGE` longtext,
  PRIMARY KEY (`CONFIG_TRANSACTION_LOG_ID`),
  UNIQUE KEY ` CONFIG_TRANSACTION_LOG_ID` (`CONFIG_TRANSACTION_LOG_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=40247 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DEVICE_AUTHENTICATION`
--

DROP TABLE IF EXISTS `DEVICE_AUTHENTICATION`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DEVICE_AUTHENTICATION` (
  `DEVICE_AUTHENTICATION_ID` int(11) NOT NULL AUTO_INCREMENT,
  `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 `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 table structure for view `DEVICE_CONFIGURATION`
--

DROP TABLE IF EXISTS `DEVICE_CONFIGURATION`;
/*!50001 DROP VIEW IF EXISTS `DEVICE_CONFIGURATION`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE 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`*/;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `DEVICE_INTERFACE_LOG`
--

DROP TABLE IF EXISTS `DEVICE_INTERFACE_LOG`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DEVICE_INTERFACE_LOG` (
  `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 DEFAULT CURRENT_TIMESTAMP,
  `LOG` longtext,
  PRIMARY KEY (`DEVICE_INTERFACE_LOG_ID`),
  UNIQUE KEY `DEVICE_INTERFACE_LOG_ID` (`DEVICE_INTERFACE_LOG_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DEVICE_INTERFACE_PROTOCOL`
--

DROP TABLE IF EXISTS `DEVICE_INTERFACE_PROTOCOL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DEVICE_INTERFACE_PROTOCOL` (
  `DEVICE_INTERFACE_PROTOCOL_ID` int(11) NOT NULL AUTO_INCREMENT,
  `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`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DOWNLOAD_CONFIG_TEMPLATE`
--

DROP TABLE IF EXISTS `DOWNLOAD_CONFIG_TEMPLATE`;
/*!40101 SET @saved_cs_client     = @@character_set_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(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=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DOWNLOAD_DG_REFERENCE`
--

DROP TABLE IF EXISTS `DOWNLOAD_DG_REFERENCE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DOWNLOAD_DG_REFERENCE` (
  `DOWNLOAD_DG_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `PROTOCOL` varchar(50) NOT NULL,
  `DOWNLOAD_CONFIG_DG` varchar(50) NOT NULL,
  PRIMARY KEY (`DOWNLOAD_DG_REFERENCE_ID`),
  UNIQUE KEY ` DOWNLOAD_DG_REFERENCE_ID` (`DOWNLOAD_DG_REFERENCE_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DT_ACTION_STATUS`
--

DROP TABLE IF EXISTS `DT_ACTION_STATUS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DT_ACTION_STATUS` (
  `DT_ACTION_STATUS_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ACTION` varchar(50) NOT NULL,
  `VNF_TYPE` varchar(150) DEFAULT NULL,
  `VNFC_TYPE` varchar(50) DEFAULT NULL,
  `USER` varchar(50) NOT NULL,
  `TECHNOLOGY` varchar(50) DEFAULT NULL,
  `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `STATUS` varchar(50) NOT NULL,
  PRIMARY KEY (`DT_ACTION_STATUS_ID`),
  UNIQUE KEY `DT_ACTION_STATUS_ID` (`DT_ACTION_STATUS_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DT_ARTIFACT_REFERENCE`
--

DROP TABLE IF EXISTS `DT_ARTIFACT_REFERENCE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DT_ARTIFACT_REFERENCE` (
  `DT_ARTIFACT_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `PROTOCOL` varchar(50) DEFAULT NULL,
  `ACTION` varchar(50) DEFAULT NULL,
  `ARTIFACT_TYPE` varchar(50) NOT NULL,
  `ARTIFACT_PRIORITY` int(11) NOT NULL,
  PRIMARY KEY (`DT_ARTIFACT_REFERENCE_ID`),
  UNIQUE KEY `DT_ARTIFACT_REFERENCE_ID` (`DT_ARTIFACT_REFERENCE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DT_ARTIFACT_TRACKING`
--

DROP TABLE IF EXISTS `DT_ARTIFACT_TRACKING`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DT_ARTIFACT_TRACKING` (
  `DT_ARTIFACT_TRACKING_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ASDC_ARTIFACTS_ID` int(11) DEFAULT NULL,
  `ASDC_REFERENCE_ID` int(11) DEFAULT NULL,
  `USER` varchar(50) NOT NULL,
  `TECHNOLOGY` varchar(50) DEFAULT NULL,
  `CREATION_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ARTIFACT_STATUS` varchar(50) NOT NULL,
  `IN_CART` varchar(50) DEFAULT NULL,
  `PROTOCOL` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`DT_ARTIFACT_TRACKING_ID`),
  UNIQUE KEY `DT_ARTIFACT_TRACKING_ID` (`DT_ARTIFACT_TRACKING_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DT_GUI_REFERENCE`
--

DROP TABLE IF EXISTS `DT_GUI_REFERENCE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DT_GUI_REFERENCE` (
  `DT_GUI_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `GUI_NAME` varchar(50) NOT NULL,
  `FIELD_NAME` varchar(50) NOT NULL,
  `VALUE` varchar(50) NOT NULL,
  `USER` varchar(50) NOT NULL,
  `UPDATED_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `PROTOCOL` varchar(50) DEFAULT NULL,
  `ACTION` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`DT_GUI_REFERENCE_ID`),
  UNIQUE KEY `DT_GUI_REFERENCE_ID` (`DT_GUI_REFERENCE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DT_STATUS_RELATIONSHIP`
--

DROP TABLE IF EXISTS `DT_STATUS_RELATIONSHIP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `DT_STATUS_RELATIONSHIP` (
  `DT_STATUS_RELATIONSHIP_ID` int(11) NOT NULL AUTO_INCREMENT,
  `DT_ARTIFACT_TRACKING_ID` int(11) NOT NULL,
  `DT_ACTION_STATUS_ID` int(11) NOT NULL,
  PRIMARY KEY (`DT_STATUS_RELATIONSHIP_ID`),
  UNIQUE KEY `DT_STATUS_RELATIONSHIP_ID` (`DT_STATUS_RELATIONSHIP_ID`),
  KEY `IE_DT_STATUS_RELATIONSHIP` (`DT_ARTIFACT_TRACKING_ID`),
  KEY `IE2_DT_STATUS_RELATIONSHIP` (`DT_ACTION_STATUS_ID`),
  CONSTRAINT `DT_STATUS_RELATIONSHIP_IBFK_1` FOREIGN KEY (`DT_ARTIFACT_TRACKING_ID`) REFERENCES `DT_ARTIFACT_TRACKING` (`DT_ARTIFACT_TRACKING_ID`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `DT_STATUS_RELATIONSHIP_IBFK_2` FOREIGN KEY (`DT_ACTION_STATUS_ID`) REFERENCES `DT_ACTION_STATUS` (`DT_ACTION_STATUS_ID`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `DT_USER_PERMISSIONS`
--

DROP TABLE IF EXISTS `DT_USER_PERMISSIONS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE sdnctl.`DT_USER_PERMISSIONS` (
   `DT_USER_PERMISSION_ID` int(11) NOT NULL AUTO_INCREMENT,
   `VNF_TYPE` varchar(255) NOT NULL,
   `USER_ID` varchar(255) DEFAULT NULL,
   `PERMISSION` varchar(255) DEFAULT NULL,
   `DATE_MODIFIED` datetime(3) DEFAULT NULL,
   `MODIFIER` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`DT_USER_PERMISSION_ID`),
    UNIQUE KEY `VNF_USER_UNIQ` (`VNF_TYPE`,`USER_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=33 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 `GET_CONFIG_TEMPLATE`
--

DROP TABLE IF EXISTS `GET_CONFIG_TEMPLATE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `GET_CONFIG_TEMPLATE` (
  `GET_CONFIG_TEMPLATE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  `TEMPLATE` longtext,
  PRIMARY KEY (`GET_CONFIG_TEMPLATE_ID`),
  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=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `MULTISTEP_FLOW_REFERENCE`
--

DROP TABLE IF EXISTS `MULTISTEP_FLOW_REFERENCE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `MULTISTEP_FLOW_REFERENCE` (
  `MULTISTEP_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ACTION` varchar(50) NOT NULL,
  `ACTION_LEVEL` 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,
  `EXECUTION_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 AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `NODE_TYPES`
--

DROP TABLE IF EXISTS `NODE_TYPES`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `NODE_TYPES` (
  `nodetype` varchar(80) NOT NULL,
  PRIMARY KEY (`nodetype`)
) 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`
--

DROP TABLE IF EXISTS `PREPARE_FILE_RELATIONSHIP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `PREPARE_FILE_RELATIONSHIP` (
  `PREPARE_FILE_RELATIONSHIP_ID` int(11) NOT NULL AUTO_INCREMENT,
  `SERVICE_INSTANCE_ID` varchar(50) DEFAULT NULL,
  `REQUEST_ID` varchar(255) DEFAULT NULL,
  `CONFIG_FILE_ID` int(11) DEFAULT NULL,
  `ASDC_ARTIFACTS_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`PREPARE_FILE_RELATIONSHIP_ID`),
  UNIQUE KEY `PREPARE_FILE_RELATIONSHIP_ID` (`PREPARE_FILE_RELATIONSHIP_ID`),
  KEY `ie_prepare_file_relationship` (`CONFIG_FILE_ID`),
  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=8607 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `PROCESS_FLOW_REFERENCE`
--

DROP TABLE IF EXISTS `PROCESS_FLOW_REFERENCE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `PROCESS_FLOW_REFERENCE` (
  `PROCESS_FLOW_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ACTION` varchar(50) NOT NULL,
  `ACTION_LEVEL` varchar(50) DEFAULT NULL,
  `PROTOCOL` varchar(50) DEFAULT NULL,
  `EXECUTION_TYPE` varchar(100) NOT NULL,
  `EXECUTION_MODULE` varchar(100) NOT NULL,
  `EXECUTION_RPC` varchar(100) NOT NULL,
  `UPDATED_DATE` datetime DEFAULT NULL,
  `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=72 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `PROTOCOL_REFERENCE`
--

DROP TABLE IF EXISTS `PROTOCOL_REFERENCE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `PROTOCOL_REFERENCE` (
  `PROTOCOL_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ACTION` varchar(50) NOT 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=107 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `REQUEST_ARTIFACTS`
--

DROP TABLE IF EXISTS `REQUEST_ARTIFACTS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `REQUEST_ARTIFACTS` (
  `REQUEST_ARTIFACTS_ID` int(11) NOT NULL AUTO_INCREMENT,
  `REQUEST_ID` varchar(50) NOT NULL,
  `ACTION` varchar(50) NOT NULL,
  `ACTION_LEVEL` 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 AUTO_INCREMENT=10273 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `SVC_LOGIC`
--

DROP TABLE IF EXISTS `SVC_LOGIC`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `SVC_LOGIC` (
  `module` varchar(80) NOT NULL,
  `rpc` varchar(80) NOT NULL,
  `version` varchar(40) NOT NULL,
  `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`
--

DROP TABLE IF EXISTS `UPLOAD_CONFIG`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `UPLOAD_CONFIG` (
  `UPLOAD_CONFIG_ID` int(11) NOT NULL AUTO_INCREMENT,
  `REQUEST_ID` varchar(50) DEFAULT NULL,
  `ORIGINATOR_ID` varchar(50) DEFAULT NULL,
  `SERVICE_DESCRIPTION` varchar(100) DEFAULT NULL,
  `ACTION` varchar(50) DEFAULT NULL,
  `UPLOAD_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `VNF_ID` varchar(50) DEFAULT NULL,
  `VNF_NAME` varchar(50) DEFAULT NULL,
  `VM_NAME` 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`),
  KEY `VNF_ID` (`VNF_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=1656 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `VNFC_DG_MAPPING`
--

DROP TABLE IF EXISTS `VNFC_DG_MAPPING`;
/*!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(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,
  PRIMARY KEY (`VNFC_DG_MAPPING_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `VNFC_REFERENCE`
--

DROP TABLE IF EXISTS `VNFC_REFERENCE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `VNFC_REFERENCE` (
  `VNFC_REFERENCE_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ACTION` 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,
  `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=688 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `VNF_DG_MAPPING`
--

DROP TABLE IF EXISTS `VNF_DG_MAPPING`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `VNF_DG_MAPPING` (
  `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 */;

--
-- Table structure for table `VNF_LOCK_MANAGEMENT`
--

DROP TABLE IF EXISTS `VNF_LOCK_MANAGEMENT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `VNF_LOCK_MANAGEMENT` (
  `RESOURCE_ID` varchar(50) NOT 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',
  PRIMARY KEY (`RESOURCE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `VNF_STATE_MANAGEMENT`
--

DROP TABLE IF EXISTS `VNF_STATE_MANAGEMENT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `VNF_STATE_MANAGEMENT` (
  `VNF_ID` varchar(50) NOT NULL,
  `STATE` varchar(50) NOT NULL,
  `OWNER_ID` varchar(255) DEFAULT NULL,
  `UPDATED` bigint(20) unsigned NOT NULL,
  `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 */;