yzySrv/db/20-12/20-12-08.sql

-- zmh 新手任务领取
CREATE TABLE `player_newer_task` (
  `rid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '角色id',
  `type` int(11) NOT NULL DEFAULT '0' COMMENT '类型',
  `task_id` int(11) NOT NULL DEFAULT '0' COMMENT '任务',
  `time` int(11) NOT NULL COMMENT '时间',
  PRIMARY KEY (`rid`,`type`,`task_id`),
  KEY `rid` (`rid`),
  KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='任务领取记录';