
#####日期:2020-05-28
#####提交人:向淳宇
#####sql 添加注销账号短信模板ID
#####sql语句
ALTER TABLE `member_setting`
ADD COLUMN `msgCancelID`  varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '注销账号短信' AFTER `msgPhoneID`;
INSERT INTO `member_version` (`version`, `update_time`) VALUES ('3.0.5.1', NOW());

#####日期:2020-06-09
#####提交人:蔡松林
#####sql member表添加字段
#####sql语句
ALTER TABLE `member_member` ADD COLUMN `spareNickName`  varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL  COMMENT '备用昵称';
ALTER TABLE `member_member` ADD COLUMN `spareAvatar`  varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  DEFAULT NULL  COMMENT '备用头像';
INSERT INTO `member_version` (`version`, `update_time`) VALUES ('3.0.5.2', NOW());

