tables, fields, types, and descriptions in the WordPress database

Wp_categories: A table to hold information about the classification. 5 fields are included, namely:

cat_id– a unique ID number for each category, a bigint (20) value with an attached property auto_increment.

cat_name– the name of a category as a varchar (55) value.

category_nicename– assigns a memorable name to the taxonomy, known as the Slug, which is a varchar (200) value.

category_description– a detailed description of a category, Longtext type value.

The category_parent– classification is an int (4) value, corresponding to the cat_id in the current table, that is, the wp_categories.cat_id. When there is no parent classification, this value is 0.

Wp_comments: A table for saving comment information. 15 fields are included, respectively:

comment_id– the unique ID number of each comment, which is a bigint (20) value. Auto_increment with attached properties.

comment_post_id– the ID number of the article corresponding to each comment, an int (11) value, equivalent to Wp_posts.id.

comment_author– the reviewer name of each comment, Tinytext value.

comment_author_email– e-mail address of each comment, varchar (100) value.

comment_author_url– the reviewer URL for each comment, varchar (200) value.

comment_author_ip– the IP address of the reviewer for each comment, varchar (100) value.

comment_date– the time that each comment was published, the datetime value (the value that was added to the time zone offset).

comment_date_gmt– the time that each comment was published, the datetime value (the standard GMT).

comment_content– the specific content of each comment, the text value.

comment_karma– unknown, int (11) value, default is 0.

comment_approved– the current status of each comment, for an enumeration value enum (' 0′, ' 1′, ' spam '), 0 for the pending audit, 1 for allow release, and spam for spam comments. The default value is 1.

comment_agent– Client Information for each commented reviewer, varchar (255) value, mainly including its browser and operating system type, version and other information.

comment_type– unknown, varchar (20) value.

comment_parent– a comment, an int (11) value, corresponding to Wp_comment.id, the default is 0, which is no superior comment.

user_id– a comment corresponding to the user ID, only when the user registration will not be generated, int (11) value, corresponding to Wp_users.id. Unregistered user, external reviewer, the value of this ID is 0.

Wp_linkcategories: A table that holds information about the links added in the WP background. Consists of 13 fields:

cat_id– the unique Id,bigint (20) value for each link category, which is a self-increment auto_increment.

cat_name– the name of each link category, Tinytext value.

Auto_toggle-This field contains a more specific attribute. If y, the other links become invisible when new links are added to the category. It is an enum-type value enum (' Y ', ' n '), and the default is N.

show_images– The field is also an enum value enum (' Y ', ' N '), and the default is Y. The user specifies whether the link for the picture is allowed to be displayed in the links category.
show_description– The field specifies the link under the corresponding link category, whether or not to display their description specifically [newline], which is an enumerated value enum (' Y ', ' n '), the default is N, which does not show the description (but is shown by the title property).

show_rating– shows the rank of the link under this category. It's also an enum value enum (' Y ', ' N '), and the default is Y. At this point, you can sort the links under the link category by the link level.

show_updated– Specifies whether the link category has an update that is displayed, enum value enum (' Y ', ' N '), and default to Y.

sort_order– Specifies the sort basis for the links in the link category, with the varchar (64) value. Usually the name of the link (name, that is, wp_links.link_name) or ID (ID, or wp_links.link_id).

sort_desc– Specifies how the link classification is sorted, enum value enum (' Y ', ' n '), default = N, in descending order.

text_before_link– the pre-HTML text of each link under the link category, the varchar (128) value, the default is ' list start tag '.

text_after_link– the link category under each link, the HTML text between the link and the description text (wp_links.link_description), the varchar (128) value, and the default is the ' Wrap label '.

text_after_all– the post HTML text of each link under the link category, the varchar (128) value, which is the ' list end tag ' by default.

list_limit– used to specify what is displayed in a link category (settable?) Number of links, int (11) value, default is-1, that is, the number of links under the link is unlimited.

Wp_links: A table for saving user input to a link in WordPress (via link Manager). A total of 14 fields:

link_id– The unique ID number of each link, the bigint (20) value, and the attached property is auto_increment.

link_url– the URL address of each link, a varchar (255) value, in the form of an address that begins with http://.

link_name– the name of a single link, the varchar (255) value.

The link_image– link can be defined as using a picture link, which is used to save the image's address as a varchar (255) value.

link_target– link Open way, there are three kinds, _blank to open in a new window, _top to open in this window and at the top level, none is not selected, will open in this window. This field is a varchar (25) value.

link_category– the link category for a link, which is an int (11) value. Equivalent to wp_linkcategories.cat_id.

link_description– the descriptive text of the link. The user can choose whether to display under the link or in the Title property. varchar (255) value.

link_visible– whether the link is possible, enumerates the enum (' Y ', ' N ') values, and defaults to Y, which is visible.

link_owner– the creator of a link, an int (11) value, which is 1 by default. (should correspond to is wp_users.id)

link_rating– the level of the link, int (11) value. The default is 0.

link_updated– link is defined, modified by time, datetime value.

link_rel– link to the definition of the relationship, set by the XFN Creator, varchar (255) value.

link_notes– a detailed description of the link, mediumtext value.

link_rss– the RSS address of the link, the varchar (255) value.

Wp_options: Table for saving WordPress related settings, parameters, a total of 11 fields. The most important is the Option_value field, which contains a large amount of important information.

The Id,bigint (20) value of the option_id– option is appended with the Auto_increment property.

blog_id– unknown. May be used in the user's WP version is not important, perhaps a different user's blog to set a value. an int (11) value, which defaults to 0, which is the current blog.

option_name– option name, varchar (64) value.

option_can_override– whether the option can be overridden, updated, enumerated enum (' Y ', ' N ') values, default to Y, can be overridden, updated.

The type of the option_type– option, the function is unknown, the INT (11) value, the default is 1.

option_value– The value of the option, Longtext value, the content of this field is more important. WordPress initialization will be set to about 70 default values, here is not introduced.

option_width– the width of the option (?), the effect is unknown. an int (11) value, which defaults to 20.

The high (?) of the option_height– option has no effect. an int (11) value, which defaults to 8.

option_description– the Tinytext value for a description of an option.

option_admin_level– set the user level for which an option can be manipulated (see my related article for details), int (11) value, default = 1.

The autoload– option is automatically loaded each time, enumerating enum (' Yes ', ' no ') values, by default, yes.

Wp_post2cat: A table that holds the relationship between the article (posts) and the classification (categories), with only three fields:

The rel_id– Associated Id,bigint (20) value, which is a self-increment with a auto_increment attribute.

The Id,bigint (20) value of the post_id– article is equivalent to Wp_posts.id.

The ID of the category_id– category, which is also the bigint (20) value, is equivalent to Wp_categories.id.

The formation of the relationship between the article and the classification is this: REL_ID is an increasing self-increment, which is used to identify each different post. POST_ID can be repeated (when it corresponds to multiple classifications), because it can be rel_id recognized, so there is no confusion. Each post_id can correspond to multiple category_id when a combination of rel_id + post_id can identify a category, so the classification of each article can be different. With this table, you can find out which categories (category) correspond to an article (post) very quickly and efficiently, and vice versa.

Wp_postmeta: A table that holds meta information (META) for an article, four fields:

meta_id– meta-Information id,bigint (20) value with an attached property of auto_increment.

post_id– article Id,bigint (20) value, equivalent to Wp_posts.id.

The meta_key– meta-information keyword, varchar (255) value.

The value of the meta_value– meta information, the text value.

These contents are mainly in the article and page editing page (write Post, write page) "Add A new custom field to this Post (page):" Set. The meta_key corresponds to the item in the drop-down list named "Key", and the value is filled in by the user (sometimes, WP is automatically added, such as the audio media in the article).

Wp_posts: A table that holds information about all your articles (posts) is very important. Generally speaking, it stores the most data. Altogether 21 fields were included.

ID – Unique Id,bigint (20) value for each article, attached property auto_increment.

post_author– the number of the author of each article, the Int (4) value, which should correspond to the wp_users.id.

post_date– the time, datetime value, of each post published. It is the result of the GMT time plus the time zone offset.

post_date_gmt– GMT (Greenwich) TIME, datetime value, when each post is published.

post_content– the specific content of each article, Longtext value. All the content you write in the background post editing page is placed here.

post_title– the title of the article, the text value.

post_category– article belongs to category, int (4) value.

post_excerpt– article Summary, text value.

post_status– the current state of the article, enumerate the values of enum (' Publish ', ' draft ', ' Private ', ' static ', ' object '), publish as published, draft as draft, private for personal content ( not be exposed), static (unknown), object (unknown). The default is publish.

comment_status– comments Set the status of enum enum (' Open ', ' closed ', ' registered_only ') values, open for allow comments, closed for not allowed comments, registered_ Only registered users are able to comment. The default is open, which means everyone can comment.

Ping_status–ping state, enum enum (' Open ', ' closed ') value, open refers to opening Pingback function, closed is off. The default value is open.

post_password– article password, varchar (20) value. The article can be edited for the article to set a password, with this password to re-imposition or modification of the article.

post_name– article name, varchar (200) value. This is usually used to identify a piece of text or a number, or post slug, that identifies an article when generating permalink.
to_ping– forces the article to ping a URI. The text value.

pinged– The article is pingback by the history, text value, for each URI.

post_modified– the last modified time of the article, the datetime value, which is the result of the GMT time plus the time zone offset.

post_modified_gmt– article Last modified GMT time, datetime value.

post_content_filtered– unknown, text value.

post_parent– the Id,int (11) value of the superior article of the article, corresponding to the wp_posts.id. The default is 0, which means there are no superior articles.

Guid– This is an address for each article, the varchar (255) value. The default is this form: http://your.blog.site/?p=1, if you form the permalink function, it will usually be: your WordPress site address + article name.

menu_order– unknown, int (11) value, default is 0.

post_type– article type, unspecified, varchar (100) value. The default is 0.

post_mime_type– unknown. varchar (100) value.

comment_count– comment count, specific use unknown, bigint (20) value.

Wp_usermeta: A table of 4 fields for saving user meta information (META):

umeta_id– meta-Information id,bigint (20) value, attached property auto_increment.

The user_id– meta-information corresponds to the user id,bigint (20) value, which is equivalent to wp_users.id.

meta_key– meta-information keyword, varchar (255) value.

meta_value– the detailed value of the meta-information, longtext value.

Wp_users: A table that holds information about users of WordPress. WP official description of the table in 2.0.2 is somewhat contradictory (said to have 22 fields, but only 11 in the detailed list), so there are only 11 fields to describe:

ID – User unique Id,bigint (20) value with attached property auto_increment.

user_login– User's registered name, varchar (60) value.

user_pass– user password, varchar (64) value, which is an encrypted result. It seems to be using an irreversible MD5 algorithm.

user_nicename– user nickname, varchar (50) value.

user_email– user Email address, varchar (100) value.

user_url– user URL, varchar (100) value.

user_registered– User Registration time, datetime value.

user_level– for grade, int (2) value, can be a number between 0-10, different levels have different operation rights to WP.

user_activation_key– user activation code, unknown. varchar (60) value.

user_status– User State, int (11) value, default is 0.

display_name– to the front desk to display the user name, varchar (250) value.

Through these 10 tables, we can see that the whole WP system involved in the main content includes:

Article (page) and its classification

Links and their classifications

Options, settings

User settings

tables, fields, types, and descriptions in the WordPress database