customer / shanghai-railway-web

1.1.0.sql 482 Bytes
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 
ALTER  TABLE railway.`rw_user`
ADD COLUMN `GENDER` VARCHAR(4)  DEFAULT NULL COMMENT '性别' AFTER `COMPANY_ID`,
ADD COLUMN `AGE` VARCHAR(10)  DEFAULT NULL COMMENT '年龄' AFTER `GENDER`
ADD COLUMN `EDUCATION` VARCHAR(50)  DEFAULT NULL COMMENT '学历' AFTER `AGE`,
ADD COLUMN `OCCUPATION` VARCHAR(50)  DEFAULT NULL COMMENT '职业' AFTER `EDUCATION`;

ALTER  TABLE railway.`rw_event`
ADD COLUMN `IS_STATUS` TINYINT(1)  DEFAULT NULL COMMENT '上报状态' AFTER `GA_FLAG`;