|
|
- -- tyl
- -- 宠物副本 协战宠物&&奖励 选择
- alter table role_dun_pet_choose add column `dun_id` int(11) unsigned NOT NULL DEFAULT '12001' COMMENT '副本Id' after `role_id`;
- alter table role_dun_pet_choose drop PRIMARY KEY;
- alter table role_dun_pet_choose add PRIMARY KEY(`role_id`, `dun_id`, `pet_id`);
-
- CREATE TABLE `role_dun_pet_reward_choose` (
- `role_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '角色id',
- `dun_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '副本id',
- `index` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '奖励选项',
- PRIMARY KEY (`role_id`,`dun_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='宠物副本-奖励选择';
-
- -- 宠物副本昨日榜单
- ALTER TABLE dun_pet_rank ADD COLUMN `old_reach_time` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '昨日积分达成时间' AFTER `old_score`;
|
