Nelze vybrat více než 25 témat
Téma musí začínat písmenem nebo číslem, může obsahovat pomlčky („-“) a může být dlouhé až 35 znaků.
15 řádky
874 B
15 řádky
874 B
-- 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`;
|