/** 加字段 **/

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CTBOTP_CONVERTRULE_S' AND KSQL_COL_NAME ='FSOURCETENANT')
 ALTER TABLE T_CTBOTP_CONVERTRULE_S ADD (FSOURCETENANT VARCHAR(50) DEFAULT ' ' NOT NULL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CTBOTP_CONVERTRULE_S' AND KSQL_COL_NAME ='FSOURCEDATACENTER')
 ALTER TABLE T_CTBOTP_CONVERTRULE_S ADD (FSOURCEDATACENTER VARCHAR(50) DEFAULT ' ' NOT NULL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CTBOTP_CONVERTRULE_S' AND KSQL_COL_NAME ='FSOURCEACCOUNTNUMBER')
 ALTER TABLE T_CTBOTP_CONVERTRULE_S ADD (FSOURCEACCOUNTNUMBER VARCHAR(50) DEFAULT ' ' NOT NULL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CTBOTP_CONVERTRULE_S' AND KSQL_COL_NAME ='FTARGETTENANT')
 ALTER TABLE T_CTBOTP_CONVERTRULE_S ADD (FTARGETTENANT VARCHAR(50) DEFAULT ' ' NOT NULL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CTBOTP_CONVERTRULE_S' AND KSQL_COL_NAME ='FTARGETDATACENTER')
 ALTER TABLE T_CTBOTP_CONVERTRULE_S ADD (FTARGETDATACENTER VARCHAR(50) DEFAULT ' ' NOT NULL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_CTBOTP_CONVERTRULE_S' AND KSQL_COL_NAME ='FTARGETACCOUNTNUMBER')
  ALTER TABLE T_CTBOTP_CONVERTRULE_S ADD (FTARGETACCOUNTNUMBER VARCHAR(50) DEFAULT ' ' NOT NULL );

/** 加字段 **/


