X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=ecomp-portal-DB-os%2FPortalMySql_3_3_Add.sql;h=1a6731ae15f57cc5e3681df93897b7428ecc5e46;hb=cba6e56863cd6622df76113c15404214f399a92d;hp=509e96565fed7c2015aee240c58992fb3a10b31a;hpb=a36db1a18f3d5117517313ba035e2384e00cc0a7;p=portal.git

diff --git a/ecomp-portal-DB-os/PortalMySql_3_3_Add.sql b/ecomp-portal-DB-os/PortalMySql_3_3_Add.sql
index 509e9656..1a6731ae 100644
--- a/ecomp-portal-DB-os/PortalMySql_3_3_Add.sql
+++ b/ecomp-portal-DB-os/PortalMySql_3_3_Add.sql
@@ -11,5 +11,6 @@ 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;
 
+update fn_app set uses_cadi='Y' where COALESCE(app_password, '') = '';
 
 commit;