From 6beb446925c967aca92f5513adf36c5db77c00d6 Mon Sep 17 00:00:00 2001 From: TATTAVARADA Date: Thu, 27 Apr 2017 07:53:18 -0400 Subject: [PORTAL-7] Rebase This rebasing includes common libraries and common overlays projects abstraction of components Change-Id: Ia1efa4deacdc5701e6205104ac021a6c80ed60ba Signed-off-by: st782s --- ecomp-sdk/epsdk-app-common/db-scripts/readme.txt | 54 ++++++++++++++++++++++++ 1 file changed, 54 insertions(+) create mode 100644 ecomp-sdk/epsdk-app-common/db-scripts/readme.txt (limited to 'ecomp-sdk/epsdk-app-common/db-scripts/readme.txt') 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 -- cgit 1.2.3-korg