/*PRJ-00091455 【金蝶云苍穹】【浙江省交通投资集团有限公司】商旅订单-火车订单需要增加出发城市、到达城市 */
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_TRAINBILL_A' AND KSQL_COL_NAME ='FDEPARTCITY')
ALTER TABLE T_ER_TRAINBILL_A ADD (FDEPARTCITY VARCHAR(255) DEFAULT ' ' NOT NULL );


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

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


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