commit 1711d5575d770c51b529a4c43a9d5cfa38158559
author Chan, Mercy <merce.chan@att.com> Thu Nov 07 12:06:57 2019 -0500
committer Benjamin, Max (mb388a) <mb388a@att.com> Thu Nov 07 12:06:58 2019 -0500
tree 487863db39fa8dedfbcbaaf7e77d398e2b6a7138
parent eaadad862197340a771c558bb956f44a2d082d07

remove unused columns infra active requests

Removed unused columns in db across codebase

Issue-ID: SO-2516
Signed-off-by: Benjamin, Max (mb388a) <mb388a@att.com>
Change-Id: Ieedb61ed371bc3626ef94df0bf88b7a9cf139c82

mso-api-handlers/mso-api-handler-infra/src/test/resources/schema.sql

diff --git a/mso-api-handlers/mso-api-handler-infra/src/test/resources/schema.sql b/mso-api-handlers/mso-api-handler-infra/src/test/resources/schema.sql
index 2129dc2..a93ffd4 100644
--- a/mso-api-handlers/mso-api-handler-infra/src/test/resources/schema.sql
+++ b/mso-api-handlers/mso-api-handler-infra/src/test/resources/schema.sql
@@ -1248,8 +1248,6 @@
 
 CREATE TABLE `infra_active_requests` (
   `REQUEST_ID` varchar(45) NOT NULL,
-  `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
-  `ACTION` varchar(45) DEFAULT NULL,
   `REQUEST_STATUS` varchar(20) DEFAULT NULL,
   `STATUS_MESSAGE` longtext DEFAULT NULL,
   `PROGRESS` bigint(20) DEFAULT NULL,
@@ -1260,22 +1258,18 @@
   `VNF_NAME` varchar(80) DEFAULT NULL,
   `VNF_TYPE` varchar(200) DEFAULT NULL,
   `SERVICE_TYPE` varchar(45) DEFAULT NULL,
-  `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
   `TENANT_ID` varchar(45) DEFAULT NULL,
-  `PROV_STATUS` varchar(20) DEFAULT NULL,
   `VNF_PARAMS` longtext,
   `VNF_OUTPUTS` longtext,
   `REQUEST_BODY` longtext,
   `RESPONSE_BODY` longtext,
   `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
   `MODIFY_TIME` datetime DEFAULT NULL,
-  `REQUEST_TYPE` varchar(20) DEFAULT NULL,
   `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
   `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
   `VF_MODULE_ID` varchar(45) DEFAULT NULL,
   `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
   `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
-  `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
   `CLOUD_REGION` varchar(11) DEFAULT NULL,
   `CALLBACK_URL` varchar(200) DEFAULT NULL,
   `CORRELATOR` varchar(80) DEFAULT NULL,
@@ -1295,14 +1289,11 @@
   `ORIGINAL_REQUEST_ID` varchar(45) DEFAULT NULL,
   `EXT_SYSTEM_ERROR_SOURCE` varchar(80) DEFAULT NULL,
   `ROLLBACK_EXT_SYSTEM_ERROR_SOURCE` varchar(80) DEFAULT NULL,
-  PRIMARY KEY (`REQUEST_ID`),
-  UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d5ak` (`CLIENT_REQUEST_ID`)
+  PRIMARY KEY (`REQUEST_ID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 CREATE TABLE `archived_infra_requests` (
   `REQUEST_ID` varchar(45) NOT NULL,
-  `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
-  `ACTION` varchar(45) DEFAULT NULL,
   `REQUEST_STATUS` varchar(20) DEFAULT NULL,
   `STATUS_MESSAGE` longtext DEFAULT NULL,
   `PROGRESS` bigint(20) DEFAULT NULL,
@@ -1313,22 +1304,18 @@
   `VNF_NAME` varchar(80) DEFAULT NULL,
   `VNF_TYPE` varchar(200) DEFAULT NULL,
   `SERVICE_TYPE` varchar(45) DEFAULT NULL,
-  `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
   `TENANT_ID` varchar(45) DEFAULT NULL,
-  `PROV_STATUS` varchar(20) DEFAULT NULL,
   `VNF_PARAMS` longtext,
   `VNF_OUTPUTS` longtext,
   `REQUEST_BODY` longtext,
   `RESPONSE_BODY` longtext,
   `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
   `MODIFY_TIME` datetime DEFAULT NULL,
-  `REQUEST_TYPE` varchar(20) DEFAULT NULL,
   `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
   `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
   `VF_MODULE_ID` varchar(45) DEFAULT NULL,
   `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
   `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
-  `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
   `CLOUD_REGION` varchar(11) DEFAULT NULL,
   `CALLBACK_URL` varchar(200) DEFAULT NULL,
   `CORRELATOR` varchar(80) DEFAULT NULL,
@@ -1345,8 +1332,7 @@
   `OPERATIONAL_ENV_ID` varchar(45) DEFAULT NULL,
   `OPERATIONAL_ENV_NAME` varchar(200) DEFAULT NULL,
   `REQUEST_URL` varchar(500) DEFAULT NULL,  
-  PRIMARY KEY (`REQUEST_ID`),
-  UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d59h` (`CLIENT_REQUEST_ID`)
+  PRIMARY KEY (`REQUEST_ID`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 CREATE TABLE `site_status` (