phpBB

Development Wiki

Difference between revisions of "Table.phpbb topics track"

From phpBB Development Wiki

Line 48: Line 48:
 
|}
 
|}
 
{{table-stub}}
 
{{table-stub}}
 +
[[Category:Database Tables]]

Revision as of 08:13, 13 January 2010

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.

Fields

column type (MySQL) content default comment
user_id mediumint(8) unsigned primary key not null, unique FOREIGN KEY, REFERENCES 'phpbb_users'
topic_id mediumint(8) unsigned primary key not null, unique FOREIGN KEY, REFERENCES 'phpbb_topics'
forum_id mediumint(8) unsigned tbd not null FOREIGN KEY, REFERENCES 'phpbb_forums'
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