|
-- zmh
|
|
ALTER TABLE `role_legion`
|
|
ADD COLUMN `advance_awards` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[]' COMMENT '预告领取' AFTER `p_utime`;
|
|
|
|
ALTER TABLE `rush_rank_role`
|
|
ADD COLUMN `value4` int(11) NOT NULL DEFAULT 0 COMMENT '值4' AFTER `value3`,
|
|
ADD COLUMN `value5` int(11) NOT NULL DEFAULT 0 COMMENT '值5' AFTER `value4`;
|
|
|
|
-- ljy
|
|
-- 源能转盘-全服大奖记录
|
|
CREATE TABLE `turntable_lottery_record` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
|
|
`sub_type` smallint(6) NOT NULL COMMENT '活动子类型',
|
|
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '玩家名',
|
|
`goods_id` int(11) NOT NULL COMMENT '物品类型ID',
|
|
`num` smallint(6) NOT NULL COMMENT '数量',
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
INDEX `key`(`sub_type`) USING BTREE
|
|
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '源能转盘抽奖记录' ROW_FORMAT = Dynamic;
|