yzySrv/db/21-07/21-07-09.sql

-- 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='进阶-弱进阶皮肤';