https:\/\/www.bilibili.com\/video\/BV1fT411g7zo<\/a><\/p>\r\n
<\/p>","date":"2022-06-27"},{"id":959,"title":"WordPress\u6570\u636e\u5e93\u8868\u7ed3\u6784\u3001\u5b57\u6bb5\u8be6\u89e3","content":"
\u6570\u636e\u8868\u89e3\u91ca<\/h3>\r\n\r\n- wp_commentmeta\uff1a\u5b58\u50a8 Akismet \u6216\u624b\u5de5\u5ba1\u6838\u7684\u8bc4\u8bba\u662f\u5426\u4e3a\u5783\u573e\u8bc4\u8bba\u7684\u5224\u65ad\u7ed3\u679c\uff1b<\/li>\r\n
- wp_comments\uff1a\u5b58\u50a8\u8bc4\u8bba\u4fe1\u606f\uff0c\u5982\u8bc4\u8bba\u5185\u5bb9\u3001\u8bc4\u8bba\u6240\u5c5e\u6587\u7ae0\u3001\u8bc4\u8bba\u4eba\u6635\u79f0\u3001\u90ae\u7bb1\u3001URL \u7b49\uff1b<\/li>\r\n
- wp_links\uff1a\u5b58\u50a8\u53cb\u60c5\u94fe\u63a5\u4fe1\u606f\uff0c\u5982\u53cb\u94fe\u540d\u79f0\u3001URL\u3001\u6253\u5f00\u65b9\u5f0f\u3001\u63cf\u8ff0\u3001\u662f\u5426\u53ef\u89c1\u7b49\uff1b<\/li>\r\n
- wp_options\uff1a\u5b58\u50a8 WordPress \u7cfb\u7edf\u9ed8\u8ba4\u53ca\u540e\u53f0\u7cfb\u7edf\u9009\u9879\u3001\u63d2\u4ef6\u53ca\u4e3b\u9898\u914d\u7f6e\u4fe1\u606f\uff0c\u5305\u62ec\u7f51\u7ad9\u6807\u9898\u3001\u526f\u6807\u9898\u3001\u5f53\u524d\u4e3b\u9898\u7b49\u7b49\uff1b<\/li>\r\n
- wp_postmeta\uff1a\u5b58\u50a8\u6587\u7ae0\u7684\u4e00\u4e9b\u76f8\u5173\u4fe1\u606f\uff0c\u5982\u6587\u7ae0\u9644\u4ef6\u56fe\u7247\u7684 alt \u4fe1\u606f\u3001\u6587\u7ae0\u6240\u5728\u5206\u7c7b\u7684 URL \u4ee5\u53ca\u6587\u7ae0\u81ea\u5b9a\u4e49\u7684\u81ea\u5b9a\u4e49\u5b57\u6bb5\uff0c\u5176\u4e2d\u53ef\u80fd\u5c31\u6709\u6587\u7ae0\u8bbf\u95ee\u6b21\u6570\u7b49\uff1b<\/li>\r\n
- wp_posts\uff1a\u5b58\u50a8\u6587\u7ae0\u4fe1\u606f\uff0c\u5305\u62ec\u6587\u7ae0\u6807\u9898\u3001\u6b63\u6587\u3001\u6458\u8981\u3001\u4f5c\u8005\u3001\u53d1\u5e03\u65f6\u95f4\u3001\u8bbf\u95ee\u5bc6\u7801\u3001\u8bc4\u8bba\u6570\u3001\u4fee\u6539\u65f6\u95f4\u3001\u6587\u7ae0\u5730\u5740\u7b49\uff1b<\/li>\r\n
- wp_termeta\uff1a\u5b58\u50a8\u5bf9\u83dc\u5355\u5206\u7c7b\u7684\u66f4\u591a\u8bbe\u7f6e\uff0c\u5c5e\u4e8e\u5f00\u53d1\u6027\u529f\u80fd\u5c45\u591a\uff0c\u4f8b\u5982\u5206\u7c7b\u76ee\u5f55\u7684\u7f29\u7565\u56fe\u3001\u989c\u8272\u6807\u8bc6\u7b49\uff1b<\/li>\r\n
- wp_terms\uff1a\u5b58\u50a8\u83dc\u5355\u5206\u7c7b\u3001\u6807\u7b7e\u5206\u7c7b\u540d\u79f0\u53ca URL \u4fe1\u606f\uff1b<\/li>\r\n
- wp_term_relationships\uff1a\u5b58\u50a8\u6587\u7ae0\u548c\u5206\u7c7b\u3001\u6807\u7b7e\u7684\u76f8\u4e92\u5bf9\u5e94\u5173\u7cfb\uff1b<\/li>\r\n
- wp_term_taxonomy\uff1a\u5b58\u50a8\u5206\u7c7b\u548c\u6807\u7b7e\u7684\u63cf\u8ff0\u4fe1\u606f\u3001\u7236\u5b50\u5173\u7cfb\u3001\u6240\u5c5e\u5305\u542b\u7684\u6587\u7ae0\u6570\u7b49\uff1b<\/li>\r\n
- wp_usermeta\uff1a\u5b58\u50a8\u7528\u6237\u7684\u59d3\u540d\u3001\u6635\u79f0\u3001\u6743\u9650\u7b49\u4fe1\u606f\uff1b<\/li>\r\n
- wp_users\uff1a\u5b58\u50a8\u7528\u6237\u540d\u3001\u5bc6\u7801\u3001\u6635\u79f0\u3001\u90ae\u7bb1\u3001\u6ce8\u518c\u65f6\u95f4\u7b49\u4fe1\u606f\uff1b<\/li>\r\n<\/ul>\r\n
wp_commentmeta<\/h3>\r\n\r\n- meta_id\uff1a\u81ea\u589e\u552f\u4e00 ID<\/li>\r\n
- comment_id\uff1a\u8bc4\u8bba ID<\/li>\r\n
- meta_key\uff1a\u952e\u540d<\/li>\r\n
- meta_value\uff1a\u952e\u503c<\/li>\r\n<\/ul>\r\n
wp_comments<\/h3>\r\n\r\n- comment_ID\uff1a\u81ea\u589e\u552f\u4e00 ID<\/li>\r\n
- comment_post_ID\uff1a\u5bf9\u5e94\u6587\u7ae0 ID<\/li>\r\n
- comment_author\uff1a\u8bc4\u8bba\u8005<\/li>\r\n
- comment_author_email\uff1a\u8bc4\u8bba\u8005\u90ae\u7bb1<\/li>\r\n
- comment_author_url\uff1a\u8bc4\u8bba\u8005\u7f51\u5740<\/li>\r\n
- comment_author_IP\uff1a\u8bc4\u8bba\u8005 IP<\/li>\r\n
- comment_date\uff1a\u8bc4\u8bba\u65f6\u95f4<\/li>\r\n
- comment_date_gmt\uff1a\u8bc4\u8bba\u65f6\u95f4\uff08GMT+0 \u65f6\u95f4\uff09<\/li>\r\n
- comment_content\uff1a\u8bc4\u8bba\u6b63\u6587<\/li>\r\n
- comment_karma\uff1a\u672a\u77e5<\/li>\r\n
- comment_approved\uff1a\u8bc4\u8bba\u662f\u5426\u88ab\u6279\u51c6<\/li>\r\n
- comment_agent\uff1a\u8bc4\u8bba\u8005\u7684 USER AGENT<\/li>\r\n
- comment_type\uff1a\u8bc4\u8bba\u7c7b\u578b(pingback\/\u666e\u901a)<\/li>\r\n
- comment_parent\uff1a\u7236\u8bc4\u8bba ID<\/li>\r\n
- user_id\uff1a\u8bc4\u8bba\u8005\u7528\u6237 ID\uff08\u672a\u767b\u5f55\u7528\u6237\u7684\u8bc4\u8bba\u5219\u4e3a\u7a7a<\/li>\r\n<\/ul>\r\n
wp_links<\/h3>\r\n\r\n- link_id\uff1a\u81ea\u589e\u552f\u4e00 ID<\/li>\r\n
- link_url\uff1a\u94fe\u63a5 URL<\/li>\r\n
- link_name\uff1a\u94fe\u63a5\u6807\u9898<\/li>\r\n
- link_image\uff1a\u94fe\u63a5\u56fe\u7247<\/li>\r\n
- link_target\uff1a\u94fe\u63a5\u6253\u5f00\u65b9\u5f0f<\/li>\r\n
- link_description\uff1a\u94fe\u63a5\u63cf\u8ff0<\/li>\r\n
- link_visible\uff1a\u662f\u5426\u53ef\u89c1\uff08Y\/N\uff09<\/li>\r\n
- link_owner\uff1a\u6dfb\u52a0\u8005\u7528\u6237 ID<\/li>\r\n
- link_rating\uff1a\u8bc4\u5206\u7b49\u7ea7<\/li>\r\n
- link_updated\uff1a\u672a\u77e5<\/li>\r\n
- link_rel\uff1aXFN \u5173\u7cfb<\/li>\r\n
- link_notes\uff1aXFN \u6ce8\u91ca<\/li>\r\n
- link_rss\uff1a\u94fe\u63a5 RSS \u5730\u5740<\/li>\r\n<\/ul>\r\n
wp_options<\/h3>\r\n\r\n- option_id\uff1a\u81ea\u589e\u552f\u4e00 ID<\/li>\r\n
- blog_id\uff1a\u535a\u5ba2 ID\uff0c\u7528\u4e8e\u591a\u7528\u6237\u535a\u5ba2\uff0c\u9ed8\u8ba4 0<\/li>\r\n
- option_name\uff1a\u952e\u540d<\/li>\r\n
- option_value\uff1a\u952e\u503c<\/li>\r\n
- autoload\uff1aWordPress \u52a0\u8f7d\u65f6\u81ea\u52a8\u8f7d\u5165\uff08yes\/no\uff09<\/li>\r\n<\/ul>\r\n
wp_postmeta<\/h3>\r\n\r\n- meta_id\uff1a\u81ea\u589e\u552f\u4e00 ID<\/li>\r\n
- post_id\uff1a\u5bf9\u5e94\u6587\u7ae0 ID<\/li>\r\n
- meta_key\uff1a\u952e\u540d<\/li>\r\n
- meta_value\uff1a\u952e\u503c<\/li>\r\n<\/ul>\r\n
wp_posts<\/h3>\r\n\r\n- ID\uff1a\u81ea\u589e\u552f\u4e00 ID<\/li>\r\n
- post_author\uff1a\u5bf9\u5e94\u4f5c\u8005 ID<\/li>\r\n
- post_date\uff1a\u53d1\u5e03\u65f6\u95f4<\/li>\r\n
- post_date_gmt\uff1a\u53d1\u5e03\u65f6\u95f4\uff08GMT+0 \u65f6\u95f4\uff09<\/li>\r\n
- post_content\uff1a\u6b63\u6587<\/li>\r\n
- post_title\uff1a\u6807\u9898<\/li>\r\n
- post_excerpt\uff1a\u6458\u5f55<\/li>\r\n
- post_status\uff1a\u6587\u7ae0\u72b6\u6001\uff08publish\/auto-draft\/inherit \u7b49\uff09<\/li>\r\n
- comment_status\uff1a\u8bc4\u8bba\u72b6\u6001\uff08open\/closed\uff09<\/li>\r\n
- ping_status\uff1aPING \u72b6\u6001\uff08open\/closed\uff09<\/li>\r\n
- post_password\uff1a\u6587\u7ae0\u5bc6\u7801<\/li>\r\n
- post_name\uff1a\u6587\u7ae0\u7f29\u7565\u540d<\/li>\r\n
- to_ping\uff1a\u672a\u77e5<\/li>\r\n
- pinged\uff1a\u5df2\u7ecf PING \u8fc7\u7684\u94fe\u63a5<\/li>\r\n
- post_modified\uff1a\u4fee\u6539\u65f6\u95f4<\/li>\r\n
- post_modified_gmt\uff1a\u4fee\u6539\u65f6\u95f4\uff08GMT+0 \u65f6\u95f4\uff09<\/li>\r\n
- post_content_filtered\uff1a\u672a\u77e5<\/li>\r\n
- post_parent\uff1a\u7236\u6587\u7ae0\uff0c\u4e3b\u8981\u7528\u4e8e PAGE<\/li>\r\n
- guid\uff1a\u552f\u4e00\u6807\u8bc6\u7b26\uff08\u77ed\u94fe\u63a5\uff09<\/li>\r\n
- menu_order\uff1a\u6392\u5e8f ID<\/li>\r\n
- post_type\uff1a\u6587\u7ae0\u7c7b\u578b\uff08post\/page \u7b49\uff09<\/li>\r\n
- post_mime_type\uff1aMIME \u7c7b\u578b<\/li>\r\n
- comment_count\uff1a\u8bc4\u8bba\u603b\u6570<\/li>\r\n<\/ul>\r\n
wp_termeta<\/h3>\r\n\r\n- meta_id\uff1a\u81ea\u589e\u552f\u4e00 ID<\/li>\r\n
- term_id\uff1a\u5206\u7c7b ID<\/li>\r\n
- meta_key\uff1a\u952e\u540d<\/li>\r\n
- meta_value\uff1a\u952e\u503c<\/li>\r\n<\/ul>\r\n
wp_terms<\/h3>\r\n\r\n- term_id\uff1a\u5206\u7c7b ID<\/li>\r\n
- name\uff1a\u5206\u7c7b\u540d<\/li>\r\n
- slug\uff1a\u7f29\u7565\u540d<\/li>\r\n
- term_group\uff1a\u5206\u7ec4<\/li>\r\n<\/ul>\r\n
wp_term_relationships<\/h3>\r\n\r\n- object_id\uff1a\u5bf9\u5e94\u6587\u7ae0 ID\/\u94fe\u63a5 ID<\/li>\r\n
- term_taxonomy_id\uff1a\u5bf9\u5e94\u81ea\u5b9a\u4e49\u5206\u7c7b ID<\/li>\r\n
- term_order\uff1a\u6392\u5e8f<\/li>\r\n<\/ul>\r\n
wp_term_taxonomy<\/h3>\r\n\r\n- term_taxonomy_id\uff1a\u81ea\u5b9a\u4e49\u5206\u7c7b ID<\/li>\r\n
- term_id\uff1a\u5206\u7c7b ID<\/li>\r\n
- taxonomy\uff1a\u5206\u7c7b(category\/post_tag)<\/li>\r\n
- description\uff1a\u5206\u7c7b\u63cf\u8ff0<\/li>\r\n
- parent\uff1a\u6240\u5c5e\u7236\u5206\u7c7b ID<\/li>\r\n
- count\uff1a\u6587\u7ae0\u6570\u7edf\u8ba1<\/li>\r\n<\/ul>\r\n
wp_usermeta<\/h3>\r\n\r\n- umeta_id\uff1a\u81ea\u589e\u552f\u4e00 ID<\/li>\r\n
- user_id\uff1a\u5bf9\u5e94\u7528\u6237 ID<\/li>\r\n
- meta_key\uff1a\u952e\u540d<\/li>\r\n
- meta_value\uff1a\u952e\u503c<\/li>\r\n<\/ul>\r\n
wp_users<\/h3>\r\n\r\n- ID\uff1a\u81ea\u589e\u552f\u4e00 ID<\/li>\r\n
- user_login\uff1a\u767b\u5f55\u540d<\/li>\r\n
- user_pass\uff1a\u5bc6\u7801<\/li>\r\n
- user_nicename\uff1a\u6635\u79f0<\/li>\r\n
- user_email\uff1aEmail<\/li>\r\n
- user_url\uff1a\u7f51\u5740<\/li>\r\n
- user_registered\uff1a\u6ce8\u518c\u65f6\u95f4<\/li>\r\n
- user_activation_key\uff1a\u6fc0\u6d3b\u7801<\/li>\r\n
- user_status\uff1a\u7528\u6237\u72b6\u6001<\/li>\r\n
- display_name\uff1a\u663e\u793a\u540d\u79f0<\/li>\r\n<\/ul>","date":"2022-06-27"},{"id":960,"title":"WordPress\u600e\u4e48\u5f00\u542f\u540e\u53f0\u94fe\u63a5\u7ba1\u7406\u529f\u80fd","content":"
\u5f00\u542f\u65b9\u6cd5\u5f88\u7b80\u5355\uff0c\u53ea\u9700\u8981\u5728\u4f60\u7684\u4e3b\u9898functions.php<\/code>\u6587\u4ef6\u4e2d\u52a0\u5165\u4e00\u53e5\u4ee3\u7801\u5373\u53ef\u5f00\u542f\u8be5\u529f\u80fd<\/p>\r\nadd_filter(<\/span>\u00a0'pre_option_link_manager_enabled'<\/span>,<\/span>\u00a0'__return_true'<\/span>\u00a0)<\/span>;<\/span><\/pre>\r\n <\/p>","date":"2022-06-27"}]