/**Begin D:\PDM_UPGRADE\PDM1\CAS_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CAS_EXCHANGEBILL' AND KSQL_COL_NAME IN ('FQUOTATION'))
ALTER TABLE T_CAS_EXCHANGEBILL ADD (FQUOTATION NVARCHAR(30) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CAS_EXCHANGEBILL' AND KSQL_COL_NAME IN ('FEXRATETABLEID'))
ALTER TABLE T_CAS_EXCHANGEBILL ADD (FEXRATETABLEID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CAS_EXCHANGEBILL' AND KSQL_COL_NAME IN ('FEXRATEDATE'))
ALTER TABLE T_CAS_EXCHANGEBILL ADD (FEXRATEDATE DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CAS_EXCHANGEBILL' AND KSQL_COL_NAME IN ('FSALEQUOTATION'))
ALTER TABLE T_CAS_EXCHANGEBILL ADD (FSALEQUOTATION NVARCHAR(30) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CAS_EXCHANGEBILL' AND KSQL_COL_NAME IN ('FOTHERQUOTATION'))
ALTER TABLE T_CAS_EXCHANGEBILL ADD (FOTHERQUOTATION NVARCHAR(30) DEFAULT '0' NOT NULL );

/**End D:\PDM_UPGRADE\PDM1\CAS_table.sql **/
