diff options
| author |   Rachitha Ramappa <rachitha.ramappa@att.com> | 2020-07-02 12:56:08 +0530 |
|---|---|---|
| committer |   Muni Mohan Kunchi <munmohan@att.com> | 2020-07-17 16:48:53 -0400 |
| commit | a36db1a18f3d5117517313ba035e2384e00cc0a7 (patch) | |
| tree | b3424bdf4d6c6479ef30251a281eb1339f4d9af9 /ecomp-portal-DB-os/PortalMySql_3_3_Add.sql | |
| parent | d856cbc5d725836a07776b0f20f06bbbda7b5412 (diff) | |
Portal Non-Gui application onboarding changes
Change-Id: Ib878398995e1d7a407d44ea6113c05aab2dd1625
Issue-ID: PORTAL-935
Signed-off-by: Muni Mohan Kunchi <munmohan@att.com>
Diffstat (limited to 'ecomp-portal-DB-os/PortalMySql_3_3_Add.sql')
| -rw-r--r-- | ecomp-portal-DB-os/PortalMySql_3_3_Add.sql | 15 |
1 files changed, 15 insertions, 0 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; |