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

-- liushl
CREATE TABLE `log_player_daily` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '序号',
  `role_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '玩家id',
  `name` varchar(50) NOT NULL DEFAULT '[]' COMMENT '名称',
  `level` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '等级',
  `activity` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '活跃度',
  `daily_task` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '每日跑环进度',
  `guild_task` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '社团跑环进度',
  `time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '时间',
  PRIMARY KEY (`id`),
  KEY role_id(`role_id`),
  KEY time(`time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='玩家每日活跃记录';