phpBB

Development Wiki

Difference between revisions of "Table.phpbb forums"

From phpBB Development Wiki

(Fields)
(Fields)
Line 30: Line 30:
 
| forum_parents
 
| forum_parents
 
| mediumtext
 
| mediumtext
| Holds an serialized array of other forums  
+
| Holds an serialized array of parent forums name  
name and id's, used for generating forum navigation.
+
and id's, used for generating forum navigation.
 
|  
 
|  
 
|-
 
|-

Revision as of 20:10, 14 May 2008

description goes here

Fields

column type (MySQL) content default
forum_id mediumint(8) unsigned primary key auto_increment
parent_id mediumint(8) unsigned tbd 0
left_id mediumint(8) unsigned tbd 0
right_id mediumint(8) unsigned tbd 0
forum_parents mediumtext Holds an serialized array of parent forums name

and id's, 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) tbd 0
forum_status tinyint(4) tbd 0
forum_posts mediumint(8) unsigned tbd 0
forum_topics mediumint(8) unsigned tbd 0
forum_topics_real mediumint(8) unsigned tbd 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