IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_INT_EXRATESYNC_ENTRY' AND KSQL_COL_NAME ='FSTARTTIME')
ALTER TABLE T_INT_EXRATESYNC_ENTRY ADD (FSTARTTIME DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_INT_EXRATESYNC_ENTRY' AND KSQL_COL_NAME ='FENDTIME')
ALTER TABLE T_INT_EXRATESYNC_ENTRY ADD (FENDTIME DATETIME );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_INT_EXRATESYNC_ENTRY' AND KSQL_COL_NAME ='FNOTIFYUSER')
ALTER TABLE T_INT_EXRATESYNC_ENTRY ADD (FNOTIFYUSER BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_INT_EXRATESYNC_ENTRY' AND KSQL_COL_NAME ='FTYPE')
ALTER TABLE T_INT_EXRATESYNC_ENTRY ADD (FTYPE VARCHAR(64) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_INT_EXRATESYNC_ENTRY' AND KSQL_COL_NAME ='FSNOTIFYTYPE')
ALTER TABLE T_INT_EXRATESYNC_ENTRY ADD (FSNOTIFYTYPE VARCHAR(200) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_INT_EXRATESYNC_ENTRY' AND KSQL_COL_NAME ='FCRON')
ALTER TABLE T_INT_EXRATESYNC_ENTRY ADD (FCRON VARCHAR(64) DEFAULT ' ' NOT NULL );


IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_INT_CURRENCYEXRULE' AND KSQL_COL_NAME ='FSHOWEXRATESYNCENTRY')
ALTER TABLE T_INT_CURRENCYEXRULE ADD (FSHOWEXRATESYNCENTRY CHAR(1) DEFAULT '0' NOT NULL );
