/**Begin D:\pdm\PDM_UPGRADE\PDM1\ER_table.sql **/
/* 发票信息分录增加"电子客票号","订单类型"字段  wang_kun**/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CHECKINGINVOICE' AND KSQL_COL_NAME ='FTICKETNO') 
 ALTER TABLE T_ER_CHECKINGINVOICE ADD (FTICKETNO VARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CHECKINGINVOICE' AND KSQL_COL_NAME ='FORDERSTATUS') 
 ALTER TABLE T_ER_CHECKINGINVOICE ADD (FORDERSTATUS VARCHAR(50) DEFAULT ' ' NOT NULL );

/**End D:\pdm\PDM_UPGRADE\PDM1\ER_table.sql **/
