diff options
author | Jorge Hernandez <jh1730@att.com> | 2017-05-03 21:31:58 +0000 |
---|---|---|
committer | Gerrit Code Review <gerrit@onap.org> | 2017-05-03 21:31:58 +0000 |
commit | a330af579866dacbe595e2e4ad1dd29cd3c96945 (patch) | |
tree | b9455591600034dfd4f33a9c1f733336280f2208 /ECOMP-SDK-APP/db-scripts/EcompSdkMySql_Upgrade_1702_to_1707.sql | |
parent | 5444e748b8651d8346dcb78c5ab8b0637dea197b (diff) | |
parent | e0addf5b588a1244f9679becd90999dfcb4c3a94 (diff) |
Merge "Policy 1707 commit to LF"
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.sql | 18 |
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; |