Backend Development
PHP Tutorial
wordpress-4.4.1 Database table structure analysis, wordpress database structure_PHP tutorial
wordpress-4.4.1 Database table structure analysis, wordpress database structure_PHP tutorial
Jul 12, 2016 am 08:55 AM
wordpress-4.4.1 database table structure analysis, wordpress database structure
wordpress-4.4.1.zip installation package
SQL structure:
wp_commentmeta: Article comment additional information table.
<span>CREATE</span> <span>TABLE</span> <span>IF</span> <span>NOT</span> <span>EXISTS</span><span> `wp_commentmeta` ( `meta_id` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span><span> AUTO_INCREMENT, `comment_id` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, `meta_key` </span><span>varchar</span>(<span>255</span>) <span>DEFAULT</span> <span>NULL</span><span>, `meta_value` longtext, </span><span>PRIMARY</span> <span>KEY</span><span> (`meta_id`), </span><span>KEY</span><span> `comment_id` (`comment_id`), </span><span>KEY</span> `meta_key` (`meta_key`(<span>191</span><span>)) ) ENGINE</span><span>=</span>InnoDB <span>DEFAULT</span> CHARSET<span>=</span>utf8 AUTO_INCREMENT<span>=</span><span>1</span> ;
wp_comments: Article comment information table.
comment_ID – The unique ID number of each comment, which is a bigint(20) value. With additional attribute auto_increment.
comment_post_ID – The ID number of the article corresponding to each comment, int (11) value, equivalent to wp_posts.ID.
comment_author – commenter name for each comment, tinytext value.
comment_author_email – The commenter’s email address for each comment, varchar(100) value.
comment_author_url – The commenter URL of each comment, varchar(200) value.
comment_author_IP – The commenter’s IP address for each comment, varchar(100) value.
comment_date – The time when each comment was published, datetime value (the value after adding the time zone offset).
comment_date_gmt – The time when each comment was published, datetime value (standard Greenwich time).
comment_content – ??the specific content of each comment, text value.
comment_karma – unknown, int(11) value, default is 0.
comment_approved – The current status of each comment is an enumeration value enum(’0′,’1′,’spam’), 0 is waiting for review, 1 is allowed to be published, and spam is a spam comment. The default value is 1.
comment_agent – ??The client information of the commenter of each comment, varchar(255) value, mainly including the type, version and other information of the browser and operating system.
comment_type – Type of comment, varchar(20) value.
comment_parent – ??The parent comment of a certain comment, int(11) value, corresponding to wp_comment.ID, the default is 0, that is, there is no parent comment.
user_id – the user ID corresponding to a certain comment, which will only be generated after the user registers. The int (11) value corresponds to wp_users.ID. For unregistered users, i.e. external commenters, the value of this ID is 0.
<span>CREATE</span> <span>TABLE</span> <span>IF</span> <span>NOT</span> <span>EXISTS</span><span> `wp_comments` ( `comment_ID` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span><span> AUTO_INCREMENT, `comment_post_ID` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, `comment_author` tinytext </span><span>NOT</span> <span>NULL</span><span>, `comment_author_email` </span><span>varchar</span>(<span>100</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `comment_author_url` </span><span>varchar</span>(<span>200</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `comment_author_IP` </span><span>varchar</span>(<span>100</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `comment_date` </span><span>datetime</span> <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0000-00-00 00:00:00</span><span>'</span><span>, `comment_date_gmt` </span><span>datetime</span> <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0000-00-00 00:00:00</span><span>'</span><span>, `comment_content` </span><span>text</span> <span>NOT</span> <span>NULL</span><span>, `comment_karma` </span><span>int</span>(<span>11</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, `comment_approved` </span><span>varchar</span>(<span>20</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>1</span><span>'</span><span>, `comment_agent` </span><span>varchar</span>(<span>255</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `comment_type` </span><span>varchar</span>(<span>20</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `comment_parent` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, `</span><span>user_id</span>` <span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, </span><span>PRIMARY</span> <span>KEY</span><span> (`comment_ID`), </span><span>KEY</span><span> `comment_post_ID` (`comment_post_ID`), </span><span>KEY</span><span> `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`), </span><span>KEY</span><span> `comment_date_gmt` (`comment_date_gmt`), </span><span>KEY</span><span> `comment_parent` (`comment_parent`), </span><span>KEY</span> `comment_author_email` (`comment_author_email`(<span>10</span><span>)) ) ENGINE</span><span>=</span>InnoDB <span>DEFAULT</span> CHARSET<span>=</span>utf8 AUTO_INCREMENT<span>=</span><span>2</span> ;
wp_links: Table used to save links entered by users into WordPress.
link_id – The unique ID number of each link, bigint(20) value, additional attribute is auto_increment.
link_url – The URL address of each link, varchar(255) value, in the form of an address beginning with http://.
link_name – the name of a single link, varchar(255) value.
link_image – A link can be defined as using an image link. This field is used to save the address of the image and is a varchar(255) value.
link_target – There are three ways to open the link. _blank means opening it in a new window, _top means opening it in this window and at the top level, and none means not selecting it and it will open it in this window. This field is a varchar(25) value.
link_category – The link category corresponding to a link, which is an int(11) value. Equivalent to wp_linkcategories.cat_id.
link_description – Description text of the link. The user can choose to display it below the link or in the title attribute. varchar(255) value.
link_visible – Whether the link is visible, enumeration enum(’Y’,’N’) value, the default is Y, which is visible.
link_owner – The creator of a link, an int(11) value, the default is 1. (It should correspond to wp_users.ID)
link_rating – the link’s rating, int(11) value. Default is 0.
link_updated – the time when the link was defined or modified, datetime value.
link_rel – the relationship between the link and the definer, set by XFN Creator, varchar(255) value.
link_notes – detailed description of the link, mediumtext value.
link_rss – the RSS address of the link, varchar(255) value.
<span>CREATE</span> <span>TABLE</span> <span>IF</span> <span>NOT</span> <span>EXISTS</span><span> `wp_links` ( `link_id` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span><span> AUTO_INCREMENT, `link_url` </span><span>varchar</span>(<span>255</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `link_name` </span><span>varchar</span>(<span>255</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `link_image` </span><span>varchar</span>(<span>255</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `link_target` </span><span>varchar</span>(<span>25</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `link_description` </span><span>varchar</span>(<span>255</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `link_visible` </span><span>varchar</span>(<span>20</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>Y</span><span>'</span><span>, `link_owner` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>1</span><span>'</span><span>, `link_rating` </span><span>int</span>(<span>11</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, `link_updated` </span><span>datetime</span> <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0000-00-00 00:00:00</span><span>'</span><span>, `link_rel` </span><span>varchar</span>(<span>255</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `link_notes` mediumtext </span><span>NOT</span> <span>NULL</span><span>, `link_rss` </span><span>varchar</span>(<span>255</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, </span><span>PRIMARY</span> <span>KEY</span><span> (`link_id`), </span><span>KEY</span><span> `link_visible` (`link_visible`) ) ENGINE</span><span>=</span>InnoDB <span>DEFAULT</span> CHARSET<span>=</span>utf8 AUTO_INCREMENT<span>=</span><span>1</span> ;
wp_options: Table used to save WordPress related settings and parameters. The basic configuration information table is usually operated through get_option. This table is usually used as a place for plug-ins to store data. Is a data table used to store all global options in WordPress.
option_id – ID of the option, bigint(20) value, additional auto_increment attribute.
option_name – option name, varchar(64) value.
option_value – the value of the option, longtext value.
autoload – Whether the option is automatically loaded every time, enumeration ('yes', 'no') value, the default is yes.
<span>CREATE</span> <span>TABLE</span> <span>IF</span> <span>NOT</span> <span>EXISTS</span><span> `wp_options` ( `option_id` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span><span> AUTO_INCREMENT, `option_name` </span><span>varchar</span>(<span>191</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `option_value` longtext </span><span>NOT</span> <span>NULL</span><span>, `autoload` </span><span>varchar</span>(<span>20</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>yes</span><span>'</span><span>, </span><span>PRIMARY</span> <span>KEY</span><span> (`option_id`), </span><span>UNIQUE</span> <span>KEY</span><span> `option_name` (`option_name`) ) ENGINE</span><span>=</span>InnoDB <span>DEFAULT</span> CHARSET<span>=</span>utf8 AUTO_INCREMENT<span>=</span><span>156</span> ;
wp_postmeta: Table used to save meta information (meta) of articles. Additional data tables for the article, such as the number of article views, custom fields of the article, etc. are stored here.
meta_id – Meta information ID, bigint(20) value, additional attribute is auto_increment.
post_id – post ID, bigint(20) value, equivalent to wp_posts.ID.
meta_key – Keyword of meta information, varchar(255) value.
meta_value – 元信息的值，text值。
這 些內(nèi)容主要是在文章及頁面編輯頁(Write Post, Write Page)的”Add a new custom field to this post(page):”下進行設定的。meta_key就對應名為”key”的下拉列表中的項，而值由用戶自己填上(某些時候，wp也會自動加入，如文 章中有的音頻媒體)。
<span>CREATE</span> <span>TABLE</span> <span>IF</span> <span>NOT</span> <span>EXISTS</span><span> `wp_postmeta` ( `meta_id` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span><span> AUTO_INCREMENT, `post_id` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, `meta_key` </span><span>varchar</span>(<span>255</span>) <span>DEFAULT</span> <span>NULL</span><span>, `meta_value` longtext, </span><span>PRIMARY</span> <span>KEY</span><span> (`meta_id`), </span><span>KEY</span><span> `post_id` (`post_id`), </span><span>KEY</span> `meta_key` (`meta_key`(<span>191</span><span>)) ) ENGINE</span><span>=</span>InnoDB <span>DEFAULT</span> CHARSET<span>=</span>utf8 AUTO_INCREMENT<span>=</span><span>2</span> ;
<span>INSERT</span> <span>INTO</span> `wp_postmeta` (`meta_id`, `post_id`, `meta_key`, `meta_value`) <span>VALUES</span><span> (</span><span>1</span>, <span>2</span>, <span>'</span><span>_wp_page_template</span><span>'</span>, <span>'</span><span>default</span><span>'</span>);
wp_posts: 用于保存你所有的文章(posts)的相關信息的表。文章信息表，包括了日志、附件、頁面等等信息，是WordPress最重要的一個數(shù)據(jù)表。
ID – 每篇文章的唯一ID，bigint(20)值，附加屬性auto_increment。
post_author – 每篇文章的作者的編號，int(4)值，應該對應的是wp_users.ID。
post_date – 每篇文章發(fā)表的時間，datetime值。它是GMT時間加上時區(qū)偏移量的結果。
post_date_gmt – 每篇文章發(fā)表時的GMT(格林威治)時間，datetime值。
post_content – 每篇文章的具體內(nèi)容，longtext值。你在后臺文章編輯頁面中寫入的所有內(nèi)容都放在這里。
post_title – 文章的標題，text值。
post_category – 文章所屬分類，int(4)值。
post_excerpt – 文章摘要，text值。
post_status – 文章當前的狀態(tài)，枚舉enum(’publish’,’draft’,’private’,’static’,’object’)值，publish為已 發(fā)表，draft為草稿，private為私人內(nèi)容(不會被公開) ，static(不詳)，object(不詳)。默認為publish。
comment_status – 評論設置的狀態(tài)，也是枚舉enum(’open’,’closed’,’registered_only’)值，open為允許評論，closed為不允 許評論，registered_only為只有注冊用戶方可評論。默認為open，即人人都可以評論。
ping_status – ping狀態(tài)，枚舉enum(’open’,’closed’)值，open指打開pingback功能，closed為關閉。默認值是open。
post_password – 文章密碼，varchar(20)值。文章編輯才可為文章設定一個密碼，憑這個密碼才能對文章進行重新強加或修改。
post_name – 文章名，varchar(200)值。這通常是用在生成permalink時，標識某篇文章的一段文本或數(shù)字，也即post slug。
to_ping – 強制該文章去ping某個URI。text值。
pinged – 該文章被pingback的歷史記錄，text值，為一個個的URI。
post_modified – 文章最后修改的時間，datetime值，它是GMT時間加上時區(qū)偏移量的結果。
post_modified_gmt – 文章最后修改的GMT時間，datetime值。
post_content_filtered – 不詳，text值。
post_parent – 文章的上級文章的ID，int(11)值，對應的是wp_posts.ID。默認為0，即沒有上級文章。
guid – 這是每篇文章的一個地址，varchar(255)值。默認是這樣的形式: http://your.blog.site/?p=1，如果你形成permalink功能，則通常會是: 你的Wordpress站點地址+文章名。
menu_order – 不詳，int(11)值，默認為0。
post_type – 文章類型，具體不詳，varchar(100)值。默認為0。
post_mime_type – 不詳。varchar(100)值。
comment_count – 評論計數(shù)，具體用途不詳，bigint(20)值。
<span>CREATE</span> <span>TABLE</span> <span>IF</span> <span>NOT</span> <span>EXISTS</span><span> `wp_posts` ( `ID` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span><span> AUTO_INCREMENT, `post_author` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, `post_date` </span><span>datetime</span> <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0000-00-00 00:00:00</span><span>'</span><span>, `post_date_gmt` </span><span>datetime</span> <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0000-00-00 00:00:00</span><span>'</span><span>, `post_content` longtext </span><span>NOT</span> <span>NULL</span><span>, `post_title` </span><span>text</span> <span>NOT</span> <span>NULL</span><span>, `post_excerpt` </span><span>text</span> <span>NOT</span> <span>NULL</span><span>, `post_status` </span><span>varchar</span>(<span>20</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>publish</span><span>'</span><span>, `comment_status` </span><span>varchar</span>(<span>20</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>open</span><span>'</span><span>, `ping_status` </span><span>varchar</span>(<span>20</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>open</span><span>'</span><span>, `post_password` </span><span>varchar</span>(<span>20</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `post_name` </span><span>varchar</span>(<span>200</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `to_ping` </span><span>text</span> <span>NOT</span> <span>NULL</span><span>, `pinged` </span><span>text</span> <span>NOT</span> <span>NULL</span><span>, `post_modified` </span><span>datetime</span> <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0000-00-00 00:00:00</span><span>'</span><span>, `post_modified_gmt` </span><span>datetime</span> <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0000-00-00 00:00:00</span><span>'</span><span>, `post_content_filtered` longtext </span><span>NOT</span> <span>NULL</span><span>, `post_parent` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, `guid` </span><span>varchar</span>(<span>255</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `menu_order` </span><span>int</span>(<span>11</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, `post_type` </span><span>varchar</span>(<span>20</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>post</span><span>'</span><span>, `post_mime_type` </span><span>varchar</span>(<span>100</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `comment_count` </span><span>bigint</span>(<span>20</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, </span><span>PRIMARY</span> <span>KEY</span><span> (`ID`), </span><span>KEY</span> `post_name` (`post_name`(<span>191</span><span>)), </span><span>KEY</span><span> `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`), </span><span>KEY</span><span> `post_parent` (`post_parent`), </span><span>KEY</span><span> `post_author` (`post_author`) ) ENGINE</span><span>=</span>InnoDB <span>DEFAULT</span> CHARSET<span>=</span>utf8 AUTO_INCREMENT<span>=</span><span>5</span> ;
<span>INSERT</span> <span>INTO</span> `wp_posts` (`ID`, `post_author`, `post_date`, `post_date_gmt`, `post_content`, `post_title`, `post_excerpt`, `post_status`, `comment_status`, `ping_status`, `post_password`, `post_name`, `to_ping`, `pinged`, `post_modified`, `post_modified_gmt`, `post_content_filtered`, `post_parent`, `guid`, `menu_order`, `post_type`, `post_mime_type`, `comment_count`) <span>VALUES</span><span> (</span><span>1</span>, <span>1</span>, <span>'</span><span>2016-04-03 08:48:29</span><span>'</span>, <span>'</span><span>2016-04-03 00:48:29</span><span>'</span>, <span>'</span><span>歡迎使用WordPress。這是您的第一篇文章。編輯或刪除它，然后開始寫作吧！</span><span>'</span>, <span>'</span><span>世界，您好！</span><span>'</span>, <span>''</span>, <span>'</span><span>publish</span><span>'</span>, <span>'</span><span>open</span><span>'</span>, <span>'</span><span>open</span><span>'</span>, <span>''</span>, <span>'</span><span>hello-world</span><span>'</span>, <span>''</span>, <span>''</span>, <span>'</span><span>2016-04-03 08:48:29</span><span>'</span>, <span>'</span><span>2016-04-03 00:48:29</span><span>'</span>, <span>''</span>, <span>0</span>, <span>'</span><span>http://localhost:8081/?p=1</span><span>'</span>, <span>0</span>, <span>'</span><span>post</span><span>'</span>, <span>''</span>, <span>1</span><span>), (</span><span>2</span>, <span>1</span>, <span>'</span><span>2016-04-03 08:48:29</span><span>'</span>, <span>'</span><span>2016-04-03 00:48:29</span><span>'</span>, <span>'</span><span>這是一個范例頁面。它和博客文章不同，因為它的頁面位置是固定的，同時會顯示于您的博客導航欄（大多數(shù)主題中）。大多數(shù)人會新增一個“關于”頁面向訪客介紹自己。它可能類似下面這樣：\n\n<blockquote>我是一個很有趣的人，我創(chuàng)建了工廠和莊園。并且，順便提一下，我的妻子也很好。</blockquote>\n\n……或下面這樣：\n\n<blockquote>XYZ裝置公司成立于1971年，公司成立以來，我們一直向市民提供高品質(zhì)的裝置。我們位于北京市，有超過2,000名員工，對北京市有著相當大的貢獻。</blockquote>\n\n作為一個新的WordPress用戶，您可以前往<a href="http://localhost:8081/wp-admin/">您的儀表盤</a>刪除這個頁面，并建立屬于您的全新內(nèi)容。祝您使用愉快！</span><span>'</span>, <span>'</span><span>示例頁面</span><span>'</span>, <span>''</span>, <span>'</span><span>publish</span><span>'</span>, <span>'</span><span>closed</span><span>'</span>, <span>'</span><span>open</span><span>'</span>, <span>''</span>, <span>'</span><span>sample-page</span><span>'</span>, <span>''</span>, <span>''</span>, <span>'</span><span>2016-04-03 08:48:29</span><span>'</span>, <span>'</span><span>2016-04-03 00:48:29</span><span>'</span>, <span>''</span>, <span>0</span>, <span>'</span><span>http://localhost:8081/?page_id=2</span><span>'</span>, <span>0</span>, <span>'</span><span>page</span><span>'</span>, <span>''</span>, <span>0</span><span>), (</span><span>3</span>, <span>1</span>, <span>'</span><span>2016-04-03 08:58:06</span><span>'</span>, <span>'</span><span>0000-00-00 00:00:00</span><span>'</span>, <span>''</span>, <span>'</span><span>自動草稿</span><span>'</span>, <span>''</span>, <span>'</span><span>auto-draft</span><span>'</span>, <span>'</span><span>open</span><span>'</span>, <span>'</span><span>open</span><span>'</span>, <span>''</span>, <span>''</span>, <span>''</span>, <span>''</span>, <span>'</span><span>2016-04-03 08:58:06</span><span>'</span>, <span>'</span><span>0000-00-00 00:00:00</span><span>'</span>, <span>''</span>, <span>0</span>, <span>'</span><span>http://localhost:8081/?p=3</span><span>'</span>, <span>0</span>, <span>'</span><span>post</span><span>'</span>, <span>''</span>, <span>0</span><span>), (</span><span>4</span>, <span>1</span>, <span>'</span><span>2016-04-03 09:00:50</span><span>'</span>, <span>'</span><span>0000-00-00 00:00:00</span><span>'</span>, <span>''</span>, <span>'</span><span>自動草稿</span><span>'</span>, <span>''</span>, <span>'</span><span>auto-draft</span><span>'</span>, <span>'</span><span>open</span><span>'</span>, <span>'</span><span>open</span><span>'</span>, <span>''</span>, <span>''</span>, <span>''</span>, <span>''</span>, <span>'</span><span>2016-04-03 09:00:50</span><span>'</span>, <span>'</span><span>0000-00-00 00:00:00</span><span>'</span>, <span>''</span>, <span>0</span>, <span>'</span><span>http://localhost:8081/?p=4</span><span>'</span>, <span>0</span>, <span>'</span><span>post</span><span>'</span>, <span>''</span>, <span>0</span>);
wp_termmeta ：分類與文章信息表（wp_posts）、鏈接表(wp_links)的關聯(lián)表。
<span>CREATE</span> <span>TABLE</span> <span>IF</span> <span>NOT</span> <span>EXISTS</span><span> `wp_termmeta` ( `meta_id` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span><span> AUTO_INCREMENT, `term_id` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, `meta_key` </span><span>varchar</span>(<span>255</span>) <span>DEFAULT</span> <span>NULL</span><span>, `meta_value` longtext, </span><span>PRIMARY</span> <span>KEY</span><span> (`meta_id`), </span><span>KEY</span><span> `term_id` (`term_id`), </span><span>KEY</span> `meta_key` (`meta_key`(<span>191</span><span>)) ) ENGINE</span><span>=</span>InnoDB <span>DEFAULT</span> CHARSET<span>=</span>utf8 AUTO_INCREMENT<span>=</span><span>1</span> ;
wp_terms ：文章分類、鏈接分類、標簽的信息表。
<span>CREATE</span> <span>TABLE</span> <span>IF</span> <span>NOT</span> <span>EXISTS</span><span> `wp_terms` ( `term_id` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span><span> AUTO_INCREMENT, `name` </span><span>varchar</span>(<span>200</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `slug` </span><span>varchar</span>(<span>200</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `term_group` </span><span>bigint</span>(<span>10</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, </span><span>PRIMARY</span> <span>KEY</span><span> (`term_id`), </span><span>KEY</span> `slug` (`slug`(<span>191</span><span>)), </span><span>KEY</span> `name` (`name`(<span>191</span><span>)) ) ENGINE</span><span>=</span>InnoDB <span>DEFAULT</span> CHARSET<span>=</span>utf8 AUTO_INCREMENT<span>=</span><span>2</span> ;
<span>INSERT</span> <span>INTO</span> `wp_terms` (`term_id`, `name`, `slug`, `term_group`) <span>VALUES</span><span> (</span><span>1</span>, <span>'</span><span>未分類</span><span>'</span>, <span>'</span><span>uncategorized</span><span>'</span>, <span>0</span>);
wp_term_relationships ：分類與文章信息表（wp_posts）、鏈接表(wp_links)的關聯(lián)表。
<span>CREATE</span> <span>TABLE</span> <span>IF</span> <span>NOT</span> <span>EXISTS</span><span> `wp_term_relationships` ( `</span><span>object_id</span>` <span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, `term_taxonomy_id` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, `term_order` </span><span>int</span>(<span>11</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, </span><span>PRIMARY</span> <span>KEY</span> (`<span>object_id</span><span>`,`term_taxonomy_id`), </span><span>KEY</span><span> `term_taxonomy_id` (`term_taxonomy_id`) ) ENGINE</span><span>=</span>InnoDB <span>DEFAULT</span> CHARSET<span>=</span>utf8;
wp_term_taxonomy ：分類信息表，區(qū)分wp_terms信息的分類類型，有category、link_category和tag三種分類類型。
<span>CREATE</span> <span>TABLE</span> <span>IF</span> <span>NOT</span> <span>EXISTS</span><span> `wp_term_taxonomy` ( `term_taxonomy_id` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span><span> AUTO_INCREMENT, `term_id` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, `taxonomy` </span><span>varchar</span>(<span>32</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `description` longtext </span><span>NOT</span> <span>NULL</span><span>, `parent` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, `</span><span>count</span>` <span>bigint</span>(<span>20</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, </span><span>PRIMARY</span> <span>KEY</span><span> (`term_taxonomy_id`), </span><span>UNIQUE</span> <span>KEY</span><span> `term_id_taxonomy` (`term_id`,`taxonomy`), </span><span>KEY</span><span> `taxonomy` (`taxonomy`) ) ENGINE</span><span>=</span>InnoDB <span>DEFAULT</span> CHARSET<span>=</span>utf8 AUTO_INCREMENT<span>=</span><span>2</span> ;
<span>INSERT</span> <span>INTO</span> `wp_term_taxonomy` (`term_taxonomy_id`, `term_id`, `taxonomy`, `description`, `parent`, `<span>count</span>`) <span>VALUES</span><span> (</span><span>1</span>, <span>1</span>, <span>'</span><span>category</span><span>'</span>, <span>''</span>, <span>0</span>, <span>1</span>);
wp_usermeta : 用于保存用戶元信息(meta)的表。
umeta_id – 元信息ID，bigint(20)值，附加屬性auto_increment。
user_id – 元信息對應的用戶ID，bigint(20)值，相當于wp_users.ID。
meta_key – 元信息關鍵字，varchar(255)值。
meta_value – 元信息的詳細值，longtext值。
<span>CREATE</span> <span>TABLE</span> <span>IF</span> <span>NOT</span> <span>EXISTS</span><span> `wp_usermeta` ( `umeta_id` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span><span> AUTO_INCREMENT, `</span><span>user_id</span>` <span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, `meta_key` </span><span>varchar</span>(<span>255</span>) <span>DEFAULT</span> <span>NULL</span><span>, `meta_value` longtext, </span><span>PRIMARY</span> <span>KEY</span><span> (`umeta_id`), </span><span>KEY</span> `<span>user_id</span>` (`<span>user_id</span><span>`), </span><span>KEY</span> `meta_key` (`meta_key`(<span>191</span><span>)) ) ENGINE</span><span>=</span>InnoDB <span>DEFAULT</span> CHARSET<span>=</span>utf8 AUTO_INCREMENT<span>=</span><span>20</span> ;
<span>INSERT</span> <span>INTO</span> `wp_usermeta` (`umeta_id`, `<span>user_id</span>`, `meta_key`, `meta_value`) <span>VALUES</span><span>
(</span><span>1</span>, <span>1</span>, <span>'</span><span>nickname</span><span>'</span>, <span>'</span><span>souvc</span><span>'</span><span>),
(</span><span>2</span>, <span>1</span>, <span>'</span><span>first_name</span><span>'</span>, <span>''</span><span>),
(</span><span>3</span>, <span>1</span>, <span>'</span><span>last_name</span><span>'</span>, <span>''</span><span>),
(</span><span>4</span>, <span>1</span>, <span>'</span><span>description</span><span>'</span>, <span>''</span><span>),
(</span><span>5</span>, <span>1</span>, <span>'</span><span>rich_editing</span><span>'</span>, <span>'</span><span>true</span><span>'</span><span>),
(</span><span>6</span>, <span>1</span>, <span>'</span><span>comment_shortcuts</span><span>'</span>, <span>'</span><span>false</span><span>'</span><span>),
(</span><span>7</span>, <span>1</span>, <span>'</span><span>admin_color</span><span>'</span>, <span>'</span><span>fresh</span><span>'</span><span>),
(</span><span>8</span>, <span>1</span>, <span>'</span><span>use_ssl</span><span>'</span>, <span>'</span><span>0</span><span>'</span><span>),
(</span><span>9</span>, <span>1</span>, <span>'</span><span>show_admin_bar_front</span><span>'</span>, <span>'</span><span>true</span><span>'</span><span>),
(</span><span>10</span>, <span>1</span>, <span>'</span><span>wp_capabilities</span><span>'</span>, <span>'</span><span>a:1:{s:13:"administrator";b:1;}</span><span>'</span><span>),
(</span><span>11</span>, <span>1</span>, <span>'</span><span>wp_user_level</span><span>'</span>, <span>'</span><span>10</span><span>'</span><span>),
(</span><span>12</span>, <span>1</span>, <span>'</span><span>dismissed_wp_pointers</span><span>'</span>, <span>''</span><span>),
(</span><span>13</span>, <span>1</span>, <span>'</span><span>show_welcome_panel</span><span>'</span>, <span>'</span><span>1</span><span>'</span><span>),
(</span><span>14</span>, <span>1</span>, <span>'</span><span>session_tokens</span><span>'</span>, <span>'</span><span>a:2:{s:64:"863288c6d33f046c578de0cafee38ec3b49a0ca4e078088b0065cbafcdd06d3c";a:4:{s:10:"expiration";i:1459817885;s:2:"ip";s:3:"::1";s:2:"ua";s:72:"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0";s:5:"login";i:1459645085;}s:64:"310725109de88bde9eb342337323927d2af5e6c98b5662f715dd1acc1697609f";a:4:{s:10:"expiration";i:1459830580;s:2:"ip";s:3:"::1";s:2:"ua";s:72:"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0";s:5:"login";i:1459657780;}}</span><span>'</span><span>),
(</span><span>15</span>, <span>1</span>, <span>'</span><span>wp_dashboard_quick_press_last_post_id</span><span>'</span>, <span>'</span><span>3</span><span>'</span><span>),
(</span><span>16</span>, <span>1</span>, <span>'</span><span>managenav-menuscolumnshidden</span><span>'</span>, <span>'</span><span>a:5:{i:0;s:11:"link-target";i:1;s:11:"css-classes";i:2;s:3:"xfn";i:3;s:11:"description";i:4;s:15:"title-attribute";}</span><span>'</span><span>),
(</span><span>17</span>, <span>1</span>, <span>'</span><span>metaboxhidden_nav-menus</span><span>'</span>, <span>'</span><span>a:2:{i:0;s:12:"add-post_tag";i:1;s:15:"add-post_format";}</span><span>'</span><span>),
(</span><span>18</span>, <span>1</span>, <span>'</span><span>wp_user-settings</span><span>'</span>, <span>'</span><span>mfold=o</span><span>'</span><span>),
(</span><span>19</span>, <span>1</span>, <span>'</span><span>wp_user-settings-time</span><span>'</span>, <span>'</span><span>1459658009</span><span>'</span>);
wp_users:用于保存Wordpress使用者的相關信息的表。
ID – 用戶唯一ID,bigint(20)值，帶附加屬性auto_increment。
user_login – 用戶的注冊名稱，varchar(60)值。
user_pass – 用戶密碼，varchar(64)值，這是經(jīng)過加密的結果。好象用的是不可逆的MD5算法。
user_nicename – 用戶昵稱，varchar(50)值。
user_email – 用戶電郵地址，varchar(100)值。
user_url – 用戶網(wǎng)址，varchar(100)值。
user_registered – 用戶注冊時間，datetime值。
user_activation_key – 用戶激活碼，不詳。varchar(60)值。
user_status – 用戶狀態(tài)，int(11)值，默認為0。
display_name – 來前臺顯示出來的用戶名字，varchar(250)值。
<span>CREATE</span> <span>TABLE</span> <span>IF</span> <span>NOT</span> <span>EXISTS</span><span> `wp_users` ( `ID` </span><span>bigint</span>(<span>20</span>) unsigned <span>NOT</span> <span>NULL</span><span> AUTO_INCREMENT, `user_login` </span><span>varchar</span>(<span>60</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `user_pass` </span><span>varchar</span>(<span>255</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `user_nicename` </span><span>varchar</span>(<span>50</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `user_email` </span><span>varchar</span>(<span>100</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `user_url` </span><span>varchar</span>(<span>100</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `user_registered` </span><span>datetime</span> <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0000-00-00 00:00:00</span><span>'</span><span>, `user_activation_key` </span><span>varchar</span>(<span>255</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, `user_status` </span><span>int</span>(<span>11</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>'</span><span>0</span><span>'</span><span>, `display_name` </span><span>varchar</span>(<span>250</span>) <span>NOT</span> <span>NULL</span> <span>DEFAULT</span> <span>''</span><span>, </span><span>PRIMARY</span> <span>KEY</span><span> (`ID`), </span><span>KEY</span><span> `user_login_key` (`user_login`), </span><span>KEY</span><span> `user_nicename` (`user_nicename`) ) ENGINE</span><span>=</span>InnoDB <span>DEFAULT</span> CHARSET<span>=</span>utf8 AUTO_INCREMENT<span>=</span><span>2</span> ;
<span>INSERT</span> <span>INTO</span> `wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) <span>VALUES</span><span> (</span><span>1</span>, <span>'</span><span>souvc</span><span>'</span>, <span>'</span><span>$P$B1X3tpz3DDAzQInF0pTRXff8PxMZ6R0</span><span>'</span>, <span>'</span><span>souvc</span><span>'</span>, <span>'</span><span>291117974@qq.com</span><span>'</span>, <span>''</span>, <span>'</span><span>2016-04-03 00:48:29</span><span>'</span>, <span>''</span>, <span>0</span>, <span>'</span><span>souvc</span><span>'</span>);
?
?
參考：
http://blog.csdn.net/liujiyong7/article/details/8042132
http://zmingcx.com/wordpress-database-tdescription.html
http://blog.csdn.net/liujiyong7/article/details/8037843
?
Hot AI Tools
Undress AI Tool
Undress images for free
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to adjust the wordpress article list
Apr 20, 2025 am 10:48 AM
There are four ways to adjust the WordPress article list: use theme options, use plugins (such as Post Types Order, WP Post List, Boxy Stuff), use code (add settings in the functions.php file), or modify the WordPress database directly.
10 latest tools for web developers
May 07, 2025 pm 04:48 PM
Web development design is a promising career field. However, this industry also faces many challenges. As more businesses and brands turn to the online marketplace, web developers have the opportunity to demonstrate their skills and succeed in their careers. However, as demand for web development continues to grow, the number of developers is also increasing, resulting in increasingly fierce competition. But it’s exciting that if you have the talent and will, you can always find new ways to create unique designs and ideas. As a web developer, you may need to keep looking for new tools and resources. These new tools and resources not only make your job more convenient, but also improve the quality of your work, thus helping you win more business and customers. The trends of web development are constantly changing.
How to import the source code of wordpress
Apr 20, 2025 am 11:24 AM
Importing WordPress source code requires the following steps: Create a sub-theme for theme modification. Import the source code and overwrite the files in the sub-topic. Activate the sub-theme to make it effective. Test the changes to make sure everything works.
How to build a website for wordpress host
Apr 20, 2025 am 11:12 AM
To build a website using WordPress hosting, you need to: select a reliable hosting provider. Buy a domain name. Set up a WordPress hosting account. Select a topic. Add pages and articles. Install the plug-in. Customize your website. Publish your website.
How to add your WordPress site in Yandex Webmaster Tools
May 12, 2025 pm 09:06 PM
Do you want to connect your website to Yandex Webmaster Tools? Webmaster tools such as Google Search Console, Bing and Yandex can help you optimize your website, monitor traffic, manage robots.txt, check for website errors, and more. In this article, we will share how to add your WordPress website to the Yandex Webmaster Tool to monitor your search engine traffic. What is Yandex? Yandex is a popular search engine based in Russia, similar to Google and Bing. You can excel in Yandex
How to set, get and delete WordPress cookies (like a professional)
May 12, 2025 pm 08:57 PM
Do you want to know how to use cookies on your WordPress website? Cookies are useful tools for storing temporary information in users’ browsers. You can use this information to enhance the user experience through personalization and behavioral targeting. In this ultimate guide, we will show you how to set, get, and delete WordPresscookies like a professional. Note: This is an advanced tutorial. It requires you to be proficient in HTML, CSS, WordPress websites and PHP. What are cookies? Cookies are created and stored when users visit websites.
How to fix HTTP image upload errors in WordPress (simple)
May 12, 2025 pm 09:03 PM
Do you need to fix HTTP image upload errors in WordPress? This error can be particularly frustrating when you create content in WordPress. This usually happens when you upload images or other files to your CMS using the built-in WordPress media library. In this article, we will show you how to easily fix HTTP image upload errors in WordPress. What is the reason for HTTP errors during WordPress media uploading? When you try to upload files to Wo using WordPress media uploader
How to register a wordpress account
Apr 20, 2025 am 11:45 AM
To create an account on WordPress, simply visit its website, select the registration option, fill in the registration form, and verify your email address. Other ways to register include using a Google account or Apple ID. The benefits of signing up include creating a website, gaining features, joining the community, and gaining support.
