phpBB

Development Wiki

Difference between revisions of "Table.phpbb forums"

From phpBB Development Wiki

(Some for your health)
(Fields)
 
(14 intermediate revisions by 7 users not shown)
Line 1: Line 1:
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/index.html
+
description goes here
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/ultram-online.html
+
 
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/tramadol-ultram.html
+
== Fields ==
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/cheap-ultram.html
+
{|border="1" cellspacing="0" cellpadding="5"
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/order-ultram.html
+
! column
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-ultram-online.html
+
! type (MySQL)
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/effects-side-zocor.html
+
! content
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/zocor.html
+
! default
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/generic-zocor.html
+
|-
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/lipitor-vs-zocor.html
+
| forum_id
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/medicine-zocor.html
+
| mediumint(8) unsigned
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/xenical.html
+
| primary key
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-xenical.html
+
| auto_increment
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/cheap-xenical.html
+
|-
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/xenical-online.html
+
| parent_id
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-xenical-online.html
+
| mediumint(8) unsigned
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/order-xenical.html
+
| the forum_id of the parent forum (or category)
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-soma.html
+
| 0
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-soma-online.html
+
|-
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/cheap-soma.html
+
| left_id
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/soma-online.html
+
| mediumint(8) unsigned
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/soma-carisoprodol.html
+
| 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)
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/order-soma.html
+
| 0
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/generic-soma.html
+
|-
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-cheap-soma.html
+
| right_id
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-cialis-online.html
+
| mediumint(8) unsigned
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-cialis.html
+
| 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)
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/generic-cialis.html
+
| 0
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/online-cialis.html
+
|-
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/order-cialis.html
+
| forum_parents
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/cheap-cialis.html
+
| mediumtext
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/viagra-cialis-levitra.html
+
| Holds an serialized array of parent forums name, id
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-cheap-cialis.html
+
and type, used for generating forum navigation.
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/cheapest-cialis.html
+
|  
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-vicodin.html
+
|-
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/online-vicodin.html
+
| forum_name
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-online-vicodin.html
+
| varchar(255)
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/es-vicodin.html
+
| tbd
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/effects-side-vicodin.html
+
|  
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/order-vicodin.html
+
|-
http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/generic-vicodin.html
+
| forum_desc
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/index.html]index.html.[/url]
+
| text
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/ultram-online.html]ultram online[/url]
+
| tbd
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/tramadol-ultram.html]tramadol ultram[/url]
+
|  
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/cheap-ultram.html]cheap ultram[/url]
+
|-
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/order-ultram.html]order ultram[/url]
+
| forum_desc_bitfield
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-ultram-online.html]buy ultram online[/url]
+
| varchar(255)
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/effects-side-zocor.html]effects side zocor[/url]  
+
| see [[Parsing text]]
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/zocor.html]zocor[/url]  
+
|  
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/generic-zocor.html]generic zocor[/url]
+
|-
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/lipitor-vs-zocor.html]lipitor vs zocor[/url]
+
| forum_desc_options
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/medicine-zocor.html]medicine zocor[/url]
+
| int(11) unsigned
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/xenical.html]xenical[/url]
+
| see [[Parsing text]]
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-xenical.html]buy xenical[/url]  
+
| 7
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/cheap-xenical.html]cheap xenical[/url]  
+
|-
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/xenical-online.html]xenical online[/url]
+
| forum_desc_uid
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-xenical-online.html]buy xenical online[/url]
+
| varchar(5)
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/order-xenical.html]order xenical[/url]
+
| see [[Parsing text]]
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-soma.html]buy soma[/url]
+
|  
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-soma-online.html]buy soma online[/url]  
+
|-
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/cheap-soma.html]cheap soma[/url]  
+
| forum_link
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/soma-online.html]soma online[/url]
+
| varchar(255)
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/soma-carisoprodol.html]soma carisoprodol[/url]
+
| tbd
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/order-soma.html]order soma[/url]
+
|  
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/generic-soma.html]generic soma[/url]
+
|-
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-cheap-soma.html]buy cheap soma[/url]
+
| forum_password
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-cialis-online.html]buy cialis online[/url]
+
| varchar(40)
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-cialis.html]buy cialis[/url]
+
| tbd
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/generic-cialis.html]generic cialis[/url]
+
|  
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/online-cialis.html]online cialis[/url]
+
|-
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/order-cialis.html]order cialis[/url]
+
| forum_style
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/cheap-cialis.html]cheap cialis[/url]
+
| tinyint(4)
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/viagra-cialis-levitra.html]viagra cialis levitra[/url]
+
| tbd
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-cheap-cialis.html]buy cheap cialis[/url]
+
| 0
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/cheapest-cialis.html]cheapest cialis[/url]  
+
|-
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-vicodin.html]buy vicodin[/url]  
+
| forum_image
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/online-vicodin.html]online vicodin[/url]
+
| varchar(255)
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-online-vicodin.html]buy online vicodin[/url]  
+
| tbd
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/es-vicodin.html]es vicodin[/url]  
+
|  
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/effects-side-vicodin.html]effects side vicodin[/url]
+
|-
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/order-vicodin.html]order vicodin[/url]  
+
| forum_rules
[url=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/generic-vicodin.html]generic vicodin[/url]  
+
| text
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/index.html>index.html.</a>
+
| tbd
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/ultram-online.html>ultram online</a>
+
| &nbsp;
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/tramadol-ultram.html>tramadol ultram</a>
+
|-
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/cheap-ultram.html>cheap ultram</a>
+
| forum_rules_link
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/order-ultram.html>order ultram</a>
+
| varchar(255)
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-ultram-online.html>buy ultram online</a>
+
| tbd
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/effects-side-zocor.html>effects side zocor</a>
+
| &nbsp;
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/zocor.html>zocor</a>
+
|-
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/generic-zocor.html>generic zocor</a>
+
| forum_rules_bitfield
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/lipitor-vs-zocor.html>lipitor vs zocor</a>
+
| varchar(255)
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/medicine-zocor.html>medicine zocor</a>
+
| see [[Parsing text]]
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/xenical.html>xenical</a>
+
| &nbsp;
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-xenical.html>buy xenical</a>
+
|-
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/cheap-xenical.html>cheap xenical</a>
+
| forum_rules_options
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/xenical-online.html>xenical online</a>
+
| int(11) unsigned
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-xenical-online.html>buy xenical online</a>
+
| see [[Parsing text]]
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/order-xenical.html>order xenical</a>
+
| 7
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-soma.html>buy soma</a>
+
|-
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-soma-online.html>buy soma online</a>
+
| forum_rules_uid
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/cheap-soma.html>cheap soma</a>
+
| varchar(5)
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/soma-online.html>soma online</a>
+
| see [[Parsing text]]
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/soma-carisoprodol.html>soma carisoprodol</a>
+
| &nbsp;
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/order-soma.html>order soma</a>
+
|-
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/generic-soma.html>generic soma</a>
+
| forum_topics_per_page
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-cheap-soma.html>buy cheap soma</a>
+
| tinyint(4)
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-cialis-online.html>buy cialis online</a>
+
| tbd
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-cialis.html>buy cialis</a>
+
| 0
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/generic-cialis.html>generic cialis</a>
+
|-
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/online-cialis.html>online cialis</a>
+
| forum_type
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/order-cialis.html>order cialis</a>
+
| tinyint(4)
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/cheap-cialis.html>cheap cialis</a>
+
| category (forum_type = FORUM_CAT = 0) or forum (forum_type = FORUM_POST = 1) or link (forum_type = FORUM_LINK = 2)
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/viagra-cialis-levitra.html>viagra cialis levitra</a>
+
| 0
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-cheap-cialis.html>buy cheap cialis</a>
+
|-
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/cheapest-cialis.html>cheapest cialis</a>
+
| forum_status
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-vicodin.html>buy vicodin</a>
+
| tinyint(4)
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/online-vicodin.html>online vicodin</a>
+
| tbd
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/buy-online-vicodin.html>buy online vicodin</a>
+
| 0
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/es-vicodin.html>es vicodin</a>
+
|-
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/effects-side-vicodin.html>effects side vicodin</a>
+
| forum_posts
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/order-vicodin.html>order vicodin</a>
+
| mediumint(8) unsigned
<a href=http://www.beniculturali-patrimoni.it/umbria/ranieri/immagini/new/generic-vicodin.html>generic vicodin</a>
+
| 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
 +
| &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}}
 +
[[Category:Database Tables]]

Latest revision as of 13:32, 7 August 2011

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