phpBB

Development Wiki

Table.phpbb topics track

From phpBB Development Wiki

Revision as of 21:16, 16 August 2011 by D lindenberger (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

This table keeps record for visited topics in order to mark them as read or unread. We use the mark_time timestamp in conjunction with last post of topic x's timestamp to know if topic x is read or not.

In order to accurately tell whether a topic is read, one has to also check phpbb_forums_track.

Fields

column type (MySQL) content default comment
user_id mediumint(8) unsigned primary key not null, unique

references phpbb_users.user_id

topic_id mediumint(8) unsigned primary key not null, unique

references phpbb_topics.topic_id

forum_id mediumint(8) unsigned tbd not null

references phpbb_forums.forum_id

mark_time int(11) unsigned tbd 0 Last visit to this topic (timestamp)

Keys

name fields
PRIMARY user_id
topic_id
forum_id forum_id