您最多选择25个主题
主题必须以字母或数字开头，可以包含连字符 (-)，并且长度不得超过35个字符
19 行
1018 B
19 行
1018 B
-- hh
|
|
-- 贵族增加前七天登录礼包
|
|
ALTER TABLE `role_sup_vip`
|
|
ADD COLUMN `login_rewards` varchar(500) NOT NULL DEFAULT '[]' COMMENT '奖励状态' AFTER `update_time`;
|
|
ALTER TABLE `role_sup_vip`
|
|
ADD COLUMN `last_reward_rec` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上次统计的领奖时间' AFTER `login_rewards`;
|
|
|
|
-- tyl
|
|
-- 进阶系统调整
|
|
alter table player_foster add column `lv` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '等级' AFTER `star`;
|
|
|
|
CREATE TABLE `player_sub_foster_skin` (
|
|
`role_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '角色Id',
|
|
`type` smallint(3) unsigned NOT NULL DEFAULT '0' COMMENT '弱进阶类型',
|
|
`skin_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '皮肤Id',
|
|
`star` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '星级',
|
|
`display_star` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '幻化星级',
|
|
PRIMARY KEY (`role_id`,`type`,`skin_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='进阶-弱进阶皮肤';
|