summaryrefslogtreecommitdiffstats
path: root/ecomp-sdk/epsdk-app-common/db-scripts/readme.txt
diff options
context:
space:
mode:
authorTATTAVARADA <statta@research.att.com>2017-04-27 07:53:18 -0400
committerst782s <statta@research.att.com>2017-04-27 08:31:27 -0400
commit6beb446925c967aca92f5513adf36c5db77c00d6 (patch)
tree9392057ed0739de2445c5b2a2a8bee6dcdacbcf7 /ecomp-sdk/epsdk-app-common/db-scripts/readme.txt
parent246b225194e3e8dc1926294de591a94fd9787fa7 (diff)
[PORTAL-7] Rebase
This rebasing includes common libraries and common overlays projects abstraction of components Change-Id: Ia1efa4deacdc5701e6205104ac021a6c80ed60ba Signed-off-by: st782s <statta@research.att.com>
Diffstat (limited to 'ecomp-sdk/epsdk-app-common/db-scripts/readme.txt')
-rw-r--r--ecomp-sdk/epsdk-app-common/db-scripts/readme.txt54
1 files changed, 54 insertions, 0 deletions
diff --git a/ecomp-sdk/epsdk-app-common/db-scripts/readme.txt b/ecomp-sdk/epsdk-app-common/db-scripts/readme.txt
new file mode 100644
index 00000000..d128cbd3
--- /dev/null
+++ b/ecomp-sdk/epsdk-app-common/db-scripts/readme.txt
@@ -0,0 +1,54 @@
+This Readme file contains a description of all the database scripts located in
+
+ epsdk-app-common / db-scripts /
+
+***************************************************************************************************************************************
+
+Directions:
+
+DDL
+EcompSdkDDLMySql_1707_Common.sql - this is the DDL entries that are in common
+
+DML
+EcompSdkDMLMySql_1707_Common.sql - this is the DML entries that are in common
+
+
+***************************************************************************************************************************************
+ epsdk-app-common / db-scripts /
+***************************************************************************************************************************************
+5.EcompSdkDDLMySql_1707_Common.sql This script creates tables in the 1707 COMMON version of the ECOMP SDK application database.
+ Additional DDL scripts may be required for different versions!
+6.EcompSdkDMLMySql_1707_Common.sql This script populates tables in the 1707 COMMON version of the ECOMP SDK application database.
+ Additional DML scripts are required for different versions!
+
+
+*****************************************************
+Upgrading from 1607 SDK to 1610 SDK
+*****************************************************
+EcompSdkDDL_1610_Add.sql This is the Upgrade script for the 1610 Version of the SDK database called ecomp_sdk;
+ upgrading from the 1607 version
+EcompSdkDML_1610_Add.sql This is the Upgrade script for the default data for the 1610 Version of the SDK database called ecomp_sdk;
+ upgrading from the 1607 version
+*****************************************************
+Upgrading from 1610 SDK to 1702 SDK
+*****************************************************
+If you are starting with a 1610 environment and want to bring it up to 1702,
+you can run the following scripts in this order:
+EcompSdkDML_1702_Add_1.sql
+EcompSdkDML_1702_Add_2.sql
+EcompSdkDML_1702_Add_3.sql
+EcompSdkDML_1702_Add_4.sql
+EcompSdkDML_1702_Add_5.sql
+
+You can roll back the changes from the corresponding 1702 Add scripts with these rollback scripts:
+EcompSdkDML_1702_Rollback_1.sql
+EcompSdkDML_1702_Rollback_2.sql
+EcompSdkDML_1702_Rollback_3.sql
+EcompSdkDML_1702_Rollback_4.sql
+EcompSdkDML_1702_Rollback_5.sql
+
+*****************************************************
+Complete Scripts for 1702
+*****************************************************
+EcompSdkDDLMySql_1702.sql This is for the 1702 DDL Version of SDK database called ecomp_sdk
+EcompSdkDMLMySql_1702.sql This is for the default data for 1702 Version of SDK database called ecomp_sdk