Adding sql for new appc tables

Change-Id: Ia7a3bc1e09469c677c105abca118ba402815ae9a
Signed-off-by: Patrick Brady <pb071s@att.com>
Issue-id: APPC-206

diff --git a/installation/appc/src/main/resources/sdnctl.dump b/installation/appc/src/main/resources/sdnctl.dump
new file mode 100644 (file)
index 0000000..11f1127
--- /dev/null
+++ b/installation/appc/src/main/resources/sdnctl.dump
@@ -0,0 +1,657 @@
+CREATE DATABASE  IF NOT EXISTS `sdnctl` /*!40100 DEFAULT CHARACTER SET latin1 */;
+USE `sdnctl`;
+
+SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;
+SET @@SESSION.SQL_LOG_BIN= 0;
+
+--
+-- 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 `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=1412 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(50) 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=137 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(50) 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=688 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(50) 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;
+/*!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(50) 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=11 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=1074 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(50) DEFAULT NULL,
+  `USER_NAME` varchar(50) DEFAULT NULL,
+  `PASSWORD` varchar(100) DEFAULT NULL,
+  `PORT_NUMBER` int(11) DEFAULT NULL,
+  PRIMARY KEY (`DEVICE_AUTHENTICATION_ID`),
+  UNIQUE KEY `DEVICE_AUTHENTICATION_ID` (`DEVICE_AUTHENTICATION_ID`)
+) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Temporary view 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,
+  `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(50) 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;
+/*!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(50) NOT 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;
+/*!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(50) 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 `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(50) NOT 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=9 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(50) 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 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 `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=558 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=38 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(50) 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;
+/*!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(50) 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;
+/*!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,
+  PRIMARY KEY (`module`,`rpc`,`version`,`mode`)
+) 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(50) 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;
+/*!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` (
+  `ACTION` varchar(50) DEFAULT NULL,
+  `API_VERSION` varchar(10) DEFAULT NULL,
+  `VNF_TYPE` varchar(50) 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;
+/*!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(50) NOT 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,
+  PRIMARY KEY (`VNFC_REFERENCE_ID`),
+  UNIQUE KEY ` VNFC_REFERENCE_ID` (`VNFC_REFERENCE_ID`)
+) ENGINE=InnoDB AUTO_INCREMENT=18 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` (
+  `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;
+/*!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(50) 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;
+
+SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;

diff --git a/installation/appc/src/main/scripts/installAppcDb.sh b/installation/appc/src/main/scripts/installAppcDb.sh
index fcbf010..1b8ee4b 100644 (file)
--- a/installation/appc/src/main/scripts/installAppcDb.sh
+++ b/installation/appc/src/main/scripts/installAppcDb.sh
@@ -41,3 +41,8 @@ if [ -f ${APPC_HOME}/data/appcctl.dump ]
 then
   mysql -h dbhost -u root -p${MYSQL_PASSWD} appcctl < ${APPC_HOME}/data/appcctl.dump
 fi
+
+if [ -f ${APPC_HOME}/data/sdnctl.dump ]
+then
+  mysql -h dbhost -u root -p${MYSQL_PASSWD} sdnctl < ${APPC_HOME}/data/sdnctl.dump
+fi