bbPress and WordPress MySQL database table reference

bbPress 0.8.3 - 0.9bbPress 1.0, 1.1WordPress 2.3 2.5 2.6 2.7WordPress 2.8 2.9 3.0
  • see wiki


  • Browse wp_commentmeta
    		•


    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_meta

    Field Type Null Default Comments
    meta_id bigint(20) No     
    object_type varchar(16) No  bb_option   
    object_id bigint(20) No  0   
    meta_key varchar(255) Yes  NULL   
    meta_value longtext Yes  NULL   


    Indexes:
    Keyname Type Cardinality Field
    PRIMARY PRIMARY 100  meta_id
    object_type__meta_key INDEX None  object_type
    meta_key
    object_type__object_id__meta_key INDEX None  object_type
    object_id
    meta_key


    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_commentmeta

    Field Type Null Default Comments MIME
    meta_id bigint(20) No       
    comment_id bigint(20) No  0     
    meta_key varchar(255) Yes  NULL     
    meta_value longtext Yes  NULL     


    Indexes:
    Keyname Type Cardinality Field
    PRIMARY PRIMARY 0  meta_id
    comment_id INDEX None  comment_id
    meta_key INDEX None  meta_key


    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


    bb_terms

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


    Indexes:
    Keyname Type Cardinality Field
    PRIMARY PRIMARY 6  term_id
    slug UNIQUE 6  slug
    name INDEX None  name


    bb_term_relationships

    Field Type Null Default Comments
    object_id bigint(20) No  0   
    term_taxonomy_id bigint(20) No  0   
    user_id bigint(20) No  0   
    term_order int(11) No  0   


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


    bb_term_taxonomy

    Field Type Null Default Comments
    term_taxonomy_id bigint(20) No     
    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 6  term_taxonomy_id
    term_id_taxonomy UNIQUE 6  term_id
    taxonomy


    19 users online from in the past 30 minutes. 14 bots 5 guests
    189 views today 3,983 yesterday 9,585 peak. Most at once 20 today 77 yesterday 115 peak.
    1,783 posts in 296 topics over 44 months by 344 of 1,173 members. Latest: juanmanolo, marcosgdf, fil.diesel