/** 加字段 **/

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CTBOTP_SYNCLOG' AND KSQL_COL_NAME ='FSBILLNO')
 ALTER TABLE T_CTBOTP_SYNCLOG ADD (FSBILLNO VARCHAR(500) DEFAULT ' ' NOT NULL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CTBOTP_SYNCLOG' AND KSQL_COL_NAME ='FTBILLNO')
 ALTER TABLE T_CTBOTP_SYNCLOG ADD (FTBILLNO VARCHAR(500) DEFAULT ' ' NOT NULL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CTBOTP_GSYNCLOG' AND KSQL_COL_NAME ='FSBILLNO')
 ALTER TABLE T_CTBOTP_GSYNCLOG ADD (FSBILLNO VARCHAR(500) DEFAULT ' ' NOT NULL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CTBOTP_GSYNCLOG' AND KSQL_COL_NAME ='FTBILLNO')
 ALTER TABLE T_CTBOTP_GSYNCLOG ADD (FTBILLNO VARCHAR(500) DEFAULT ' ' NOT NULL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CTBOTP_TSYNCLOG' AND KSQL_COL_NAME ='FSBILLNO')
 ALTER TABLE T_CTBOTP_TSYNCLOG ADD (FSBILLNO VARCHAR(500) DEFAULT ' ' NOT NULL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CTBOTP_TSYNCLOG' AND KSQL_COL_NAME ='FTBILLNO')
 ALTER TABLE T_CTBOTP_TSYNCLOG ADD (FTBILLNO VARCHAR(500) DEFAULT ' ' NOT NULL );

/** 加字段 **/


