-- 行程管控添加字段
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_TRIPCONTROL' AND KSQL_COL_NAME IN ('FTRAINDATECTRL'))
ALTER TABLE T_ER_TRIPCONTROL ADD (FTRAINDATECTRL VARCHAR(5) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_TRIPCONTROL' AND KSQL_COL_NAME IN ('FTRAINCITYCTRL'))
ALTER TABLE T_ER_TRIPCONTROL ADD (FTRAINCITYCTRL VARCHAR(5) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_TRIPCONTROL' AND KSQL_COL_NAME IN ('FTRAINROUNDTRIPCTRL'))
ALTER TABLE T_ER_TRIPCONTROL ADD (FTRAINROUNDTRIPCTRL VARCHAR(5) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_TRIPCONTROL' AND KSQL_COL_NAME IN ('FTRAINTRIPPEOPLECTRL'))
ALTER TABLE T_ER_TRIPCONTROL ADD (FTRAINTRIPPEOPLECTRL VARCHAR(5) DEFAULT ' ' NOT NULL );


