站长百科 | 数字化技能提升教程 数字化时代生存宝典
首页
数字化百科
电子书
建站程序
开发
服务器
办公软件
开发教程
服务器教程
软件使用教程
运营教程
热门电子书
WordPress教程
宝塔面板教程
CSS教程
Shopify教程
导航
程序频道
推广频道
网赚频道
人物频道
网站程序
网页制作
云计算
服务器
CMS
论坛
网店
虚拟主机
cPanel
网址导航
WIKI使用导航
WIKI首页
最新资讯
网站程序
站长人物
页面分类
使用帮助
编辑测试
创建条目
网站地图
站长百科导航
站长百科
主机侦探
IDCtalk云说
跨境电商导航
WordPress啦
站长专题
网站推广
网站程序
网站赚钱
虚拟主机
cPanel
网址导航专题
云计算
微博营销
虚拟主机管理系统
开放平台
WIKI程序与应用
美国十大主机
编辑“
WordPress:Database Description/2.3
”
人物百科
|
营销百科
|
网赚百科
|
站长工具
|
网站程序
|
域名主机
|
互联网公司
|
分类索引
跳转至：
导航
、
搜索
警告：
您没有登录。如果您做出任意编辑，您的IP地址将会公开可见。如果您
登录
或
创建
一个账户，您的编辑将归属于您的用户名，且将享受其他好处。
反垃圾检查。
不要
加入这个！
__TOC__ The following is an outline and description of the database tables created during the standard installation of WordPress at [[WordPress:Version 2.3]]. 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 [[WordPress:Function_Reference/wpdb Class|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. __TOC__ 下面是在标准地安装[[WordPress:Version 2.3|2.3版本]]时，创建的数据库表格的大纲和描述。 因为WordPress自身与这个数据库向联系，你作为一名终端用户，不应该太多地担忧数据库的结构。 如果你正[[WordPress:Writing a Plugin|编写一个插件]]，你可能对怎样直接操作数据库，感兴趣。 WordPress提供了[[WordPress:Function_Reference/wpdb Class|wpdb Class]]，使得操作数据库，这个任务变得简单。 = 表格总览= 这个部分是标准安装WordPress时，创建的表格的总览。 表格后面，有详细的信息，关于每个格是关于什么内容的。 {| width="75%" border="1" |- valign="top" | colspan="3" bordercolor="#FFFFFF" | <strong>WordPress 2.3 Tables (10)</strong> |- valign="top" | width="6%" | <strong>Table Name</strong> || width="15%" | <strong>Description</strong> || width="15%" | <strong>Relevant Area(s) of WordPress User Interface</strong> |- valign="top" | [[WordPress:#Table:_wp_comments|wp_comments]] || The '''comments''' within WordPress are stored in the <tt>wp_comments</tt> table. || Comments are created by readers as responses to posts. Comments are managed by administrator via [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Manage_-_Change_your_content|Manage]] >> [[WordPress:Administration_Panels#Comments|Comments]] |- valign="top" | [[WordPress:#Table:_wp_links|wp_links]] || The <tt>wp_links</tt> holds information related to the '''links''' entered into the [[WordPress:Manage_Blogroll_SubPanel|Blogroll Manager]] feature of WordPress. || [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Blogroll_-_Putting_the_Inter_in_the_Internet|Blogroll]] >> [[WordPress:Administration_Panels#Manage_Blogroll|Manage Blogroll]]<br /> [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Blogroll_-_Putting_the_Inter_in_the_Internet|Blogroll]] >> [[WordPress:Administration_Panels#Add_Link|Add Links]]<br /> [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Blogroll_-_Putting_the_Inter_in_the_Internet|Blogroll]] >> [[WordPress:Administration_Panels#Import_Links|Import Links]] |- valign="top" | [[WordPress:#Table:_wp_options|wp_options]] || The '''[[WordPress:Administration_Panels#Options_-_Configuration_Settings|Options]]''' set under the '''Administration > [[WordPress:Administration_Panels#Options_-_Configuration_Settings|Options]]''' panel are stored in the <tt>wp_options</tt> table. || [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Options_-_Configuration_Settings|Options]] > > [[WordPress:Administration_Panels#General|General]]<br /> [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Options_-_Configuration_Settings|Options]] > >[[WordPress:Administration_Panels#Writing|Writing]]<br /> [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Options_-_Configuration_Settings|Options]] > >[[WordPress:Administration_Panels#Reading|Reading]]<br /> [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Options_-_Configuration_Settings|Options]] > >[[WordPress:Administration_Panels#Discussion|Discussion]]<br /> [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Options_-_Configuration_Settings|Options]] > >[[WordPress:Administration_Panels#Permalinks|Permalinks]]<br /> [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Options_-_Configuration_Settings|Options]] > >[[WordPress:Administration_Panels#Miscellaneous|Miscellaneous]] |- valign="top" | [[WordPress:#Table:_wp_postmeta|wp_postmeta]] || Each '''post''' features information called the '''meta data''' and it is stored in the <tt>wp_postmeta</tt>. Some tag plugins, and other plugins may add their own information to this table. || [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Write_-_Make_some_content|Write]] >> [[WordPress:Administration_Panels#Write_Post|Write a Post]] |- valign="top" | [[WordPress:#Table:_wp_posts|wp_posts]] || The core of the WordPress data is the '''posts'''. It is stored in the <tt>wp_posts</tt> table. || [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Write_-_Make_some_content|Write]] >> [[WordPress:Administration_Panels#Write_Post|Write a Post]] |- valign="top" | [[WordPress:#Table:_wp_terms|wp_terms]] || The '''categories''' for both posts and links and the '''tags''' for posts are found within the <tt>wp_terms</tt> table. || [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Manage_-_Change_your_content|Manage]] >> [[WordPress:Administration_Panels#Categories|Categories]]<br />[[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Write_-_Make_some_content|Write]] >> [[WordPress:Administration_Panels#Write_Post|Write Post]]<br /> [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Manage_-_Change_your_content|Manage]] >> [[WordPress:Administration_Panels#Posts|Posts]] >> [[WordPress:Administration_Panels#Write_Post|Edit]] |- valign="top" | [[WordPress:#Table:_wp_term_relationships|wp_term_relationships]] || '''Posts''' are associated with categories and tags from the <tt>wp_terms</tt> table and this association is maintained in the <tt>wp_term_relationships</tt> table. The association of '''links''' to their respective categories are also kept in this table.|| [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Manage_-_Change_your_content|Manage]] >> [[WordPress:Administration_Panels#Categories|Categories]]<br />[[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Write_-_Make_some_content|Write]] >> [[WordPress:Administration_Panels#Write_Post|Write Post]]<br /> [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Manage_-_Change_your_content|Manage]] >> [[WordPress:Administration_Panels#Posts|Posts]] >> [[WordPress:Administration_Panels#Write_Post|Edit]] |- valign="top" | [[WordPress:#Table:_wp_term_taxonomy|wp_term_taxonomy]] || This table describes the taxonomy ('''category''', '''link''', or '''tag''') for the entries in the <tt>wp_terms</tt> table. || [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Manage_-_Change_your_content|Manage]] >> [[WordPress:Administration_Panels#Categories|Categories]]<br />[[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Write_-_Make_some_content|Write]] >> [[WordPress:Administration_Panels#Write_Post|Write Post]]<br /> [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Manage_-_Change_your_content|Manage]] >> [[WordPress:Administration_Panels#Posts|Posts]] >> [[WordPress:Administration_Panels#Write_Post|Edit]] |- valign="top" | [[WordPress:#Table:_wp_usermeta|wp_usermeta]] || Each '''user''' features information called the '''meta data''' and it is stored in <tt>wp_usermeta</tt>. || [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Users_-_Your_Blogging_Family|Users]] |- valign="top" | height="55" | [[WordPress:#Table:_wp_users|wp_users]] || The list of '''users''' is maintained in table <tt>wp_users</tt>. || [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Users_-_Your_Blogging_Family|Users]] |}<br /><br /> {| width="75%" border="1" |- valign="top" | colspan="3" bordercolor="#FFFFFF" | <strong>WordPress 2.3 表格 (10)</strong> |- valign="top" | width="6%" | <strong>表格名</strong> || width="15%" | <strong>描述</strong> || width="15%" | <strong> WordPress用户界面的相关区域</strong> |- valign="top" | [[WordPress:#Table:_wp_comments|wp_comments]] || WordPress中的'''评论'''储存在<tt>wp_comments</tt>表格中。|| 评论是读者对文章的评价。评论是由管理员通过 [[WordPress:Administration Panels|管理面板]]管理的 >> [[WordPress:Administration_Panels#Manage_-_Change_your_content|管理]] >> [[WordPress:Administration_Panels#Comments|评论]] |- valign="top" | [[WordPress:#Table:_wp_links|wp_links]] || The <tt>wp_links</tt> 拥有输入在 [[WordPress:Manage_Blogroll_SubPanel|链接管理器]]中的 '''链接的''' 相关信息。 || [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Blogroll_-_Putting_the_Inter_in_the_Internet|友情链接]] >> [[WordPress:Administration_Panels#Manage_Blogroll|管理友情链接]]<br /> [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Blogroll_-_Putting_the_Inter_in_the_Internet|友情链接]] >> [[WordPress:Administration_Panels#Add_Link|添加链接]]<br /> [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Blogroll_-_Putting_the_Inter_in_the_Internet|友情链接]] >> [[WordPress:Administration_Panels#Import_Links|导入链接]] |- valign="top" | [[WordPress:#Table:_wp_options|wp_options]] || '''[[WordPress:Administration_Panels#Options_-_Configuration_Settings|选项]]''' 设置在'''管理 > [[WordPress:Administration_Panels#Options_-_Configuration_Settings|选项]]''' 面板的下面，储存在 <tt>wp_options</tt> 表格中。 || [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Options_-_Configuration_Settings|选项]] > > [[WordPress:Administration_Panels#General|总]]<br /> [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Options_-_Configuration_Settings|选项]] > >[[WordPress:Administration_Panels#Writing|写]]<br /> [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Options_-_Configuration_Settings|选项]] > >[[WordPress:Administration_Panels#Reading|阅读]]<br /> [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Options_-_Configuration_Settings|选项]] > >[[WordPress:Administration_Panels#Discussion|讨论]]<br /> [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Options_-_Configuration_Settings|选项]] > >[[WordPress:Administration_Panels#Permalinks|Permalinks]]<br /> [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Options_-_Configuration_Settings|选项]] > >[[WordPress:Administration_Panels#Miscellaneous|Miscellaneous]] |- valign="top" | [[WordPress:#Table:_wp_postmeta|wp_postmeta]] || 每篇 '''文章''' 拥有称为'''meta data''' 的信息，而且这个信息储存在<tt>wp_postmeta</tt>。有的标签插件和其它的插件，可能添加信息到表格中。|| [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Write_-_Make_some_content|写]] >> [[WordPress:Administration_Panels#Write_Post|写文章]] |- valign="top" | [[WordPress:#Table:_wp_posts|wp_posts]] || WordPress数据的核心是 '''文章'''。文章储存在<tt>wp_posts</tt>表格中。 || [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Write_-_Make_some_content|写]] >> [[WordPress:Administration_Panels#Write_Post|写文章]] |- valign="top" | [[WordPress:#Table:_wp_terms|wp_terms]] || 文章和链接的'''类别'''是文章的'''标签'''，在 <tt>wp_terms</tt> 表格中。 || [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Manage_-_Change_your_content|管理]] >> [[WordPress:Administration_Panels#Categories|类别]]<br />[[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Write_-_Make_some_content|写]] >> [[WordPress:Administration_Panels#Write_Post|写文章]]<br /> [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Manage_-_Change_your_content|管理]] >> [[WordPress:Administration_Panels#Posts|文章]] >> [[WordPress:Administration_Panels#Write_Post|编辑]] |- valign="top" | [[WordPress:#Table:_wp_term_relationships|wp_term_relationships]] || '''文章''' 与<tt>wp_terms</tt> 表格中的类别和标签相关，而且这种关联保存在<tt>wp_term_relationships</tt>表格中。 '''链接'''与各自类别的关联，保存在这个表格中。|| [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Manage_-_Change_your_content|管理]] >> [[WordPress:Administration_Panels#Categories|类别]]<br />[[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Write_-_Make_some_content|写]] >> [[WordPress:Administration_Panels#Write_Post|写文章]]<br /> [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Manage_-_Change_your_content|管理]] >> [[WordPress:Administration_Panels#Posts|文章]] >> [[WordPress:Administration_Panels#Write_Post|编辑]] |- valign="top" | [[WordPress:#Table:_wp_term_taxonomy|wp_term_taxonomy]] || 这个表格描述了<tt>wp_terms</tt>表格中的 ('''类别''', '''链接''',或者'''标签''') 的分类。|| [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Manage_-_Change_your_content|管理]] >> [[WordPress:Administration_Panels#Categories|类别]]<br />[[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Write_-_Make_some_content|写]] >> [[WordPress:Administration_Panels#Write_Post|写文章]]<br /> [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Manage_-_Change_your_content|管理]] >> [[WordPress:Administration_Panels#Posts|文章]] >> [[WordPress:Administration_Panels#Write_Post|编辑]] |- valign="top" | [[WordPress:#Table:_wp_usermeta|wp_usermeta]] ||每个'''用户''' 拥有称为'''meta data''' 的信息，而且这个信息储存在<tt>wp_usermeta</tt>。 || [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Users_-_Your_Blogging_Family|用户] |- valign="top" | height="55" | [[WordPress:#Table:_wp_users|wp_users]] || '''用户''' 列表储存在表格<tt>wp_users</tt>。|| [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Users_-_Your_Blogging_Family|用户]] |}<br /><br /> =Table Details= The following are the specific fields in each of the tables created during the standard WordPress installation. = 表格详细信息= 这个部分是标准安装WordPress时，每个表格中创建的特别的栏。 ==Table: wp_comments== {| table width="90%" border=1 !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_links== {| table width="90%" border=1 !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_categories.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== {| table width="90%" border=1 !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_postmeta== {| table width="90%" border=1 !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== {| table width="90%" border=1 !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','inherit','future')|| ||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(20)|| || ||post|| |- |post_mime_type||varchar(100)|| || || || |- |comment_count||bigint(20)|| || ||0|| |} ==Table: wp_terms== {| table width="90%" border=1 !Field!!Type!!Null!!Key!!Default!!Extra |- |term_id||bigint(20)|| ||PRI|| ||auto_increment |- |name||varchar(55)|| || || || |- |slug||varchar(200)|| ||UNI IND|| || |- |term_group||bigint(10)|| || ||0|| |} ==Table: wp_term_relationships== {| table width="90%" border=1 !Field!!Type!!Null!!Key!!Default!!Extra |- |object_id||bigint(20)|| ||PRI Pt1||0|| |- |term_taxonomy_id||bigint(20)|| ||PRI Pt2, IND||0||FK->wp_term_taxonomy.term_taxonomy_id |} ==Table: wp_term_taxonomy== {| table width="90%" border=1 !Field!!Type!!Null!!Key!!Default!!Extra |- |term_taxonomy_id||bigint(20)|| ||PRI|| ||auto_increment |- |term_id||bigint(20)|| ||UNI IND Pt1||0 ||FK->wp_terms.term_id |- |taxonomy||varchar(32)|| ||UNI IND Pt2|| || |- |description||longtext|| || || || |- |parent||bigint(20)|| || ||0|| |- |count||bigint(20)|| || ||0|| |- |} ==Table: wp_usermeta== {| table width="90%" border=1 !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|| |} ==Table: wp_users== {| table width="90%" border=1 !Field!!Type!!Null!!Key!!Default!!Extra |- |ID||bigint(20) unsigned|| ||PRI||NULL||auto_increment |- |user_login||varchar(60)|| ||UNI & IND|| || |- |user_pass||varchar(64)|| || || || |- |user_nicename||varchar(50)|| || || || |- |user_email||varchar(100)|| || || || |- |user_url||varchar(100)|| || || || |- |user_registered||datetime|| || ||0000-00-00 00:00:00|| |- |user_level||int(2) unsigned|| || ||0|| |- |user_activation_key||varchar(60)|| || || || |- |user_status||int(11)|| || ||0|| |- |display_name||varchar(250)|| || || || |} ==表格: wp_comments== {| table width="90%" border=1 !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 |} ==表格: wp_links== {| table width="90%" border=1 !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_categories.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)|| || || || |} ==表格: wp_options== {| table width="90%" border=1 !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|| |} ==表格: wp_postmeta== {| table width="90%" border=1 !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|| |} ==表格: wp_posts== {| table width="90%" border=1 !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','inherit','future')|| ||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(20)|| || ||post|| |- |post_mime_type||varchar(100)|| || || || |- |comment_count||bigint(20)|| || ||0|| |} ==表格: wp_terms== {| table width="90%" border=1 !Field!!Type!!Null!!Key!!Default!!Extra |- |term_id||bigint(20)|| ||PRI|| ||auto_increment |- |name||varchar(55)|| || || || |- |slug||varchar(200)|| ||UNI IND|| || |- |term_group||bigint(10)|| || ||0|| |} ==表格: wp_term_relationships== {| table width="90%" border=1 !Field!!Type!!Null!!Key!!Default!!Extra |- |object_id||bigint(20)|| ||PRI Pt1||0|| |- |term_taxonomy_id||bigint(20)|| ||PRI Pt2, IND||0||FK->wp_term_taxonomy.term_taxonomy_id |} ==表格: wp_term_taxonomy== {| table width="90%" border=1 !Field!!Type!!Null!!Key!!Default!!Extra |- |term_taxonomy_id||bigint(20)|| ||PRI|| ||auto_increment |- |term_id||bigint(20)|| ||UNI IND Pt1||0 ||FK->wp_terms.term_id |- |taxonomy||varchar(32)|| ||UNI IND Pt2|| || |- |description||longtext|| || || || |- |parent||bigint(20)|| || ||0|| |- |count||bigint(20)|| || ||0|| |- |} ==表格: wp_usermeta== {| table width="90%" border=1 !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|| |} ==表格: wp_users== {| table width="90%" border=1 !Field!!Type!!Null!!Key!!Default!!Extra |- |ID||bigint(20) unsigned|| ||PRI||NULL||auto_increment |- |user_login||varchar(60)|| ||UNI & IND|| || |- |user_pass||varchar(64)|| || || || |- |user_nicename||varchar(50)|| || || || |- |user_email||varchar(100)|| || || || |- |user_url||varchar(100)|| || || || |- |user_registered||datetime|| || ||0000-00-00 00:00:00|| |- |user_level||int(2) unsigned|| || ||0|| |- |user_activation_key||varchar(60)|| || || || |- |user_status||int(11)|| || ||0|| |- |display_name||varchar(250)|| || || || |} = Resources = *[http://wpbits.wordpress.com/2007/08/08/a-look-inside-the-wordpress-database/ A look inside the WordPress database] - an indepth dicussion of the database tables by Leonid Mamchenkov. = 资源 = *[http://wpbits.wordpress.com/2007/08/08/a-look-inside-the-wordpress-database/查看WordPress数据库内部] - Leonid Mamchenkov深入讨论WordPress数据库表格。
摘要：
请注意，您对站长百科的所有贡献都可能被其他贡献者编辑，修改或删除。如果您不希望您的文字被任意修改和再散布，请不要提交。
您同时也要向我们保证您所提交的内容是您自己所作，或得自一个不受版权保护或相似自由的来源（参阅
Wordpress-mediawiki:版权
的细节）。
未经许可，请勿提交受版权保护的作品！
取消
编辑帮助
（在新窗口中打开）
