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

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;