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


IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_BILL_SETTING' AND KSQL_COL_NAME ='FBIZITEM')
ALTER TABLE T_ER_BILL_SETTING ADD (FBIZITEM BIGINT DEFAULT 0 NOT NULL  );


IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_BILL_SETTING' AND KSQL_COL_NAME ='FPICTUREFIELD')
ALTER TABLE T_ER_BILL_SETTING ADD (FPICTUREFIELD  VARCHAR(255) DEFAULT ' ' NOT NULL );

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

