phpBB

Development Wiki

Difference between revisions of "Table.phpbb forums"

From phpBB Development Wiki

m (rv)
(link to Parsing text)
Line 45: Line 45:
 
| forum_desc_bitfield
 
| forum_desc_bitfield
 
| varchar(255)
 
| varchar(255)
| tbd
+
| see [[Parsing text]]
 
|  
 
|  
 
|-
 
|-
 
| forum_desc_options
 
| forum_desc_options
 
| int(11) unsigned
 
| int(11) unsigned
| tbd
+
| see [[Parsing text]]
 
| 7
 
| 7
 
|-
 
|-
 
| forum_desc_uid
 
| forum_desc_uid
 
| varchar(5)
 
| varchar(5)
| tbd
+
| see [[Parsing text]]
 
|  
 
|  
 
|-
 
|-
Line 90: Line 90:
 
| forum_rules_bitfield
 
| forum_rules_bitfield
 
| varchar(255)
 
| varchar(255)
| tbd
+
| see [[Parsing text]]
 
|  
 
|  
 
|-
 
|-
 
| forum_rules_options
 
| forum_rules_options
 
| int(11) unsigned
 
| int(11) unsigned
| tbd
+
| see [[Parsing text]]
 
| 7
 
| 7
 
|-
 
|-
 
| forum_rules_uid
 
| forum_rules_uid
 
| varchar(5)
 
| varchar(5)
| tbd
+
| see [[Parsing text]]
 
|  
 
|  
 
|-
 
|-
Line 208: Line 208:
 
| 0
 
| 0
 
|}
 
|}
 
  
 
== Keys ==
 
== Keys ==

Revision as of 17:19, 30 October 2007

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 tbd  
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