From d9007d680d19734d5dc106479784c420236cca4b Mon Sep 17 00:00:00 2001 From: Ravindra Bakkamanthala Date: Wed, 31 May 2017 15:54:24 -0400 Subject: [Policy-17] Removed the sql scripts from sdk app Change-Id: I5b017aad569014c7f12eab35e1dbd1c215f90ebe Signed-off-by: Ravindra Bakkamanthala --- .../db-scripts/EcompSdkMySql_Upgrade_1702_to_1707.sql | 18 ------------------ 1 file changed, 18 deletions(-) delete mode 100644 ECOMP-SDK-APP/db-scripts/EcompSdkMySql_Upgrade_1702_to_1707.sql (limited to 'ECOMP-SDK-APP/db-scripts/EcompSdkMySql_Upgrade_1702_to_1707.sql') diff --git a/ECOMP-SDK-APP/db-scripts/EcompSdkMySql_Upgrade_1702_to_1707.sql b/ECOMP-SDK-APP/db-scripts/EcompSdkMySql_Upgrade_1702_to_1707.sql deleted file mode 100644 index d633a2146..000000000 --- a/ECOMP-SDK-APP/db-scripts/EcompSdkMySql_Upgrade_1702_to_1707.sql +++ /dev/null @@ -1,18 +0,0 @@ --- --------------------------------------------------------------------------------------------------------------- --- This script upgrades the ECOMP SDK App database from version 1702 to 1707. --- For use by partner apps to be compatible with changes for the open-source release. --- --- rename 2 columns, change size on 3 name columns from fn_user for the AT&T Opensource version --- --- --------------------------------------------------------------------------------------------------------------- - -USE ecomp_sdk; - -alter table fn_user - CHANGE COLUMN FIRST_NAME FIRST_NAME VARCHAR(50) NULL DEFAULT NULL , - CHANGE COLUMN MIDDLE_NAME MIDDLE_NAME VARCHAR(50) NULL DEFAULT NULL , - CHANGE COLUMN LAST_NAME LAST_NAME VARCHAR(50) NULL DEFAULT NULL, - CHANGE COLUMN SBCID ORG_USER_ID VARCHAR(20) NULL DEFAULT NULL, - CHANGE COLUMN MANAGER_ATTUID ORG_MANAGER_USERID VARCHAR(20) NULL DEFAULT NULL; - -commit; -- cgit 1.2.3-korg