1 This Readme file contains a description of all the database scripts located in
3 epsdk-app-att / db-scripts /
4 epsdk-app-att / db-scripts / previous-releases /
5 epsdk-app-common / db-scripts /
6 epsdk-app-os / db-scripts /
8 ***************************************************************************************************************************************
13 For an Opensource instance run only script 3; for an AT&T instance add script 1
14 EEcompSdkDDLMySql_1707_Common.sql - this is the DDL entries that both Opensource and AT&T have in common
15 EcompSdkDDLMySql_1707_ATT.sql - this is the specific DDL entries that only AT&T needs
19 For an Opensource instance run script 4 and script 8; for an AT&T instance run script 4 and script 2
20 EcompSdkDMLMySql_1707_Common.sql - this is the DML entries that both Opensource and AT&T have in common
21 EcompSdkDMLMySql_1707_ATT.sql - this is the specific DML entries that only AT&T needs
22 EcompSdkDMLMySql_1707_OS.sql - this is the specific DML entries that only Opensource needs
24 Our Partner Apps need to change the names and sizes of some columns in fn_user; use script 5 for that
25 and if needed to remove the change use script 6.
26 EcompSdkMySql_Upgrade_1702_to_1707.sql
27 EcompSdkMySql_Rollback_1707_to_1702.sql
29 ***************************************************************************************************************************************
30 epsdk-app-att / db-scripts /
31 ***************************************************************************************************************************************
32 1.EcompSdkDDLMySql_1707_ATT.sql This script adds tables for the 1707 AT&T version of the ECOMP SDK application database.
33 The DDL 1707 COMMON script must be executed first
34 2.EcompSdkDMLMySql_1707_ATT.sql This script populates tables in the 1707 AT&T version of the ECOMP SDK application database.
35 The DML 1707 COMMON script must be executed first!
36 ***************************************************************************************************************************************
37 epsdk-app-common / db-scripts /
38 ***************************************************************************************************************************************
39 3.EcompSdkDDLMySql_1707_Common.sql This script creates tables in the 1707 COMMON version of the ECOMP SDK application database.
40 Additional DDL scripts may be required for the AT&T version or the OPEN-SOURCE version!
41 4.EcompSdkDMLMySql_1707_Common.sql This script populates tables in the 1707 COMMON version of the ECOMP SDK application database.
42 Additional DML scripts are required for the AT&T version or the OPEN-SOURCE version!
43 5.EcompSdkMySql_Upgrade_1702_to_1707.sql This script upgrades the ECOMP SDK App database from version 1702 to 1707.
44 For use by partner apps to be compatible with changes for the open-source release.
45 6.EcompSdkMySql_Rollback_1707_to_1702.sql This script rolls-back the upgrade for the ECOMP SDK App database from version 1707 to 1702.
46 For use by partner apps to undo changes for the open-source release.
47 ***************************************************************************************************************************************
48 epsdk-app-os / db-scripts /
49 ***************************************************************************************************************************************
50 7.EcompSdkDDLMySql_1707_OS.sql It is empty for now; just a logical placeholder
51 8.EcompSdkDMLMySql_1707_OS.sql This script populates tables in the 1707 OPEN-SOURCE version of the ECOMP SDK application database.
52 After The DML 1707 COMMON script is run.
54 ***************************************************************************************************************************************
55 epsdk-app-att / db-scripts / previous-releases /
56 ***************************************************************************************************************************************
57 cleanup_EcompSdk.sql This script drops tables no longer needed that were in the original schema.
58 EcompSdkTestDML.sql This scripts adds user/roles for a test envirionment
60 *****************************************************
61 Upgrading from 1607 SDK to 1610 SDK
62 *****************************************************
63 EcompSdkDDL_1610_Add.sql This is the Upgrade script for the 1610 Version of the SDK database called ecomp_sdk;
64 upgrading from the 1607 version
65 EcompSdkDML_1610_Add.sql This is the Upgrade script for the default data for the 1610 Version of the SDK database called ecomp_sdk;
66 upgrading from the 1607 version
67 *****************************************************
68 Upgrading from 1610 SDK to 1702 SDK
69 *****************************************************
70 If you are starting with a 1610 environment and want to bring it up to 1702,
71 you can run the following scripts in this order:
72 EcompSdkDML_1702_Add_1.sql
73 EcompSdkDML_1702_Add_2.sql
74 EcompSdkDML_1702_Add_3.sql
75 EcompSdkDML_1702_Add_4.sql
76 EcompSdkDML_1702_Add_5.sql
78 You can roll back the changes from the corresponding 1702 Add scripts with these rollback scripts:
79 EcompSdkDML_1702_Rollback_1.sql
80 EcompSdkDML_1702_Rollback_2.sql
81 EcompSdkDML_1702_Rollback_3.sql
82 EcompSdkDML_1702_Rollback_4.sql
83 EcompSdkDML_1702_Rollback_5.sql
85 *****************************************************
86 Complete Scripts for 1702
87 *****************************************************
88 EcompSdkDDLMySql_1702.sql This is for the 1702 DDL Version of SDK database called ecomp_sdk
89 EcompSdkDMLMySql_1702.sql This is for the default data for 1702 Version of SDK database called ecomp_sdk