Wordpress 中文
探索
首页
所有页面
社区页
交互式地图
最新博文
页面
最新页面
WordPress的安装过程
为WordPress寻找虚拟主机
使用SVN升级WordPress
First Steps With WordPress
管理留言面板
Introduction to Blogging
FAQ About WordPress
最新博客
分类
Getting Started
Backing Up Your Database
Database Description
FAQ About WordPress
FAQ Installation
FAQ New To WordPress
Importing Content
Podcasting
Troubleshooting
Backing Up Your Database
FAQ
FAQ About WordPress
FAQ Advanced Topics
FAQ Codex
FAQ Developer Documentation
FAQ Installation
社区
社区首页
社区中心
帮助中心
FANDOM
游戏
电影
电视
wiki
探索wiki
社区中心
创建wiki
尚未注册?
注册
登录
登录
注册
Wordpress 中文
145
个页面
探索
首页
所有页面
社区页
交互式地图
最新博文
页面
最新页面
WordPress的安装过程
为WordPress寻找虚拟主机
使用SVN升级WordPress
First Steps With WordPress
管理留言面板
Introduction to Blogging
FAQ About WordPress
最新博客
分类
Getting Started
Backing Up Your Database
Database Description
FAQ About WordPress
FAQ Installation
FAQ New To WordPress
Importing Content
Podcasting
Troubleshooting
Backing Up Your Database
FAQ
FAQ About WordPress
FAQ Advanced Topics
FAQ Codex
FAQ Developer Documentation
FAQ Installation
社区
社区首页
社区中心
帮助中心
不轉換
简体
繁體
簡體中文
disable
澳門繁體
大马简体
disable
正體中文
编辑“
Database Description
”
返回页面
编辑
可视化编辑器
查看历史
讨论 (0)
正在编辑
Database Description
注意:
你尚未登入本站,你的IP位置會被記錄在本頁的修訂歷史頁中。
反垃圾检查。
不要
加入这个!
__TOC__ The following is an outline and description of the database tables created during the standard installation of WordPress V 2.0.3. Currently, the only database supported by WordPress is [[Glossary#MySQL|MySQL]] version 3.23.23 or greater. ''Also note, an extended [[Database_Description20|description of the database for WordPress 2]] is under construction.'' 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 [[Writing a Plugin]], however, you may be interested in learning how to interface with the database directly. WordPress provides the [[Function_Reference/wpdb Class|wpdb Class]] to make this task easy. = Table 概览= 这一章是 WordPress 标准安装过程创建的所有表的一个概述。It is followed by specific information of what is in each table. {| width="75%" border="1" |- valign="top" | colspan="3" bordercolor="#FFFFFF" | <strong>WordPress 2.0 Tables (10)</strong> |- valign="top" | width="6%" | <strong> 表明 </strong> || width="15%" | <strong> 描述 </strong> || width="15%" | <strong> 对应的用户接口部分 </strong> |- valign="top" | wp_categories || WordPress 的文章分类在表 <tt>wp_categories</tt> 中设置. 该表包含5列. Refer to || [[Administration Panels]] >> [[Administration_Panels#Manage_-_Change_your_content|Manage]] >> [[Administration_Panels#Categories|Categories]] |- valign="top" | wp_comments || WordPress 的评论存储在表 <tt>wp_comments</tt> 中. 该表包含 15 列. || 评论是文章的阅读者对文章的回应,它由阅读者创建,由管理员管理. [[Administration Panels]] >> [[Administration_Panels#Manage_-_Change_your_content|Manage]] >> [[Administration_Panels#Comments|Comments]] |- valign="top" | wp_linkcategories || The <tt>wp_linkcategories</tt> hold the information related to the '''links''' entered into the [[Links_Manager]] feature of WordPress. It has 13 columns. || [[Administration Panels]] >> [[Administration_Panels#Links_-_Putting_the_Inter_in_the_Internet|Links]] >> [[Administration_Panels#Link_Categories|Link Categories]] |- valign="top" | wp_links || The <tt>wp_links</tt> holds information related to the '''links''' entered into the [[Links_Manager]] feature of WordPress. It has 14 columns. || [[Administration Panels]] >> [[Administration_Panels#Links_-_Putting_the_Inter_in_the_Internet|Links]] >> [[Administration_Panels#Manage_Links|Manage Links]]<br /> [[Administration Panels]] >> [[Administration_Panels#Links_-_Putting_the_Inter_in_the_Internet|Links]] >> [[Administration_Panels#Add_Link|Add Links]]<br /> [[Administration Panels]] >> [[Administration_Panels#Links_-_Putting_the_Inter_in_the_Internet|Links]] >> [[Administration_Panels#Import_Links|Import Links]] |- valign="top" | wp_options || The '''[[Administration_Panels#Options_-_Configuration_Settings|Options]]''' set under the '''Administration > [[Administration_Panels#Options_-_Configuration_Settings|Options]]''' panel are stored in the <tt>wp_options</tt> table and it has 11 columns. || [[Administration Panels]] >> [[Administration_Panels#Options_-_Configuration_Settings|Options]] > > [[Administration_Panels#General|General]]<br /> [[Administration Panels]] >> [[Administration_Panels#Options_-_Configuration_Settings|Options]] > >[[Administration_Panels#Writing|Writing]]<br /> [[Administration Panels]] >> [[Administration_Panels#Options_-_Configuration_Settings|Options]] > >[[Administration_Panels#Reading|Reading]]<br /> [[Administration Panels]] >> [[Administration_Panels#Options_-_Configuration_Settings|Options]] > >[[Administration_Panels#Discussion|Discussion]]<br /> [[Administration Panels]] >> [[Administration_Panels#Options_-_Configuration_Settings|Options]] > >[[Administration_Panels#Permalinks|Permalinks]]<br /> [[Administration Panels]] >> [[Administration_Panels#Options_-_Configuration_Settings|Options]] > >[[Administration_Panels#Miscellaneous|Miscellaneous]] |- valign="top" | wp_post2cat || Each post in the <tt>wp_posts</tt> table is associated with a category from the <tt>wp_categories</tt> table and this association is maintained in the <tt>wp_post2cat</tt> table and it has 3 columns. || [[Administration Panels]] >> [[Administration_Panels#Write_-_Make_some_content|Write]] >> [[Administration_Panels#Write_Post|Write Post]]<br /> [[Administration Panels]] >> [[Administration_Panels#Manage_-_Change_your_content|Manage]] >> [[Administration_Panels#Posts|Posts]] >> [[Administration_Panels#Write_Post|Edit]] |- valign="top" | wp_postmeta || Each '''post''' features information called the '''meta data''' and it is stored in the <tt>wp_postmeta</tt> which has 4 columns. || |- valign="top" | wp_posts || The core of the WordPress data is the '''posts'''. It is stored in the <tt>wp_posts</tt> table which has 21 columns. || [[Administration Panels]] >> [[Administration_Panels#Write_-_Make_some_content|Write]] >> [[Administration_Panels#Write_Post|Write a Post]] |- valign="top" | wp_usermeta || Each '''user''' features information called the '''meta data''' and it is stored in <tt>wp_usermeta</tt> which has 4 columns. || |- valign="top" | height="55" | wp_users || The list of users is maintained in table.<tt>wp_users, which </tt>has 22 columns. || [[Administration Panels]] >> [[Administration_Panels#Users_-_Your_Blogging_Family|Users]] |}<br /><br /> =Table 细节= The following are the specific fields in each of the tables created during the standard WordPress installation. ==Table: wp_categories== {| table width="90%" border=1 !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== {| 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_linkcategories== {| table width="90%" border=1 !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)|| || ||<nowiki><li></nowiki>|| |- |text_after_link||varchar(128)|| || ||<nowiki><br /></nowiki>|| |- |text_after_all||varchar(128)|| || ||<nowiki></li></nowiki>|| |- |list_limit||int(11)|| || ||-1|| |} ==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_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== {| 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_post2cat== {| table width="90%" border=1 !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.ID |} ==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|| |- |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|| |- |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) {| 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)|| || || || |} [[Category:Getting Started]] [[Category:Advanced Topics]] [[Category:WordPress Development]]
摘要:
请注意在Wordpress 中文上的所有贡献都将依据CC-BY-SA进行发布。
取消
编辑帮助
(在新窗口中打开)
Follow on IG
TikTok
Join Fan Lab