#####日期: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());