From bb7f6b35d12ed41640b844fd3a1ccd5477670cad Mon Sep 17 00:00:00 2001 From: Skip Wonnell Date: Wed, 11 Apr 2018 15:07:13 -0500 Subject: [PATCH] Update VNF_TYPE to 150 characters Issue-ID: APPC-849 Change-Id: I8754b1336c96619f7207b7bf917b9ad93d2f08cc Signed-off-by: Skip Wonnell --- installation/appc/src/main/resources/sdnctl.dump | 89 +++++++++++++++++++----- 1 file 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 @@ -41,6 +41,29 @@ CREATE TABLE `ACTION_LEVEL_REFERENCE` ( ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `APPC_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, @@ -554,6 +577,36 @@ CREATE TABLE `SVC_LOGIC` ( ) 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` -- @@ -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, -- 2.16.6