updated DB scripts for common and OS.

[portal.git] / 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
index 509e965..1a6731a 100644 (file)
--- 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;