PhpBB3 Database Structure Overview phpbb forums track

From PHPBB用户手册

Jump to: navigation, search
用户访问版面的时间记录, 用于标记已读和未读话题
CREATE TABLE `phpbb_forums_track` (
  `user_id` mediumint(8) unsigned NOT NULL default '0', //用户ID
  `forum_id` mediumint(8) unsigned NOT NULL default '0', //版面ID
  `mark_time` int(11) unsigned NOT NULL default '0', //标记的时间, 在这个时间之后有更新的话题, 都属于未读
  PRIMARY KEY  (`user_id`,`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;