


alter table dft_mst
Add dft_mst_ww_disp_day [numeric](5, 0) NULL
GO

alter table dft_mst
Add dft_mst_clo_popup [numeric](5, 0) NULL
GO

alter table dft_mst
Add dft_mst_edit_flag [numeric](5, 0) NULL
GO

Update dft_mst set dft_mst_ww_disp_day = '365'
GO

IF NOT EXISTS (
    SELECT 1
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'dft_mst'
      AND COLUMN_NAME = 'dft_mst_asset_selection'
)
BEGIN
    ALTER TABLE dft_mst
    ADD dft_mst_asset_selection VARCHAR(1) NULL;
END





select dft_mst_ww_disp_day,RowID,*  from dft_mst

select dft_mst_ww_disp_day as days from dft_mst where site_cd = 'CPI'

