summaryrefslogtreecommitdiffstats
path: root/ECOMP-SDK-APP/db-scripts/readme.txt
blob: 28a697d548c17efb4e00e105bb50296119edfed0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
This Readme file contains a description of all the database scripts located in  

  epsdk-app-att    / db-scripts / 
  epsdk-app-att    / db-scripts / previous-releases / 
  epsdk-app-common / db-scripts / 
  epsdk-app-os     / db-scripts / 
  
***************************************************************************************************************************************

Directions: 

DDL
For an Opensource instance run only script 3; for an AT&T instance add script 1
EEcompSdkDDLMySql_1707_Common.sql  - this is the DDL entries that both Opensource and AT&T have in common
EcompSdkDDLMySql_1707_ATT.sql -  this is the specific DDL entries that only AT&T needs

DML

For an Opensource instance run  script 4 and script 8; for an AT&T instance run script 4 and script 2
EcompSdkDMLMySql_1707_Common.sql  - this is the DML entries that both Opensource and AT&T have in common
EcompSdkDMLMySql_1707_ATT.sql - this is the specific DML entries that only AT&T needs
EcompSdkDMLMySql_1707_OS.sql - this is the specific DML entries that only Opensource needs

Our Partner Apps need to change the names and sizes of some columns in fn_user; use script 5 for that
and if needed to remove the change use script 6.
EcompSdkMySql_Upgrade_1702_to_1707.sql
EcompSdkMySql_Rollback_1707_to_1702.sql
	
***************************************************************************************************************************************
  epsdk-app-att / db-scripts / 
***************************************************************************************************************************************	
1.EcompSdkDDLMySql_1707_ATT.sql    			This script adds tables for the 1707 AT&T version of the ECOMP SDK application database.
											The DDL 1707 COMMON script must be executed first
2.EcompSdkDMLMySql_1707_ATT.sql    			This script populates tables in the 1707 AT&T version of the ECOMP SDK application database.
											The DML 1707 COMMON script must be executed first!	
***************************************************************************************************************************************
  epsdk-app-common / db-scripts / 
***************************************************************************************************************************************	
3.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 the AT&T version or the OPEN-SOURCE version!
4.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 the AT&T version or the OPEN-SOURCE version!
5.EcompSdkMySql_Upgrade_1702_to_1707.sql    This script upgrades the ECOMP SDK App database from version 1702 to 1707.
											For use by partner apps to be compatible with changes for the open-source release.
6.EcompSdkMySql_Rollback_1707_to_1702.sql   This script rolls-back the upgrade for the ECOMP SDK App database from version 1707 to 1702.
											For use by partner apps to undo changes for the open-source release.
***************************************************************************************************************************************
epsdk-app-os / db-scripts / 
***************************************************************************************************************************************	
7.EcompSdkDDLMySql_1707_OS.sql  			It is empty for now; just a logical placeholder
8.EcompSdkDMLMySql_1707_OS.sql  			This script populates tables in the 1707 OPEN-SOURCE version of the ECOMP SDK application database.
											After The DML 1707 COMMON script is run.

***************************************************************************************************************************************
epsdk-app-att / db-scripts / previous-releases /
***************************************************************************************************************************************	
cleanup_EcompSdk.sql						This script drops tables no longer needed that were in the original schema.
EcompSdkTestDML.sql							This scripts adds user/roles for a test envirionment

*****************************************************
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