Merge "Policy 1707 commit to LF"

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;