diff options
Diffstat (limited to 'ecomp-portal-DB-os/PortalMySql_3_3_Add.sql')
| -rw-r--r-- | ecomp-portal-DB-os/PortalMySql_3_3_Add.sql | 1 |
1 files changed, 1 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 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; |