您最多选择25个主题
主题必须以字母或数字开头，可以包含连字符 (-)，并且长度不得超过35个字符
34 行
1.9 KiB
34 行
1.9 KiB
-- zmh
|
|
-- 补充等级
|
|
ALTER TABLE `legion_director_log`
|
|
ADD COLUMN `lv` int(11) NOT NULL DEFAULT 0 COMMENT '等级' AFTER `career`;
|
|
|
|
-- tyl
|
|
-- 孩子点赞记录增加玩家名称
|
|
ALTER TABLE child_be_voted_log ADD COLUMN `vote_name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '点赞者名字' after `vote_id`;
|
|
|
|
|
|
-- 数据清理
|
|
TRUNCATE TABLE `legion_director_log`;
|
|
|
|
ALTER TABLE `legion_director_log`
|
|
CHANGE COLUMN `picture` `dress_list` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[]' COMMENT '头像框' AFTER `sup_vip`,
|
|
CHANGE COLUMN `picture_ver` `profile_photo_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '玩家头像' AFTER `dress_list`;
|
|
|
|
TRUNCATE TABLE `legion_rank_last`;
|
|
ALTER TABLE `legion_rank_last`
|
|
CHANGE COLUMN `picture` `dress_list` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[]' COMMENT '头像列表' AFTER `sup_vip`,
|
|
CHANGE COLUMN `picture_ver` `profile_photo_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '玩家头像' AFTER `dress_list`,
|
|
ADD COLUMN `lv` int(11) NOT NULL DEFAULT 0 COMMENT '玩家等级' AFTER `turn`;
|
|
|
|
TRUNCATE TABLE `legion_rank_now`;
|
|
ALTER TABLE `legion_rank_now`
|
|
CHANGE COLUMN `picture` `dress_list` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[]' COMMENT '头像列表' AFTER `sup_vip`,
|
|
CHANGE COLUMN `picture_ver` `profile_photo_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '玩家头像' AFTER `dress_list`,
|
|
ADD COLUMN `lv` int(11) NOT NULL DEFAULT 0 COMMENT '玩家等级' AFTER `turn`;
|
|
|
|
TRUNCATE TABLE `legion_rank_week`;
|
|
ALTER TABLE `legion_rank_week`
|
|
CHANGE COLUMN `picture` `dress_list` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[]' COMMENT '头像列表' AFTER `sup_vip`,
|
|
CHANGE COLUMN `picture_ver` `profile_photo_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '玩家头像' AFTER `dress_list`,
|
|
ADD COLUMN `lv` int(11) NOT NULL DEFAULT 0 COMMENT '玩家等级' AFTER `turn`;
|