summaryrefslogtreecommitdiffstats
path: root/ecomp-sdk/epsdk-app-os
diff options
context:
space:
mode:
authorLorraine Welch <lb2391@att.com>2020-03-17 17:40:08 -0400
committerLorraine Welch <lb2391@att.com>2020-03-17 17:41:24 -0400
commit9fb9cf5641096a27a407c3cfba202ad020bafb44 (patch)
tree617a5939ef97d2639da87b6d1f8d0b88ff4024ca /ecomp-sdk/epsdk-app-os
parentb760830e6c9e06cbf30dfb424829b78812158b64 (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')
-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/readme16
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
+