{"id":301,"date":"2016-12-15T20:46:32","date_gmt":"2016-12-15T12:46:32","guid":{"rendered":"https:\/\/blog.freesilo.com\/?p=301"},"modified":"2016-12-15T20:46:32","modified_gmt":"2016-12-15T12:46:32","slug":"wordpress-%e6%95%b0%e6%8d%ae%e5%ba%93%e6%8e%a2%e7%a9%b6","status":"publish","type":"post","link":"https:\/\/freesilo.com\/?p=301","title":{"rendered":"WordPress \u6570\u636e\u5e93\u63a2\u7a76"},"content":{"rendered":"<p><a href=\"http:\/\/codex.wordpress.org\/Database_Description\">WordPress\u5b98\u65b9\u8d44\u6599<\/a><\/p>\n<p><a href=\"http:\/\/codex.wordpress.org\/Database_Description#Table:_wp_commentmeta\">wp_commentmeta<\/a> Each <strong>comment<\/strong> features information called the <strong>meta data<\/strong> and it is stored in the <tt>wp_commentmeta<\/tt>.<\/p>\n<p><a href=\"http:\/\/codex.wordpress.org\/Database_Description#Table:_wp_comments\">wp_comments<\/a> The <strong>comments<\/strong> within WordPress are stored in the <tt>wp_comments<\/tt> table.<\/p>\n<p><a href=\"http:\/\/codex.wordpress.org\/Database_Description#Table:_wp_links\">wp_links<\/a> The <tt>wp_links<\/tt> holds information related to the <strong>links<\/strong> entered into the <a title=\"Administration Panels\" href=\"http:\/\/codex.wordpress.org\/Administration_Panels#Links_-_Putting_the_Inter_in_the_Internet\">Links<\/a> feature of WordPress.<\/p>\n<p><a href=\"http:\/\/codex.wordpress.org\/Database_Description#Table:_wp_options\">wp_options<\/a> The <strong><a title=\"Administration Panels\" href=\"http:\/\/codex.wordpress.org\/Administration_Panels#Settings_-_Configuration_Settings\">Options<\/a><\/strong> set under the <strong>Administration &gt; <a title=\"Administration Panels\" href=\"http:\/\/codex.wordpress.org\/Administration_Panels#Settings_-_Configuration_Settings\">Settings<\/a><\/strong> panel are stored in the <tt>wp_options<\/tt> table.<\/p>\n<p><a href=\"http:\/\/codex.wordpress.org\/Database_Description#Table:_wp_postmeta\">wp_postmeta<\/a> Each <strong>post<\/strong> features information called the <strong>meta data<\/strong> and it is stored in the <tt>wp_postmeta<\/tt>. Some plugins may add their own information to this table.<\/p>\n<p><a href=\"http:\/\/codex.wordpress.org\/Database_Description#Table:_wp_posts\">wp_posts<\/a> The core of the WordPress data is the <strong>posts<\/strong>. It is stored in the <tt>wp_posts<\/tt> table.<\/p>\n<p><a href=\"http:\/\/codex.wordpress.org\/Database_Description#Table:_wp_terms\">wp_terms<\/a> The <strong>categories<\/strong> for both posts and links and the <strong>tags<\/strong> for posts are found within the <tt>wp_terms<\/tt> table.<\/p>\n<p><a href=\"http:\/\/codex.wordpress.org\/Database_Description#Table:_wp_term_relationships\">wp_term_relationships<\/a> <strong>Posts<\/strong> 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 <strong>links<\/strong> to their respective categories are also kept in this table.<\/p>\n<p><a href=\"http:\/\/codex.wordpress.org\/Database_Description#Table:_wp_term_taxonomy\">wp_term_taxonomy<\/a> This table describes the taxonomy (<strong>category<\/strong>, <strong>link<\/strong>, or <strong>tag<\/strong>) for the entries in the <tt>wp_terms<\/tt> table.<\/p>\n<p><a href=\"http:\/\/codex.wordpress.org\/Database_Description#Table:_wp_usermeta\">wp_usermeta<\/a> Each <strong>user<\/strong> features information called the <strong>meta data<\/strong> and it is stored in <tt>wp_usermeta<\/tt>.<\/p>\n<p><a href=\"http:\/\/codex.wordpress.org\/Database_Description#Table:_wp_users\">wp_users<\/a> The list of <strong>users<\/strong> is maintained in table <tt>wp_users<\/tt>.<\/p>\n<p>\u53c2\u8003\u8d44\u6599<\/p>\n<pre><a href=\"http:\/\/fairyfish.net\/2007\/08\/11\/wordpress-database-intro\/\"> WordPress \u6570\u636e\u5e93\u63a2\u7a76#1 \u2014 \u4ecb\u7ecd<\/a>\r\n<a href=\"http:\/\/fairyfish.net\/2007\/08\/12\/wordpress-database-wp_posts\/\"> WordPress \u6570\u636e\u5e93\u63a2\u7a76#2 \u2014 wp_posts<\/a>\r\n<a href=\"http:\/\/fairyfish.net\/2007\/08\/14\/wordpress-database-wp_postmeta\/\"> WordPress \u6570\u636e\u5e93\u63a2\u7a76#3 \u2014 wp_postmeta<\/a>\r\n<a href=\"http:\/\/fairyfish.net\/2007\/08\/14\/wordpress-database-wp_users-and-wp_usermeta\/\"> WordPress \u6570\u636e\u5e93\u63a2\u7a76#4 \u2014 wp_users\u548cwp_usermeta<\/a>\r\n<a href=\"http:\/\/fairyfish.net\/2007\/08\/15\/wordpress-database-wp_comments\/\"> WordPress \u6570\u636e\u5e93\u63a2\u7a76#5 \u2014 wp_comments<\/a>\r\n<a href=\"http:\/\/fairyfish.net\/2007\/08\/23\/wordpress-database-wp_options\/\"> WordPress \u6570\u636e\u5e93\u63a2\u7a76#6 \u2014 wp_options<\/a>\r\n<a href=\"http:\/\/fairyfish.net\/2007\/08\/29\/wordpress-database-wp_categories-and-wp_post2cat\/\"> WordPress \u6570\u636e\u5e93\u63a2\u7a76#7 \u2014 wp_categories\u548cwp_post2cat<\/a>\r\n<a href=\"http:\/\/fairyfish.net\/2007\/08\/30\/wordpress-database-wp_links-and-wp_link2cat\/\"> WordPress \u6570\u636e\u5e93\u63a2\u7a76#8 \u2014 wp_links\u548cwp_link2cat<\/a><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>WordPress\u5b98\u65b9\u8d44\u6599 wp_commentmeta Each commen&#8230;<br \/><a class=\"read-more-button\" href=\"https:\/\/freesilo.com\/?p=301\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-301","post","type-post","status-publish","format-standard","hentry","category-wordpress"],"_links":{"self":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/301","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=301"}],"version-history":[{"count":1,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/301\/revisions"}],"predecessor-version":[{"id":302,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/301\/revisions\/302"}],"wp:attachment":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}