customer / shanghai-railway-web

1.0.7.sql 1.99 KB
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 
ALTER  TABLE railway.`RW_EVENT`
ADD COLUMN `APP_EVENT_ID` VARCHAR (50)  DEFAULT NULL COMMENT 'APP事件id' AFTER `ID`,
ADD COLUMN `LINE_ID` VARCHAR (100)  DEFAULT NULL COMMENT '线路号' AFTER `APP_EVENT_ID`,
ADD COLUMN `LINE_NAME` VARCHAR (100)  DEFAULT NULL COMMENT '线路名称' AFTER `LINE_ID`,
ADD COLUMN `CARRIAGE_NUMBER` VARCHAR (100)  DEFAULT NULL COMMENT '车厢号' AFTER `LINE_NAME`,
ADD COLUMN `STATION_ID` VARCHAR (100)  DEFAULT NULL COMMENT '车站号' AFTER `EVENT_LOCATION`,
ADD COLUMN `TITLE` VARCHAR (100)  DEFAULT NULL COMMENT '标题' AFTER `TYPE`,
ADD COLUMN `TYPE1_ID` VARCHAR (100)  DEFAULT NULL COMMENT '类型id1' AFTER `TITLE`,
ADD COLUMN `TYPE2_ID` VARCHAR (100)  DEFAULT NULL COMMENT '类型id2' AFTER `TYPE1_ID`,
ADD COLUMN `TYPE3_ID` VARCHAR (100)  DEFAULT NULL COMMENT '类型id3' AFTER `TYPE2_ID`,
ADD COLUMN `TYPE1_NAME` VARCHAR (100)  DEFAULT NULL COMMENT '类型名1' AFTER `TYPE3_ID`,
ADD COLUMN `TYPE2_NAME` VARCHAR (100)  DEFAULT NULL COMMENT '类型名2' AFTER `TYPE1_NAME`,
ADD COLUMN `TYPE3_NAME` VARCHAR (100)  DEFAULT NULL COMMENT '类型名3' AFTER `TYPE2_NAME`,
ADD COLUMN `GRADE_ID` VARCHAR (100)  DEFAULT NULL COMMENT '紧急ID' AFTER `TYPE3_NAME`,
ADD COLUMN `GRADE_NAME` VARCHAR (100)  DEFAULT NULL COMMENT '紧急名' AFTER `GRADE_ID`,
ADD COLUMN `HAPPEN_TIME` VARCHAR (100)  DEFAULT NULL COMMENT '发生时间' AFTER `GRADE_NAME`,
ADD COLUMN `COMMIT_TIME` VARCHAR (100)  DEFAULT NULL COMMENT '提交时间' AFTER `HAPPEN_TIME`,
ADD COLUMN `NEXT_STATION_ID` VARCHAR (100)  DEFAULT NULL COMMENT '下一车站号' AFTER `STATION`,
ADD COLUMN `GA_FLAG` VARCHAR (100)  DEFAULT NULL COMMENT '照片拍摄时间' AFTER `NEXT_STATION`,
ADD COLUMN `APP_ATTACHEMENT_ADDRESS1` VARCHAR (100)  DEFAULT NULL COMMENT '附件1' AFTER `HANDLE_SUGGESTION`,
ADD COLUMN `APP_ATTACHEMENT_ADDRESS2` VARCHAR (100)  DEFAULT NULL COMMENT '附件2' AFTER `APP_ATTACHEMENT_ADDRESS1`,
ADD COLUMN `APP_ATTACHEMENT_ADDRESS3` VARCHAR (100)  DEFAULT NULL COMMENT '附件3' AFTER `APP_ATTACHEMENT_ADDRESS2`;