phpBB

Development Wiki

Difference between revisions of "Table.phpbb forums"

From phpBB Development Wiki

(Buy phentermine)
m (rv)
Line 1: Line 1:
<a href="http://bvmagazine.com/messageboard/P-M-Messages/00000053.htm">buy phentermine</a>
+
description goes here
http://bvmagazine.com/messageboard/P-M-Messages/00000053.htm
+
 
[url=http://bvmagazine.com/messageboard/P-M-Messages/00000053.htm]buy phentermine[/url]
+
== Fields ==
 +
{|border="1" cellspacing="0" cellpadding="5"
 +
! 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
 +
| &nbsp;
 +
|-
 +
| forum_name
 +
| varchar(255)
 +
| tbd
 +
| &nbsp;
 +
|-
 +
| forum_desc
 +
| text
 +
| tbd
 +
| &nbsp;
 +
|-
 +
| forum_desc_bitfield
 +
| varchar(255)
 +
| tbd
 +
| &nbsp;
 +
|-
 +
| forum_desc_options
 +
| int(11) unsigned
 +
| tbd
 +
| 7
 +
|-
 +
| forum_desc_uid
 +
| varchar(5)
 +
| tbd
 +
| &nbsp;
 +
|-
 +
| forum_link
 +
| varchar(255)
 +
| tbd
 +
| &nbsp;
 +
|-
 +
| forum_password
 +
| varchar(40)
 +
| tbd
 +
| &nbsp;
 +
|-
 +
| forum_style
 +
| tinyint(4)
 +
| tbd
 +
| 0
 +
|-
 +
| forum_image
 +
| varchar(255)
 +
| tbd
 +
| &nbsp;
 +
|-
 +
| forum_rules
 +
| text
 +
| tbd
 +
| &nbsp;
 +
|-
 +
| forum_rules_link
 +
| varchar(255)
 +
| tbd
 +
| &nbsp;
 +
|-
 +
| forum_rules_bitfield
 +
| varchar(255)
 +
| tbd
 +
| &nbsp;
 +
|-
 +
| forum_rules_options
 +
| int(11) unsigned
 +
| tbd
 +
| 7
 +
|-
 +
| forum_rules_uid
 +
| varchar(5)
 +
| tbd
 +
| &nbsp;
 +
|-
 +
| 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
 +
| &nbsp;
 +
|-
 +
| forum_last_post_time
 +
| int(11) unsigned
 +
| tbd
 +
| 0
 +
|-
 +
| forum_last_poster_name
 +
| varchar(255)
 +
| tbd
 +
| &nbsp;
 +
|-
 +
| forum_last_poster_colour
 +
| varchar(6)
 +
| tbd
 +
| &nbsp;
 +
|-
 +
| 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 ==
 +
{|border="1" cellspacing="0" cellpadding="5"
 +
! name
 +
! fields
 +
|-
 +
|rowspan="1"| PRIMARY
 +
|forum_id
 +
|-
 +
|rowspan="2"| left_right_id
 +
|left_id
 +
|-
 +
|right_id
 +
|-
 +
|rowspan="1"| forum_lastpost_id
 +
|forum_last_post_id
 +
|}
 +
{{table-stub}}

Revision as of 18:24, 12 March 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) tbd  
forum_desc_options int(11) unsigned tbd 7
forum_desc_uid varchar(5) tbd  
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) tbd  
forum_rules_options int(11) unsigned tbd 7
forum_rules_uid varchar(5) tbd  
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