diff options
| author |   Sunder Tattavarada <statta@research.att.com> | 2020-07-17 22:02:07 +0000 |
|---|---|---|
| committer |   Gerrit Code Review <gerrit@onap.org> | 2020-07-17 22:02:07 +0000 |
| commit | 7945565f9363846d0a8864217c2f77401960208c (patch) | |
| tree | 3a304b59196a6c7c8385c35f65453c87e0868f2b /ecomp-portal-DB-os | |
| parent | c7c662b218b527c9aa1df61e51dca6c68fa2c84d (diff) | |
| parent | a36db1a18f3d5117517313ba035e2384e00cc0a7 (diff) | |
Merge "Portal Non-Gui application onboarding changes"
Diffstat (limited to 'ecomp-portal-DB-os')
| -rw-r--r-- | ecomp-portal-DB-os/PortalMySql_3_3_Add.sql | 15 | ||||
| -rw-r--r-- | ecomp-portal-DB-os/PortalMySql_3_3_Remove.sql | 10 | ||||
| -rw-r--r-- | ecomp-portal-DB-os/README.md | 4 |
3 files changed, 27 insertions, 2 deletions
diff --git a/ecomp-portal-DB-os/PortalMySql_3_3_Add.sql b/ecomp-portal-DB-os/PortalMySql_3_3_Add.sql new file mode 100644 index 00000000..509e9656 --- /dev/null +++ b/ecomp-portal-DB-os/PortalMySql_3_3_Add.sql @@ -0,0 +1,15 @@ +set foreign_key_checks=1; + +use portal; + +ALTER TABLE fn_app +ADD COLUMN mode_of_integration varchar(50) DEFAULT NULL AFTER ueb_topic_name; + +ALTER TABLE fn_app +ADD COLUMN ack_app CHAR(1) DEFAULT 'Y' AFTER ueb_topic_name; + +ALTER TABLE fn_app +ADD COLUMN uses_cadi CHAR(1) DEFAULT NULL AFTER ueb_topic_name; + + +commit; diff --git a/ecomp-portal-DB-os/PortalMySql_3_3_Remove.sql b/ecomp-portal-DB-os/PortalMySql_3_3_Remove.sql new file mode 100644 index 00000000..f1aba387 --- /dev/null +++ b/ecomp-portal-DB-os/PortalMySql_3_3_Remove.sql @@ -0,0 +1,10 @@ + +use portal; + +alter table fn_app drop column mode_of_integration; + +alter table fn_app drop column ack_app; + +alter table fn_app drop column uses_cadi; + +commit;
\ No newline at end of file diff --git a/ecomp-portal-DB-os/README.md b/ecomp-portal-DB-os/README.md index c6c830ce..d3a7d9fc 100644 --- a/ecomp-portal-DB-os/README.md +++ b/ecomp-portal-DB-os/README.md @@ -10,9 +10,9 @@ DDL For an Opensource instance run only -3_2: script PortalDDLMySql_2_1_Common.sql. +3_3: script PortalDDLMySql_3_3_Common.sql. -3_2: PortalDDLMySql_3_2_OS.sql is only a placeholder at this time. +3_3: PortalDDLMySql_3_2_OS.sql is only a placeholder at this time. DML |