ecomp-portal-DB-os/PortalMySql_3_3_Add.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

set foreign_key_checks=1;

use portal;

ALTER TABLE fn_app
ADD COLUMN mode_of_integration varchar(50) DEFAULT NULL AFTER ueb_topic_name;

ALTER TABLE fn_app
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;