yzySrv/db/20-03/20-03-10.sql

-- tyl
-- 添加玩家身上货币类型-名望券

alter table player_high
add column honour int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '名望券' after `gfame`;


-- hh
drop table log_vip_task;
drop table vip_task_progress;
drop table log_honor_coin;
drop table vip_role_record;
drop table player_vip;
drop table vip_giftbag_state;
drop table diamond_vip_shop_buy_record;



DROP TABLE IF EXISTS `player_liveness`;
CREATE TABLE `player_liveness` (
  `rid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '玩家id',
  `lv` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '等级',
  `exp` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '经验',
  PRIMARY KEY (`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='玩家活跃度';


-- zhaoyu
CREATE TABLE IF NOT EXISTS `arena_season_info` (
  `id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '赛季Id',
  `time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '赛季结算时间戳',
  PRIMARY KEY (`id`) 
) ENGINE = InnoDB CHARACTER SET = utf8 COMMENT = '竞技场赛季相关数据';

CREATE TABLE IF NOT EXISTS `log_arena_season_award` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增Id',
  `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '玩家Id',
  `rank` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排名',
  `time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '时间戳',
  `award` varchar(255) NOT NULL DEFAULT '[]' COMMENT '奖励',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='竞技场赛季结算日志';

CREATE TABLE IF NOT EXISTS `log_arena_season_rank` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增Id',
  `season_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '玩家Id',
  `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '玩家Id',
  `rank` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排名',
  `time` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '时间戳',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='竞技场赛季结算时的排名';