[Policy-17] Removed the sql scripts from sdk app

[policy/engine.git] / ECOMP-SDK-APP / db-scripts / EcompSdkMySql_Rollback_1707_to_1702.sql

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 (file)
index 0f5e071..0000000
--- 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;