diff options
| author |   ITSERVICES\rb7147 <rb7147@att.com> | 2017-04-25 11:46:00 -0400 |
|---|---|---|
| committer | ITSERVICES\rb7147 <rb7147@att.com> | 2017-05-03 09:58:17 -0400 |
| commit | e0addf5b588a1244f9679becd90999dfcb4c3a94 (patch) | |
| tree | 1212772d6366730266ff0e093c874b07aa716c29 /ECOMP-SDK-APP/db-scripts/EcompSdkMySql_Rollback_1707_to_1702.sql | |
| parent | 39fb0f30472777e4b60d6a7ac8aa4eb9773961ff (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_Rollback_1707_to_1702.sql')
| -rw-r--r-- | ECOMP-SDK-APP/db-scripts/EcompSdkMySql_Rollback_1707_to_1702.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/ECOMP-SDK-APP/db-scripts/EcompSdkMySql_Rollback_1707_to_1702.sql b/ECOMP-SDK-APP/db-scripts/EcompSdkMySql_Rollback_1707_to_1702.sql new file mode 100644 index 000000000..0f5e07133 --- /dev/null +++ b/ECOMP-SDK-APP/db-scripts/EcompSdkMySql_Rollback_1707_to_1702.sql @@ -0,0 +1,18 @@ +-- --------------------------------------------------------------------------------------------------------------- +-- This script rolls-back the upgrade for the ECOMP SDK App database from version 1702 to 1707. +-- For use by partner apps to undo 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(25) NULL DEFAULT NULL , + CHANGE COLUMN MIDDLE_NAME MIDDLE_NAME VARCHAR(25) NULL DEFAULT NULL , + CHANGE COLUMN LAST_NAME LAST_NAME VARCHAR(25) NULL DEFAULT NULL, + CHANGE COLUMN ORG_USER_ID SBCID VARCHAR(6) NULL DEFAULT NULL, + CHANGE COLUMN ORG_MANAGER_USERID MANAGER_ATTUID VARCHAR(6) NULL DEFAULT NULL; + +commit; |