diff options
| author |   Ravindra Bakkamanthala <rb7147@att.com> | 2017-05-31 15:54:24 -0400 |
|---|---|---|
| committer | Ravindra Bakkamanthala <rb7147@att.com> | 2017-05-31 15:57:02 -0400 |
| commit | d9007d680d19734d5dc106479784c420236cca4b (patch) | |
| tree | b3356847c3d6e1543098b447c1df7d49e7118652 /ECOMP-SDK-APP/db-scripts/EcompSdkMySql_Rollback_1707_to_1702.sql | |
| parent | 6a5e800771311208c66ad79ce1bdf76affd144b2 (diff) | |
[Policy-17] Removed the sql scripts from sdk app
Change-Id: I5b017aad569014c7f12eab35e1dbd1c215f90ebe
Signed-off-by: Ravindra Bakkamanthala <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, 0 insertions, 18 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 deleted file mode 100644 index 0f5e07133..000000000 --- a/ECOMP-SDK-APP/db-scripts/EcompSdkMySql_Rollback_1707_to_1702.sql +++ /dev/null @@ -1,18 +0,0 @@ --- --------------------------------------------------------------------------------------------------------------- --- 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; |