dev/2020/2020-022(OK)/2020-022-xpp-001.sql

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 已执行