|
|
- -- 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;
|
