wordpress
WordPress is an open source blog publishing application powered by PHP and MySQL. http://wordpress.org/
blog mysql wordpress
Favorites 8 Followers
Viewed 3865 times
trunk_6
meta_id
PKBIGINT
meta_key
VARCHAR
meta_value
LONGTEXT
comment_id
FKBIGINT
The comments within WordPress are stored in the wp_comments table.
comment_ID
PKBIGINT
comment_author
TINYTEXT
comment_author_email
VARCHAR
comment_author_url
VARCHAR
comment_author_IP
VARCHAR
comment_date
DATETIME
comment_date_gmt
DATETIME
comment_content
TEXT
comment_karma
INT
comment_approved
VARCHAR
comment_agent
VARCHAR
comment_type
VARCHAR
user_id
FKBIGINT
comment_parent
FKBIGINT
comment_post_ID
FKBIGINT
The wp_links holds information related to the links entered into the Links feature of WordPress.
link_id
PKBIGINT
link_url
VARCHAR
link_name
VARCHAR
link_image
VARCHAR
link_target
VARCHAR
link_description
VARCHAR
link_visible
VARCHAR
link_owner
BIGINT
link_rating
INT
link_updated
DATETIME
link_rel
VARCHAR
link_notes
MEDIUMTEXT
link_rss
VARCHAR
The Options set under the Administration > Settings panel are stored in the wp_options table.
option_id
PKBIGINT
blog_id
INT
option_name
VARCHAR
option_value
LONGTEXT
autoload
VARCHAR
Each post features information called the meta data and it is stored in the wp_postmeta. Some plugins may add their own information to this table.
meta_id
PKBIGINT
meta_key
VARCHAR
meta_value
LONGTEXT
post_id
FKBIGINT
The core of the WordPress data is the posts. It is stored in the wp_posts table.
ID
PKBIGINT
post_date
DATETIME
post_date_gmt
DATETIME
post_content
LONGTEXT
post_title
TEXT
post_excerpt
TEXT
post_status
VARCHAR
comment_status
VARCHAR
ping_status
VARCHAR
post_password
VARCHAR
post_name
VARCHAR
to_ping
TEXT
pinged
TEXT
post_modified
DATETIME
post_modified_gmt
DATETIME
post_content_filtered
TEXT
guid
VARCHAR
menu_order
INT
post_type
VARCHAR
post_mime_type
VARCHAR
comment_count
BIGINT
post_parent
FKBIGINT
post_author
FKBIGINT
Posts are associated with categories and tags from the wp_terms table and this association is maintained in the wp_term_relationships table. The association of links to their respective categories are also kept in this table.
object_id
PFKBIGINT
term_taxonomy_id
PFKBIGINT
term_order
INT
This table describes the taxonomy (category, link, or tag) for the entries in the wp_terms table.
term_taxonomy_id
PKBIGINT
taxonomy
VARCHAR
description
LONGTEXT
parent
BIGINT
count
BIGINT
term_id
FKBIGINT
The categories for both posts and links and the tags for posts are found within the wp_terms table.
term_id
PKBIGINT
name
VARCHAR
slug
VARCHAR
term_group
BIGINT
Each user features information called the meta data and it is stored in wp_usermeta.
umeta_id
PKBIGINT
meta_key
VARCHAR
meta_value
LONGTEXT
user_id
FKBIGINT
The list of users is maintained in table wp_users.
ID
PKBIGINT
user_login
VARCHAR
user_pass
VARCHAR
user_nicename
VARCHAR
user_email
VARCHAR
user_url
VARCHAR
user_registered
DATETIME
user_activation_key
VARCHAR
user_status
INT
display_name
VARCHAR
posted on Mar 10 at 03:49
Looks like someone has reverse engineered the schema but all foreign key relationships are missing.
Just added them back and it looks quite alright.