phpBB

Development Wiki

Table.phpbb topics

From phpBB Development Wiki

Revision as of 20:20, 28 February 2008 by Highway of life (Talk | contribs)

description goes here

Fields

column type (MySQL) content default
topic_id mediumint(8) unsigned primary key auto_increment
forum_id mediumint(8) unsigned

references phpbb_forums.forum_id

0
icon_id mediumint(8) unsigned

references phpbb_icons.icon_id

0
topic_attachment tinyint(1) unsigned 1=at least one post in this topic has attachment
0=no attachments in this topic
0
topic_approved tinyint(1) unsigned tbd 1
topic_reported tinyint(1) unsigned tbd 0
topic_title varchar(100) tbd  
topic_poster mediumint(8) unsigned

references phpbb_users.user_id

0
topic_time int(11) unsigned tbd 0
topic_time_limit int(11) unsigned tbd 0
topic_views mediumint(8) unsigned tbd 0
topic_replies mediumint(8) unsigned the number of approved replies to this topic 0
topic_replies_real mediumint(8) unsigned total replies to this topic (including posts waiting for approval) 0
topic_status tinyint(3) ITEM_UNLOCKED(0), ITEM_LOCKED(1) or ITEM_MOVED(2) 0
topic_type tinyint(3) POST_NORMAL(0), POST_STICKY(1), POST_ANNOUNCE(2) or POST_GLOBAL(3)

note that when topic_type is POST_GLOBAL (global announcement), then forum_id must be 0

0
topic_first_post_id mediumint(8) unsigned

references phpbb_posts.post_id

0
topic_first_poster_name varchar(255) tbd  
topic_first_poster_colour varchar(6) tbd  
topic_last_post_id mediumint(8) unsigned

references phpbb_posts.post_id

0
topic_last_poster_id mediumint(8) unsigned

references phpbb_users.user_id

0
topic_last_poster_name varchar(255) tbd  
topic_last_poster_colour varchar(6) tbd  
topic_last_post_subject varchar(100) tbd  
topic_last_post_time int(11) unsigned unix timestamp 0
topic_last_view_time int(11) unsigned unix timestamp 0
topic_moved_id mediumint(8) unsigned if topic_status is ITEM_MOVED, this field contains the topic id of the real topic 0
topic_bumped tinyint(1) unsigned has this topic been bumped? 1 (yes), 0(no) 0
topic_bumper mediumint(8) unsigned

references phpbb_users.user_id

0
poll_title varchar(100) tbd  
poll_start int(11) unsigned unix timestamp 0
poll_length int(11) unsigned unix timestamp 0
poll_max_options tinyint(4) how many poll options can each user choose 1
poll_last_vote int(11) unsigned unix timestamp 0
poll_vote_change tinyint(1) unsigned are users allowed to change their vote(s)? 1 (yes), 0(no) 0


Keys

name fields
PRIMARY topic_id
forum_id forum_id
forum_id_type forum_id
topic_type
last_post_time topic_last_post_time
topic_approved topic_approved
fid_time_moved forum_id
topic_last_post_time
topic_moved_id