customer / shanghai-railway-web

2.1.0.sql 688 Bytes
1 2 3 4 5 6 7 
ALTER  TABLE railway.`RW_USER`
ADD COLUMN `IS_WEEK_STATUS` BIGINT(50)  DEFAULT 0 COMMENT '上次护行周一日期' AFTER `ESCORT_TIME`,
ADD COLUMN `WEEK_ESCORT_COUNT` BIGINT(50)  DEFAULT 0 COMMENT '护航次数(本周)' AFTER `IS_WEEK_STATUS`,
ADD COLUMN `WEEK_ESCORT_TIME` BIGINT(50)  DEFAULT 0 COMMENT '护航时间(本周)' AFTER `WEEK_ESCORT_COUNT`,
ADD COLUMN `IS_MONTH_STATUS` BIGINT(50)  DEFAULT 0 COMMENT '上次护行1号日期' AFTER `WEEK_ESCORT_TIME`,
ADD COLUMN `MONTH_ESCORT_COUNT` BIGINT(50)  DEFAULT 0 COMMENT '护航次数(本月)' AFTER `WEEK_ESCORT_TIME`,
ADD COLUMN `MONTH_ESCORT_TIME` BIGINT(50)  DEFAULT 0 COMMENT '护航时间(本月)' AFTER `MONTH_ESCORT_COUNT`;