bbPress and WordPress MySQL database table reference

bbPress 0.8.3+WordPress 2.3+


bb_forums

Field Type Attributes Null Default Extra
forum_id int(10)   No    auto_increment 
forum_name varchar(150)   No     
forum_slug varchar(255)   No     
forum_desc text   No     
forum_parent int(10)   No  0   
forum_order int(10)   No  0   
topics bigint(20)   No  0   
posts bigint(20)   No  0   


Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 5  forum_id


bb_posts

Field Type Attributes Null Default Extra
post_id bigint(20)   No    auto_increment 
forum_id int(10)   No  1   
topic_id bigint(20)   No  1   
poster_id int(10)   No  0   
post_text text   No     
post_time datetime   No  0000-00-00 00:00:00   
poster_ip varchar(15)   No     
post_status tinyint(1)   No  0   
post_position bigint(20)   No  0   


Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 113  post_id
topic_time INDEX None  topic_id
post_time
poster_time INDEX None  poster_id
post_time
post_time INDEX None  post_time
post_text FULLTEXT None  post_text


bb_tagged

Field Type Attributes Null Default Extra
tagged_id bigint(20) UNSIGNED No    auto_increment 
tag_id bigint(20) UNSIGNED No  0   
user_id bigint(20) UNSIGNED No  0   
topic_id bigint(20) UNSIGNED No  0   
tagged_on datetime   No  0000-00-00 00:00:00   


Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 58  tagged_id
tag_user_topic UNIQUE 58  tag_id
user_id
topic_id
user_id_index INDEX None  user_id
topic_id_index INDEX None  topic_id


bb_tags

Field Type Attributes Null Default Extra
tag_id bigint(20) UNSIGNED No    auto_increment 
tag varchar(200)   No     
raw_tag varchar(50)   No     
tag_count bigint(20) UNSIGNED No  0   


Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 48  tag_id
name INDEX None  tag


bb_topicmeta

Field Type Attributes Null Default Extra
meta_id bigint(20)   No    auto_increment 
topic_id bigint(20)   No  0   
meta_key varchar(255)   Yes  NULL   
meta_value longtext   Yes  NULL   


Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 87  meta_id
topic_id INDEX None  topic_id
meta_key INDEX None  meta_key


bb_topics

Field Type Attributes Null Default Extra
topic_id bigint(20)   No    auto_increment 
topic_title varchar(100)   No     
topic_slug varchar(255)   No     
topic_poster bigint(20)   No  0   
topic_poster_name varchar(40)   No  Anonymous   
topic_last_poster bigint(20)   No  0   
topic_last_poster_name varchar(40)   No     
topic_start_time datetime   No  0000-00-00 00:00:00   
topic_time datetime   No  0000-00-00 00:00:00   
forum_id int(10)   No  1   
topic_status tinyint(1)   No  0   
topic_open tinyint(1)   No  1   
topic_last_post_id bigint(20)   No  1   
topic_sticky tinyint(1)   No  0   
topic_posts bigint(20)   No  0   
tag_count bigint(20)   No  0   


Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 31  topic_id
forum_time INDEX None  forum_id
topic_time
user_start_time INDEX None  topic_poster
topic_start_time


wp_comments

Field Type Attributes Null Default Extra
comment_ID bigint(20) UNSIGNED No    auto_increment 
comment_post_ID int(11)   No  0   
comment_author tinytext   No     
comment_author_email varchar(100)   No     
comment_author_url varchar(200)   No     
comment_author_IP varchar(100)   No     
comment_date datetime   No  0000-00-00 00:00:00   
comment_date_gmt datetime   No  0000-00-00 00:00:00   
comment_content text   No     
comment_karma int(11)   No  0   
comment_approved enum('0', '1', 'spam')   No  1   
comment_agent varchar(255)   No     
comment_type varchar(20)   No     
comment_parent bigint(20)   No  0   
user_id bigint(20)   No  0   


Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 1  comment_ID
comment_approved INDEX None  comment_approved
comment_post_ID INDEX None  comment_post_ID


wp_links

Field Type Attributes Null Default Extra
link_id bigint(20)   No    auto_increment 
link_url varchar(255)   No     
link_name varchar(255)   No     
link_image varchar(255)   No     
link_target varchar(25)   No     
link_category bigint(20)   No  0   
link_description varchar(255)   No     
link_visible enum('Y', 'N')   No  Y   
link_owner int(11)   No  1   
link_rating int(11)   No  0   
link_updated datetime   No  0000-00-00 00:00:00   
link_rel varchar(255)   No     
link_notes mediumtext   No     
link_rss varchar(255)   No     


Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 8  link_id
link_category INDEX None  link_category
link_visible INDEX None  link_visible


wp_options

Field Type Attributes Null Default Extra
option_id bigint(20)   No    auto_increment 
blog_id int(11)   No  0   
option_name varchar(64)   No     
option_value longtext   No     
autoload enum('yes', 'no')   No  yes   


Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 93  option_id
blog_id
option_name
option_name INDEX None  option_name


wp_postmeta

Field Type Attributes Null Default Extra
meta_id bigint(20)   No    auto_increment 
post_id bigint(20)   No  0   
meta_key varchar(255)   Yes  NULL   
meta_value longtext   Yes  NULL   


Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 7  meta_id
post_id INDEX None  post_id
meta_key INDEX None  meta_key


wp_posts

Field Type Attributes Null Default Extra
ID bigint(20) UNSIGNED No    auto_increment 
post_author bigint(20)   No  0   
post_date datetime   No  0000-00-00 00:00:00   
post_date_gmt datetime   No  0000-00-00 00:00:00   
post_content longtext   No     
post_title text   No     
post_category int(4)   No  0   
post_excerpt text   No     
post_status enum('publish', 'draft', 'private', 'static', 'object', 'attachment', 'inherit', 'future', 'pending')   No  publish   
comment_status enum('open', 'closed', 'registered_only')   No  open   
ping_status enum('open', 'closed')   No  open   
post_password varchar(20)   No     
post_name varchar(200)   No     
to_ping text   No     
pinged text   No     
post_modified datetime   No  0000-00-00 00:00:00   
post_modified_gmt datetime   No  0000-00-00 00:00:00   
post_content_filtered text   No     
post_parent bigint(20)   No  0   
guid varchar(255)   No     
menu_order int(11)   No  0   
post_type varchar(20)   No  post   
post_mime_type varchar(100)   No     
comment_count bigint(20)   No  0   


Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 3  ID
post_name INDEX None  post_name
type_status_date INDEX None  post_type
post_status
post_date
ID


wp_terms

Field Type Attributes Null Default Extra
term_id bigint(20)   No    auto_increment 
name varchar(55)   No     
slug varchar(200)   No     
term_group bigint(10)   No  0   


Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 2  term_id
slug UNIQUE 2  slug


wp_term_relationships

Field Type Attributes Null Default Extra
object_id bigint(20)   No  0   
term_taxonomy_id bigint(20)   No  0   


Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 11  object_id
term_taxonomy_id
term_taxonomy_id INDEX None  term_taxonomy_id


wp_term_taxonomy

Field Type Attributes Null Default Extra
term_taxonomy_id bigint(20)   No    auto_increment 
term_id bigint(20)   No  0   
taxonomy varchar(32)   No     
description longtext   No     
parent bigint(20)   No  0   
count bigint(20)   No  0   


Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 2  term_taxonomy_id
term_id_taxonomy UNIQUE 2  term_id
taxonomy


wp_usermeta (bb_usermeta without integration)

Field Type Attributes Null Default Extra
umeta_id bigint(20)   No    auto_increment 
user_id bigint(20)   No  0   
meta_key varchar(255)   Yes  NULL   
meta_value longtext   Yes  NULL   


Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 720  umeta_id
user_id INDEX 240  user_id
meta_key INDEX 15  meta_key


wp_users (bb_users without integration)

Field Type Attributes Null Default Extra
ID bigint(20) UNSIGNED No    auto_increment 
user_login varchar(60)   No     
user_pass varchar(64)   No     
user_nicename varchar(50)   No     
user_email varchar(100)   No     
user_url varchar(100)   No     
user_registered datetime   No  0000-00-00 00:00:00   
user_status int(11)   No  0   
display_name varchar(250)   No     


Indexes:
Keyname Type Cardinality Field
PRIMARY PRIMARY 237  ID
user_login UNIQUE 237  user_login
user_nicename UNIQUE 237  user_nicename

users1users online from United States [1] in the past 30 minutes.bot1bot. Most at oncerecord1todayrecord1yesterdayrecord64ever.