WordPress:Database Description/2.0
来自站长百科
The following is an outline and description of the database tables created during the standard installation of WordPress V 2.0.x. Currently, the only database supported by WordPress is MySQL version 3.23.23 or greater.
Because WordPress interfaces with this database by itself, you as an end user, shouldn't have to worry much about its structure. If you're WordPress:Writing a Plugin, however, you may be interested in learning how to interface with the database directly. WordPress provides the wpdb Class to make this task easy.
Table Overview[ ]
This section is the overview of all the tables created during the WordPress standard installation. It is followed by specific information of what is in each table.
下面是在标准地安装WordPress2.0.x版本时，创建的数据库表格的大纲和描述。当前，WordPress支持的唯一的数据库是MySQL3.23.23版本或者更高的版本。
因为WordPress自身与这个数据库向联系，你作为一名终端用户，不应该太多地担忧数据库的结构。 如果你正编写一个插件，你可能对怎样直接操作数据库，感兴趣。 WordPress提供了wpdb Class，使得操作数据库，这个任务变得简单。
表格总览[ ]
这个部分是标准安装WordPress时，创建的表格的总览。 表格后面，有详细的信息，关于每个格是关于什么内容的。
| WordPress 2.0 Tables (10) | ||
| Table Name | Description | Relevant Area(s) of WordPress User Interface |
| wp_categories | The post categories for WordPress are found within the wp_categories table and they feature five columns. Refer to | WordPress:Administration Panels >> Manage >> Categories |
| wp_comments | The comments within WordPress are stored in the wp_comments table which contains 15 columns. | Comments are created by readers as responses to posts. Comments are managed by administrator via WordPress:Administration Panels >> Manage >> Comments |
| wp_linkcategories | The wp_linkcategories hold the information related to the links entered into the WordPress:Links_Manager feature of WordPress. It has 13 columns. | WordPress:Administration Panels >> Links >> Link Categories |
| wp_links | The wp_links holds information related to the links entered into the WordPress:Links_Manager feature of WordPress. It has 14 columns. | WordPress:Administration Panels >> Links >> Manage Links WordPress:Administration Panels >> Links >> Add Links WordPress:Administration Panels >> Links >> Import Links |
| wp_options | The Options set under the Administration > Options panel are stored in the wp_options table and it has 11 columns. | WordPress:Administration Panels >> Options > > General WordPress:Administration Panels >> Options > >Writing WordPress:Administration Panels >> Options > >Reading WordPress:Administration Panels >> Options > >Discussion WordPress:Administration Panels >> Options > >Permalinks WordPress:Administration Panels >> Options > >Miscellaneous |
| wp_post2cat | Each post in the wp_posts table is associated with a category from the wp_categories table and this association is maintained in the wp_post2cat table and it has 3 columns. | WordPress:Administration Panels >> Write >> Write Post WordPress:Administration Panels >> Manage >> Posts >> Edit |
| wp_postmeta | Each post features information called the meta data and it is stored in the wp_postmeta which has 4 columns. | |
| wp_posts | The core of the WordPress data is the posts. It is stored in the wp_posts table which has 21 columns. | WordPress:Administration Panels >> Write >> Write a Post |
| wp_usermeta | Each user features information called the meta data and it is stored in wp_usermeta which has 4 columns. | |
| wp_users | The list of users is maintained in table.wp_users, which has 22 columns. | WordPress:Administration Panels >> Users |
管理面板 >> 链接 >> Add Links|添加链接
管理面板 >> Links|链接 >> Import Links|导入链接
| WordPress 2.0 表格 (10) | |||
| 表格名 | 描述 | WordPress用户界面的相关区域 | |
| wp_categories | 可以在wp_categories 表格中找到文章类别，而且有五个栏。参考 | 管理面板 >> 管理 >> 类别 | |
| wp_comments | WordPress中的评论，处在在 wp_comments表格，包含有15个栏。 | 评论是读者对于文章的评价，而发表的。评论是由管理员通过 by administrator via 管理面板管理的 >> Manage >> 评论 | |
| wp_linkcategories | wp_linkcategories 拥有输入在WordPress Links_Manager中的链接 的相关信息。拥有13栏。 | 管理面板 >> 链接 >> 链接类别 | |
| wp_options | The 选项设置在管理 > 选项 面板，这个面板储存在wp_options表格，拥有11栏。 | 管理面板 >> 链接 >> 管理链接 管理面板 >> 链接 >> |
管理面板 >> 链接 >> Import Links|导入链接 |
| wp_post2cat | Each post in the wp_posts表格中的每篇文章都与 wp_categories表格中的某个类别相联系 而且这种联系保存在 wp_post2cat表格中，这个表格有13栏。 | 管理面板 >> 写 >> 写文章 管理面板 >> 管理 >> 文章 >> 编辑 | |
| wp_postmeta | 每篇文章都有称为 meta data 信息，而且这个信息储存在wp_postmeta 表格中，这个表格拥有14栏。 | ||
| wp_posts | WordPress数据的核心是文章。文章储存在wp_posts表格中，这个表格拥有21栏。 | 管理面板 >> 写 >> 写文章 | |
| wp_usermeta | 每个用户 拥有称为the meta data 的信息，而且这个信息储存在wp_usermeta，有4栏。 | ||
| wp_users | 用户列表保存在表格中。.wp_users, 有22 栏。 | 管理面板 >> 用户 | |
Table Details[ ]
The following are the specific fields in each of the tables created during the standard WordPress installation.
Table: wp_categories[ ]
表格详细信息[ ]
这个部分是标准安装WordPress时，每个表格中创建的特别的栏。
表格： wp_categories[ ]
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| cat_ID | bigint(20) | PRI | NULL | auto_increment | |
| cat_name | varchar(55) | ||||
| category_nicename | varchar(200) | IND | |||
| category_description | longtext | ||||
| category_parent | bigint(20) | 0 | FK->wp_categories.cat_ID | ||
| category_count | bigint(20) | 0 |
Table: wp_comments[ ]
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| comment_ID | bigint(20) unsigned | PRI | NULL | auto_increment | |
| comment_post_ID | int(11) | IND | 0 | FK->wp_posts.ID | |
| comment_author | tinytext | ||||
| comment_author_email | varchar(100) | ||||
| comment_author_url | varchar(200) | ||||
| comment_author_IP | varchar(100) | ||||
| comment_date | datetime | 0000-00-00 00:00:00 | |||
| comment_date_gmt | datetime | 0000-00-00 00:00:00 | |||
| comment_content | text | ||||
| comment_karma | int(11) | 0 | |||
| comment_approved | enum('0','1','spam') | IND | 1 | ||
| comment_agent | varchar(255) | ||||
| comment_type | varchar(20) | ||||
| comment_parent | bigint(20) | 0 | FK->wp_comment.ID | ||
| user_id | bigint(20) | 0 | FK->wp_users.ID |
Table: wp_linkcategories[ ]
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| cat_id | bigint(20) | PRI | NULL | auto_increment | |
| cat_name | tinytext | ||||
| auto_toggle | enum('Y','N') | N | |||
| show_images | enum('Y','N') | Y | |||
| show_description | enum('Y','N') | N | |||
| show_rating | enum('Y','N') | Y | |||
| show_updated | enum('Y','N') | Y | |||
| sort_order | varchar(64) | rand | |||
| sort_desc | enum('Y','N') | N | |||
| text_before_link | varchar(128) | <li> | |||
| text_after_link | varchar(128) | <br /> | |||
| text_after_all | varchar(128) | </li> | |||
| list_limit | int(11) | -1 |
Table: wp_links[ ]
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| link_id | bigint(20) | PRI | NULL | auto_increment | |
| link_url | varchar(255) | ||||
| link_name | varchar(255) | ||||
| link_image | varchar(255) | ||||
| link_target | varchar(25) | ||||
| link_category | bigint(20) | IND | 0 | FK->wp_linkcategories.cat_id | |
| link_description | varchar(255) | ||||
| link_visible | enum('Y','N') | IND | Y | ||
| link_owner | int(11) | 1 | |||
| link_rating | int(11) | 0 | |||
| link_updated | datetime | 0000-00-00 00:00:00 | |||
| link_rel | varchar(255) | ||||
| link_notes | mediumtext | ||||
| link_rss | varchar(255) |
Table: wp_options[ ]
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| option_id | bigint(20) | PRI | NULL | auto_increment | |
| blog_id | int(11) | PRI | 0 | ||
| option_name | varchar(64) | PRI&IND | |||
| option_can_override | enum('Y','N') | Y | |||
| option_type | int(11) | 1 | |||
| option_value | longtext | ||||
| option_width | int(11) | 20 | |||
| option_height | int(11) | 8 | |||
| option_description | tinytext | ||||
| option_admin_level | int(11) | 1 | |||
| autoload | enum('yes','no') | yes |
Table: wp_post2cat[ ]
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| rel_id | bigint(20) | PRI | NULL | auto_increment | |
| post_id | bigint(20) | IND Pt1 | 0 | FK->wp_posts.ID | |
| category_id | bigint(20) | IND Pt2 | 0 | FK->wp_categories.cat_ID |
Table: wp_postmeta[ ]
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| meta_id | bigint(20) | PRI | NULL | auto_increment | |
| post_id | bigint(20) | IND | 0 | FK->wp_posts.ID | |
| meta_key | varchar(255) | YES | IND | NULL | |
| meta_value | longtext | YES | NULL |
Table: wp_posts[ ]
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| ID | bigint(20) unsigned | PRI | NULL | auto_increment | |
| post_author | bigint(20) | 0 | FK->wp_users.ID | ||
| post_date | datetime | 0000-00-00 00:00:00 | |||
| post_date_gmt | datetime | 0000-00-00 00:00:00 | |||
| post_content | longtext | ||||
| post_title | text | ||||
| post_category | int(4) | 0 | FK->wp_categories.cat_ID | ||
| post_excerpt | text | ||||
| post_status | enum('publish','draft','private','static','object', 'attachment') | IND | publish | ||
| comment_status | enum('open','closed','registered_only') | open | |||
| ping_status | enum('open','closed') | open | |||
| post_password | varchar(20) | ||||
| post_name | varchar(200) | IND | |||
| to_ping | text | ||||
| pinged | text | ||||
| post_modified | datetime | 0000-00-00 00:00:00 | |||
| post_modified_gmt | datetime | 0000-00-00 00:00:00 | |||
| post_content_filtered | text | ||||
| post_parent | bigint(20) | 0 | FK->wp_posts.ID | ||
| guid | varchar(255) | ||||
| menu_order | int(11) | 0 | |||
| post_type | varchar(100) | ||||
| post_mime_type | varchar(100) | ||||
| comment_count | bigint(20) | 0 |
Table: wp_usermeta[ ]
(Added to WP 2.0)
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| umeta_id | bigint(20) | PRI | NULL | auto_increment | |
| user_id | bigint(20) | '0' | FK->wp_users.ID | ||
| meta_key | varchar(255) | IND | NULL | ||
| meta_value | longtext | IND | NULL |