diff options
| author |   Muni Mohan Kunchi <munmohan@att.com> | 2020-07-27 15:41:39 -0400 |
|---|---|---|
| committer | Muni Mohan Kunchi <munmohan@att.com> | 2020-07-27 15:42:31 -0400 |
| commit | 472a602b64e9ef71d36098c197a581c693458128 (patch) | |
| tree | fb8a59bab3f9b3dfaf5341d3872c925dcea17350 /ecomp-portal-DB-os/PortalMySql_3_3_Add.sql | |
| parent | f241a11c8783c6a230a93d28101a62509af9e640 (diff) | |
updated DB scripts for common and OS.
Issue-ID: PORTAL-965
Signed-off-by: Muni Mohan Kunchi <munmohan@att.com>
Change-Id: Idc4ae908c9894a615839381ea6c090f6fa28f635
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; |