站长百科 | 数字化技能提升教程 数字化时代生存宝典
首页
数字化百科
电子书
▼
建站程序
开发
服务器
办公软件
开发教程
▼
服务器教程
软件使用教程
运营教程
热门电子书
▼
CSS教程
WordPress教程
导航
程序频道
推广频道
网赚频道
人物频道
网站程序
网页制作
云计算
服务器
CMS
论坛
网店
虚拟主机
cPanel
网址导航
WIKI使用导航
WIKI首页
热点词条
最新资讯
网站程序
站长人物
页面分类
使用帮助
编辑测试
创建条目
网站地图
站长百科导航
站长百科
主机侦探
IDCtalk云说
跨境电商导航
WordPress啦
站长专题
网站推广
网站程序
网站赚钱
虚拟主机
cPanel
网址导航专题
云计算
微博营销
虚拟主机管理系统
开放平台
WIKI程序与应用
美国十大主机
编辑“
WordPress:Database Description/2.0
”
人物百科
|
营销百科
|
网赚百科
|
站长工具
|
网站程序
|
域名主机
|
互联网公司
|
分类索引
跳转至:
导航
、
搜索
警告:
您没有登录。如果您做出任意编辑,您的IP地址将会公开可见。如果您
登录
或
创建
一个账户,您的编辑将归属于您的用户名,且将享受其他好处。
反垃圾检查。
不要
加入这个!
__TOC__ 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 [[WordPress:Glossary#MySQL|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 [[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__ 下面是在标准地安装WordPress2.0.x版本时,创建的数据库表格的大纲和描述。当前,WordPress支持的唯一的数据库是[[WordPress:Glossary#MySQL|MySQL]]3.23.23版本或者更高的版本。 因为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.0 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" | wp_categories || The '''post categories''' for WordPress are found within the <tt>wp_categories</tt> table and they feature five columns. Refer to || [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Manage_-_Change_your_content|Manage]] >> [[WordPress:Administration_Panels#Categories|Categories]] |- valign="top" | wp_comments || The '''comments''' within WordPress are stored in the <tt>wp_comments</tt> table which contains 15 columns. || 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" | wp_linkcategories || The <tt>wp_linkcategories</tt> hold the information related to the '''links''' entered into the [[WordPress:Links_Manager]] feature of WordPress. It has 13 columns. || [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Links_-_Putting_the_Inter_in_the_Internet|Links]] >> [[WordPress:Administration_Panels#Link_Categories|Link Categories]] |- valign="top" | wp_links || The <tt>wp_links</tt> holds information related to the '''links''' entered into the [[WordPress:Links_Manager]] feature of WordPress. It has 14 columns. || [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Links_-_Putting_the_Inter_in_the_Internet|Links]] >> [[WordPress:Administration_Panels#Manage_Links|Manage Links]]<br /> [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Links_-_Putting_the_Inter_in_the_Internet|Links]] >> [[WordPress:Administration_Panels#Add_Link|Add Links]]<br /> [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Links_-_Putting_the_Inter_in_the_Internet|Links]] >> [[WordPress:Administration_Panels#Import_Links|Import Links]] |- valign="top" | 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 and it has 11 columns. || [[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" | 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. || [[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" | 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. || [[WordPress:Administration Panels]] >> [[WordPress:Administration_Panels#Write_-_Make_some_content|Write]] >> [[WordPress: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. || [[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.0 表格 (10)</strong> |- valign="top" | width="6%" | <strong>表格名</strong> || width="15%" | <strong>描述</strong> || width="15%" | <strong>WordPress用户界面的相关区域</strong> |- valign="top" | wp_categories ||可以在<tt>wp_categories</tt> 表格中找到'''文章类别''',而且有五个栏。参考 || [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Manage_-_Change_your_content|管理]] >> [[WordPress:Administration_Panels#Categories|类别]] |- valign="top" | wp_comments || WordPress中的评论,处在在 <tt>wp_comments</tt>表格,包含有15个栏。 || 评论是读者对于文章的评价,而发表的。评论是由管理员通过 by administrator via [[WordPress:Administration Panels|管理面板]]管理的 >> [[WordPress:Administration_Panels#Manage_-_Change_your_content|Manage]] >> [[WordPress:Administration_Panels#Comments|评论]] |- valign="top" | wp_linkcategories || <tt>wp_linkcategories</tt> 拥有输入在WordPress[[WordPress:Links_Manager| Links_Manager]]中的'''链接''' 的相关信息。拥有13栏。|| [[WordPress:Administration Panel|管理面板]] >> [[WordPress:Administration_Panels#Links_-_Putting_the_Inter_in_the_Internet|链接]] >> [[WordPress:Administration_Panels#Link_Categories|链接类别]] |- valign="top" <tt>wp_links</tt>拥有输入在WordPress[[WordPress:Links_Manager| Links_Manager]]中的'''链接''' 的相关信息。 拥有13栏。 || [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Links_-_Putting_the_Inter_in_the_Internet|链接]] >> [[WordPress:Administration_Panels#Manage_Links|管理链接]]<br /> [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Links_-_Putting_the_Inter_in_the_Internet|链接]] >> [[WordPress:Administration_Panels#Add_Link|Add Links|添加链接]]<br /> [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Links_-_Putting_the_Inter_in_the_Internet|Links|链接]] >> [[WordPress:Administration_Panels#Import_Links|Import Links|导入链接]] |- valign="top" | wp_options || The '''[[WordPress:Administration_Panels#Options_-_Configuration_Settings|选项]]'''设置在'''管理 > [[WordPress:Administration_Panels#Options_-_Configuration_Settings|选项]]''' 面板,这个面板储存在<tt>wp_options</tt>表格,拥有11栏。 || [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Links_-_Putting_the_Inter_in_the_Internet|链接]] >> [[WordPress:Administration_Panels#Manage_Links|管理链接]]<br /> [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Links_-_Putting_the_Inter_in_the_Internet|链接]] >> || [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Links_-_Putting_the_Inter_in_the_Internet|链接]] >> [[WordPress:Administration_Panels#Import_Links|Import Links|导入链接]] |- valign="top" | wp_post2cat || Each post in the <tt>wp_posts</tt>表格中的每篇文章都与 <tt>wp_categories</tt>表格中的某个类别相联系 而且这种联系保存在 <tt>wp_post2cat</tt>表格中,这个表格有13栏。|| [[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" | wp_postmeta || 每篇'''文章'''都有称为 '''meta data''' 信息,而且这个信息储存在<tt>wp_postmeta</tt> 表格中,这个表格拥有14栏。 || |- valign="top" | wp_posts || WordPress数据的核心是'''文章'''。文章储存在<tt>wp_posts</tt>表格中,这个表格拥有21栏。 || [[WordPress:Administration Panels|管理面板]] >> [[WordPress:Administration_Panels#Write_-_Make_some_content|写]] >> [[WordPress:Administration_Panels#Write_Post|写文章]] |- valign="top" | wp_usermeta || 每个'''用户''' 拥有称为the '''meta data''' 的信息,而且这个信息储存在<tt>wp_usermeta</tt>,有4栏。 || |- valign="top" | height="55" | wp_users ||用户列表保存在表格中。.<tt>wp_users, </tt>有22 栏。 || [[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. ==Table: wp_categories== = 表格详细信息= 这个部分是标准安装WordPress时,每个表格中创建的特别的栏。 ==表格: 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.cat_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||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) {| 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)|| || || || {| 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|| |} ==表格: 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_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|| |} ==表格: 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)|| || || || |} ==表格: 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_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.cat_ID |} ==表格: 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')|| ||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|| |} ==表格: 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|| |} ==表格: 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)|| || || || |} |}
摘要:
请注意,您对站长百科的所有贡献都可能被其他贡献者编辑,修改或删除。如果您不希望您的文字被任意修改和再散布,请不要提交。
您同时也要向我们保证您所提交的内容是您自己所作,或得自一个不受版权保护或相似自由的来源(参阅
Wordpress-mediawiki:版权
的细节)。
未经许可,请勿提交受版权保护的作品!
取消
编辑帮助
(在新窗口中打开)