diff options
author | Lorraine Welch <lb2391@att.com> | 2020-03-17 17:40:08 -0400 |
---|---|---|
committer | Lorraine Welch <lb2391@att.com> | 2020-03-17 17:41:24 -0400 |
commit | 9fb9cf5641096a27a407c3cfba202ad020bafb44 (patch) | |
tree | 617a5939ef97d2639da87b6d1f8d0b88ff4024ca /ecomp-sdk/epsdk-app-os/db-scripts | |
parent | b760830e6c9e06cbf30dfb424829b78812158b64 (diff) |
Fixed DB scripts for Frankfurt
Issue-ID: PORTAL-854
Signed-off-by: Lorraine Welch <lb2391@att.com>
Change-Id: Ic7d37ecea2546f481f1fa00070746957c8e53091
Diffstat (limited to 'ecomp-sdk/epsdk-app-os/db-scripts')
-rw-r--r-- | ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDDLMySql_3_2_OS.sql (renamed from ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDDLMySql_3_0_OS.sql) | 4 | ||||
-rw-r--r-- | ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_2_OS.sql (renamed from ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_0_OS.sql) | 4 | ||||
-rw-r--r-- | ecomp-sdk/epsdk-app-os/db-scripts/readme | 16 |
3 files changed, 20 insertions, 4 deletions
diff --git a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDDLMySql_3_0_OS.sql b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDDLMySql_3_2_OS.sql index c0d1c721..cdf257b0 100644 --- a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDDLMySql_3_0_OS.sql +++ b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDDLMySql_3_2_OS.sql @@ -1,5 +1,5 @@ -- --------------------------------------------------------------------------------------------------------------- --- This script adds tables for the OPEN-SOURCE version 2.1.0 of the ECOMP SDK application database. +-- This script adds tables for the OPEN-SOURCE version 3.2.0 of the ECOMP SDK application database. -- The DDL COMMON script must be executed first! -- --------------------------------------------------------------------------------------------------------------- @@ -9,4 +9,4 @@ USE ecomp_sdk; -- No additional tables required at this time -commit;
\ No newline at end of file +commit; diff --git a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_0_OS.sql b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_2_OS.sql index 174a4af6..ece1be3e 100644 --- a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_0_OS.sql +++ b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_3_2_OS.sql @@ -1,5 +1,5 @@ -- --------------------------------------------------------------------------------------------------------------- --- This script populates tables in the OPEN-SOURCE version 2.1.0 of the ECOMP SDK application database. +-- This script populates tables in the OPEN-SOURCE version 3.2.0 of the ECOMP SDK application database. -- The DML COMMON script must be executed first! -- --------------------------------------------------------------------------------------------------------------- @@ -53,4 +53,4 @@ Insert into fn_app (APP_ID,APP_NAME,APP_IMAGE_URL,APP_DESCRIPTION,APP_NOTES,APP_ -- fn_user_role Insert into fn_user_role (USER_ID,ROLE_ID,PRIORITY,APP_ID) values (1,1,null,1); -commit;
\ No newline at end of file +commit; diff --git a/ecomp-sdk/epsdk-app-os/db-scripts/readme b/ecomp-sdk/epsdk-app-os/db-scripts/readme index 81944bb7..57b013c3 100644 --- a/ecomp-sdk/epsdk-app-os/db-scripts/readme +++ b/ecomp-sdk/epsdk-app-os/db-scripts/readme @@ -27,6 +27,11 @@ For ONAP Casablanca instance run EcompSdkDDLMySql_2_4_common.sql and script Eco EcompSdkDDLMySql_2_4_Common.sql - this is a common DDL file EcompSdkDDLMySql_2_4_OS.sql - this is the specific DDL entries that only OS needs, empty placeholder +For ONAP Frankfurt instance run EcompSdkDDLMySql_3_2_common.sql and script EcompSdkDDLMySql_3_2_OS.sql. + +EcompSdkDDLMySql_3_2_Common.sql - this is a common DDL file +EcompSdkDDLMySql_3_2_OS.sql - this is the specific DDL entries that only OS needs, empty placeholder + DML For an ONAP Amsterdam instance run script EcompSdkDMLMySql_1710_Common.sql and script EcompSdkDMLMySql_1710_OS.sql. @@ -38,6 +43,11 @@ For an ONAP Beijing instance run script EcompSdkDMLMySql_2_1_Common.sql and scri EcompSdkDMLMySql_2_1_Common.sql - common DML entries EcompSdkDMLMySql_2_1_OS.sql - DML entries for Opensource needs +For an ONAP Frankfurt instance run script EcompSdkDMLMySql_3_2_Common.sql and script EcompSdkDMLMySql_3_2_OS.sql. + +EcompSdkDMLMySql_3_2_Common.sql - common DML entries +EcompSdkDMLMySql_3_2_OS.sql - DML entries for Opensource needs + For SDK Distribution 2.2 instance run script EcompSdkDMLMySql_2_2_Common.sql and script EcompSdkDMLMySql_2_2_OS.sql. EcompSdkDMLMySql_2_2_Common.sql - common DML entries @@ -64,3 +74,9 @@ Our Existing Partner Apps can call the following scripts to upgrade from 2_1 to EcompSdkMySql_Upgrade_2_1_to_2_2_Common.sql EcompSdkMySql_Rollback_2_2_to_2_1_Common.sql + +Our Existing Partner Apps can call the following scripts to upgrade from 2_6 to 3_2 version +/ecomp-sdk/epsdk-app-common/db-scripts +EcompSdkMySql_Rollback_3_2_to_2_6_Common.sql +EcompSdkMySql_Upgrade_2_6_to_3_2_Common.sql + |