--Add New colunm for notification read or not read status in mobile 
alter table ntf_log 
add ntf_log_read_flag varchar(1)
GO


----Update column to 1 (read) and 0 (not read)
update ntf_log set ntf_log_read_flag = '1' where ntf_log_read_flag IS NULL
GO