| 12345678910111213141516171819 |
- USE DCP;
- ALTER TABLE base_league_apply
- ADD COLUMN `sub_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '提交者姓名' AFTER `league_apply_date`,
- ADD COLUMN `sub_account` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '提交者账号' AFTER `sub_name`,
- ADD COLUMN `sub_company` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '提交者企业' AFTER `sub_account`,
- ADD COLUMN `sub_mail` varchar(254) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '提交者邮箱' AFTER `sub_company`,
- ADD COLUMN `sub_phone` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '提交者手机号' AFTER `sub_mail`;
- ALTER TABLE base_member_apply
- ADD COLUMN `member_confirm_file_flag` varchar(255) COMMENT '是否上传会员确认函标识' AFTER `audit_status_dict`;
- ALTER TABLE base_member_apply
- ADD COLUMN `member_confir_file_time` datetime(0) COMMENT '上传会员确认函时间' AFTER `member_confirm_file_flag`;
- ALTER TABLE base_member_apply
- CHANGE COLUMN `member_confir_file_time` `member_confirm_file_time` datetime(0) DEFAULT NULL COMMENT '上传会员确认函时间' AFTER `member_confirm_file_flag`,
- ADD COLUMN `member_confirm_file_pass_flag` varchar(255) COMMENT '会员确认函审核标识' AFTER `member_confirm_file_time`;
- -- 159，161 已执行
|
