summaryrefslogtreecommitdiffstats
path: root/ECOMP-SDK-APP/db-scripts/EcompSdkMySql_Upgrade_1702_to_1707.sql
diff options
context:
space:
mode:
authorITSERVICES\rb7147 <rb7147@att.com>2017-04-25 11:46:00 -0400
committerITSERVICES\rb7147 <rb7147@att.com>2017-05-03 09:58:17 -0400
commite0addf5b588a1244f9679becd90999dfcb4c3a94 (patch)
tree1212772d6366730266ff0e093c874b07aa716c29 /ECOMP-SDK-APP/db-scripts/EcompSdkMySql_Upgrade_1702_to_1707.sql
parent39fb0f30472777e4b60d6a7ac8aa4eb9773961ff (diff)
Policy 1707 commit to LF
Change-Id: Ibe6f01d92f9a434c040abb05d5386e89d675ae65 Signed-off-by: ITSERVICES\rb7147 <rb7147@att.com>
Diffstat (limited to 'ECOMP-SDK-APP/db-scripts/EcompSdkMySql_Upgrade_1702_to_1707.sql')
-rw-r--r--ECOMP-SDK-APP/db-scripts/EcompSdkMySql_Upgrade_1702_to_1707.sql18
1 files changed, 18 insertions, 0 deletions
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
new file mode 100644
index 000000000..d633a2146
--- /dev/null
+++ b/ECOMP-SDK-APP/db-scripts/EcompSdkMySql_Upgrade_1702_to_1707.sql
@@ -0,0 +1,18 @@
+-- ---------------------------------------------------------------------------------------------------------------
+-- 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;