-- 用餐申请单表添加字段
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_MEALAPPLICATION_BILL' AND KSQL_COL_NAME IN ('FEXCHANGERATE'))
ALTER TABLE T_ER_MEALAPPLICATION_BILL ADD (FEXCHANGERATE DECIMAL(23,10) DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_MEALAPPLICATION_BILL' AND KSQL_COL_NAME IN ('FTRIPAMOUNT'))
ALTER TABLE T_ER_MEALAPPLICATION_BILL ADD (FTRIPAMOUNT  DECIMAL(23,10) DEFAULT 0 NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_MEALAPPLICATION_BILL' AND KSQL_COL_NAME IN ('FSTDEXPQUOTETYPE'))
ALTER TABLE T_ER_MEALAPPLICATION_BILL ADD (FSTDEXPQUOTETYPE varchar(50) DEFAULT ' ' NOT NULL  );

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