Update VNF_TYPE to 150 characters

Issue-ID: APPC-849
Change-Id: I8754b1336c96619f7207b7bf917b9ad93d2f08cc
Signed-off-by: Skip Wonnell <skip@att.com>

1 files changed, 71 insertions, 18 deletions

diff --git a/installation/appc/src/main/resources/sdnctl.dump b/installation/appc/src/main/resources/sdnctl.dump
index f6ca702..a823a6c 100644
--- a/installation/appc/src/main/resources/sdnctl.dump
+++ b/installation/appc/src/main/resources/sdnctl.dump
@@ -42,6 +42,29 @@ CREATE TABLE `ACTION_LEVEL_REFERENCE` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `APPC_AUTHENTICATION`
+--
+
+DROP TABLE IF EXISTS `APPC_AUTHENTICATION`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `APPC_AUTHENTICATION` (
+  `APPC_AUTHENTICATION_ID` int(11) NOT NULL AUTO_INCREMENT,
+  `VNF_TYPE` varchar(255) DEFAULT NULL,
+  `PROTOCOL` varchar(255) DEFAULT NULL,
+  `ACTION` varchar(255) DEFAULT NULL,
+  `USER_NAME` varchar(255) DEFAULT NULL,
+  `PASSWORD` varchar(255) DEFAULT NULL,
+  `PORT_NUMBER` int(11) DEFAULT NULL,
+  `URL` varchar(1024) DEFAULT NULL,
+  PRIMARY KEY (`APPC_AUTHENTICATION_ID`),
+  UNIQUE KEY `VNF_TYPE` (`VNF_TYPE`),
+  KEY `PROTOCOL` (`PROTOCOL`),
+  KEY `ACTION` (`ACTION`)
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `ASDC_ARTIFACTS`
 --
 
@@ -81,7 +104,7 @@ DROP TABLE IF EXISTS `ASDC_REFERENCE`;
 /*!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,
@@ -105,7 +128,7 @@ CREATE TABLE `CONFIGFILES` (
   `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,
@@ -128,7 +151,7 @@ DROP TABLE IF EXISTS `CONFIGURE_ACTION_DG`;
 /*!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,
@@ -147,7 +170,7 @@ DROP TABLE IF EXISTS `CONFIG_FILE_REFERENCE`;
 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,
@@ -175,7 +198,7 @@ CREATE TABLE `CONFIG_TRANSACTION_LOG` (
   `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=7872 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -187,7 +210,7 @@ DROP TABLE IF EXISTS `DEVICE_AUTHENTICATION`;
 /*!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,
+  `VNF_TYPE` varchar(150) DEFAULT NULL,
   `USER_NAME` varchar(50) DEFAULT NULL,
   `PASSWORD` varchar(100) DEFAULT NULL,
   `PORT_NUMBER` int(11) DEFAULT NULL,
@@ -233,7 +256,7 @@ 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,
+  `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`)
@@ -249,7 +272,7 @@ DROP TABLE IF EXISTS `DEVICE_INTERFACE_PROTOCOL`;
 /*!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,
@@ -268,7 +291,7 @@ DROP TABLE IF EXISTS `DOWNLOAD_CONFIG_TEMPLATE`;
 /*!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`),
@@ -302,7 +325,7 @@ DROP TABLE IF EXISTS `DT_ACTION_STATUS`;
 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,
@@ -404,7 +427,7 @@ DROP TABLE IF EXISTS `GET_CONFIG_TEMPLATE`;
 /*!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,
@@ -427,7 +450,7 @@ 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,
+  `VNF_TYPE` varchar(150) DEFAULT NULL,
   `SEQUENCE_TYPE` varchar(50) DEFAULT NULL,
   `CATEGORY` varchar(50) DEFAULT NULL,
   `GENERATION_NODE` varchar(50) DEFAULT NULL,
@@ -505,7 +528,7 @@ DROP TABLE IF EXISTS `PROTOCOL_REFERENCE`;
 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,
@@ -527,7 +550,7 @@ CREATE TABLE `REQUEST_ARTIFACTS` (
   `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,
@@ -555,6 +578,36 @@ CREATE TABLE `SVC_LOGIC` (
 /*!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`
 --
 
@@ -571,7 +624,7 @@ CREATE 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,
@@ -592,7 +645,7 @@ DROP TABLE IF EXISTS `VNFC_DG_MAPPING`;
 CREATE TABLE `VNFC_DG_MAPPING` (
   `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,
@@ -611,7 +664,7 @@ DROP TABLE IF EXISTS `VNFC_REFERENCE`;
 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,
@@ -635,7 +688,7 @@ DROP TABLE IF EXISTS `VNF_DG_MAPPING`;
 CREATE TABLE `VNF_DG_MAPPING` (
   `action` varchar(50) NOT NULL,
   `api_version` varchar(50) DEFAULT NULL,
-  `vnf_type` 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,