phpBB

Development Wiki

Difference between revisions of "Table.phpbb topics track"

From phpBB Development Wiki

(Fields)
(Fields)
Line 12: Line 12:
 
| mediumint(8) unsigned
 
| mediumint(8) unsigned
 
| primary key
 
| primary key
| not null
+
| not null, unique
 
| FOREIGN KEY, REFERENCES '[[Tables/phpbb_users|phpbb_users]]'
 
| FOREIGN KEY, REFERENCES '[[Tables/phpbb_users|phpbb_users]]'
 
|-
 
|-
Line 18: Line 18:
 
| mediumint(8) unsigned
 
| mediumint(8) unsigned
 
| primary key
 
| primary key
| not null
+
| not null, unique
 
| FOREIGN KEY, REFERENCES '[[Tables/phpbb_topics|phpbb_topics]]'
 
| FOREIGN KEY, REFERENCES '[[Tables/phpbb_topics|phpbb_topics]]'
 
|-
 
|-

Revision as of 15:36, 13 September 2009

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