phpBB

Development Wiki

Table.phpbb forums

From phpBB Development Wiki

description goes here

Fields

column type (MySQL) content default
forum_id mediumint(8) unsigned primary key auto_increment
parent_id mediumint(8) unsigned the forum_id of the parent forum (or category) 0
left_id mediumint(8) unsigned forum_id of the forum left to the current forum in the binary tree (used e. g. to retrieve the list of all parents very fast to create the forum navigation) 0
right_id mediumint(8) unsigned forum_id of the forum right to the current forum in the binary tree (used e. g. to retrieve the list of all parents very fast to create the forum navigation) 0
forum_parents mediumtext Holds an serialized array of parent forums name, id

and type, used for generating forum navigation.

 
forum_name varchar(255) tbd  
forum_desc text tbd  
forum_desc_bitfield varchar(255) see Parsing text  
forum_desc_options int(11) unsigned see Parsing text 7
forum_desc_uid varchar(5) see Parsing text  
forum_link varchar(255) tbd  
forum_password varchar(40) tbd  
forum_style tinyint(4) tbd 0
forum_image varchar(255) tbd  
forum_rules text tbd  
forum_rules_link varchar(255) tbd  
forum_rules_bitfield varchar(255) see Parsing text  
forum_rules_options int(11) unsigned see Parsing text 7
forum_rules_uid varchar(5) see Parsing text  
forum_topics_per_page tinyint(4) tbd 0
forum_type tinyint(4) category (forum_type = FORUM_CAT = 0) or forum (forum_type = FORUM_POST = 1) or link (forum_type = FORUM_LINK = 2) 0
forum_status tinyint(4) tbd 0
forum_posts mediumint(8) unsigned tbd 0
forum_topics mediumint(8) unsigned Number of topics in a forum. 0
forum_topics_real mediumint(8) unsigned Number of topics in a forum. Includes unapproved topics. 0
forum_last_post_id mediumint(8) unsigned tbd 0
forum_last_poster_id mediumint(8) unsigned tbd 0
forum_last_post_subject varchar(100) tbd  
forum_last_post_time int(11) unsigned tbd 0
forum_last_poster_name varchar(255) tbd  
forum_last_poster_colour varchar(6) tbd  
forum_flags tinyint(4) tbd 32
display_on_index tinyint(1) unsigned tbd 1
enable_indexing tinyint(1) unsigned tbd 1
enable_icons tinyint(1) unsigned tbd 1
enable_prune tinyint(1) unsigned tbd 0
prune_next int(11) unsigned tbd 0
prune_days tinyint(4) tbd 0
prune_viewed tinyint(4) tbd 0
prune_freq tinyint(4) tbd 0

Keys

name fields
PRIMARY forum_id
left_right_id left_id
right_id
forum_lastpost_id forum_last_post_id