-- 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='任务领取记录';
|