Update VNF_TYPE to 150 characters
Issue-ID: APPC-849
Change-Id: I8754b1336c96619f7207b7bf917b9ad93d2f08cc
Signed-off-by: Skip Wonnell <skip@att.com>
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 @@
/*!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 @@
/*!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 @@
`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 @@
/*!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 @@
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 @@
`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 @@
/*!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 @@
`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 @@
/*!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 @@
/*!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 @@
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 @@
/*!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 @@
`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 @@
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 @@
`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 @@
/*!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 @@
`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 @@
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 @@
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 @@
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,