phpBB

Development Wiki

Difference between revisions of "Table.phpbb topics track"

From phpBB Development Wiki

(expanded info)
(Fields)
Line 12: Line 12:
 
| mediumint(8) unsigned
 
| mediumint(8) unsigned
 
| primary key
 
| primary key
| not null, unique
+
| not null
 
| 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, unique
+
| not null
 
| FOREIGN KEY, REFERENCES '[[Tables/phpbb_topics|phpbb_topics]]'
 
| FOREIGN KEY, REFERENCES '[[Tables/phpbb_topics|phpbb_topics]]'
 
|-
 
|-
Line 24: Line 24:
 
| mediumint(8) unsigned
 
| mediumint(8) unsigned
 
| tbd
 
| tbd
| not null, unique
+
| not null
 
| FOREIGN KEY, REFERENCES '[[Tables/phpbb_forums|phpbb_forums]]'
 
| FOREIGN KEY, REFERENCES '[[Tables/phpbb_forums|phpbb_forums]]'
 
|-
 
|-
Line 33: Line 33:
 
| Last visit to this topic (timestamp)
 
| Last visit to this topic (timestamp)
 
|}
 
|}
 
  
 
== Keys ==
 
== Keys ==

Revision as of 15:35, 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 FOREIGN KEY, REFERENCES 'phpbb_users'
topic_id mediumint(8) unsigned primary key not null 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