From a36db1a18f3d5117517313ba035e2384e00cc0a7 Mon Sep 17 00:00:00 2001
From: Rachitha Ramappa <rachitha.ramappa@att.com>
Date: Thu, 2 Jul 2020 12:56:08 +0530
Subject: Portal Non-Gui application onboarding changes

Change-Id: Ib878398995e1d7a407d44ea6113c05aab2dd1625
Issue-ID: PORTAL-935
Signed-off-by: Muni Mohan Kunchi <munmohan@att.com>
---
 ecomp-portal-DB-os/PortalMySql_3_3_Add.sql | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 ecomp-portal-DB-os/PortalMySql_3_3_Add.sql

(limited to 'ecomp-portal-DB-os/PortalMySql_3_3_Add.sql')

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;
-- 
cgit 1.2.3-korg

