


wordpress-4.4.1 數(shù)據(jù)庫表結(jié)構(gòu)解析,wordpress數(shù)據(jù)庫結(jié)構(gòu)_PHP教程
Jul 12, 2016 am 08:55 AMwordpress-4.4.1 數(shù)據(jù)庫表結(jié)構(gòu)解析,wordpress數(shù)據(jù)庫結(jié)構(gòu)
wordpress-4.4.1.zip 安裝包?
?
?
SQL結(jié)構(gòu) :
?
?
wp_commentmeta ?:文章評論額外信息表。
?
<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 :文章評論信息表。
comment_ID – 每個(gè)評論的唯一ID號,是一個(gè)bigint(20)值。帶有附加屬性auto_increment。
comment_post_ID – 每個(gè)評論對應(yīng)的文章的ID號,int(11)值,等同于wp_posts.ID。
comment_author – 每個(gè)評論的評論者名稱,tinytext值。
comment_author_email – 每個(gè)評論的評論者電郵地址,varchar(100)值。
comment_author_url – 每個(gè)評論的評論者網(wǎng)址,varchar(200)值。
comment_author_IP – 每個(gè)評論的評論者的IP地址,varchar(100)值。
comment_date – 每個(gè)評論發(fā)表的時(shí)間,datetime值(是加上時(shí)區(qū)偏移量后的值)。
comment_date_gmt – 每個(gè)評論發(fā)表的時(shí)間,datetime值(是標(biāo)準(zhǔn)的格林尼治時(shí)間)。
comment_content – 每個(gè)評論的具體內(nèi)容,text值。
comment_karma – 不詳,int(11)值,默認(rèn)為0。
comment_approved – 每個(gè)評論的當(dāng)前狀態(tài),為一個(gè)枚舉值enum(’0′,’1′,’spam’),0為等待審核,1為允許發(fā)布,spam為垃圾評論。默認(rèn)值為1。
comment_agent – 每個(gè)評論的評論者的客戶端信息,varchar(255)值,主要包括其瀏覽器和操作系統(tǒng)的類型、版本等資料。
comment_type – 評論的類型,varchar(20)值。
comment_parent – 某一評論的上級評論,int(11)值,對應(yīng)wp_comment.ID,默認(rèn)為0,即無上級評論。
user_id – 某一評論對應(yīng)的用戶ID,只有當(dāng)用戶注冊后才會生成,int(11)值,對應(yīng)wp_users.ID。未注冊的用戶,即外部評論者,這個(gè)ID的值為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 :用于保存用戶輸入到Wordpress中的鏈接的表。
link_id – 每個(gè)鏈接的唯一ID號,bigint(20)值,附加屬性為auto_increment。
link_url – 每個(gè)鏈接的URL地址,varchar(255)值,形式為http://開頭的地址。
link_name – 單個(gè)鏈接的名字,varchar(255)值。
link_image – 鏈接可以被定義為使用圖片鏈接,這個(gè)字段用于保存該圖片的地址,為varchar(255)值。
link_target – 鏈接打開的方式,有三種,_blank為以新窗口打開,_top為就在本窗口中打開并在最上一級,none為不選擇,會在本窗口中打開。這個(gè)字段是varchar(25)值。
link_category – 某個(gè)鏈接對應(yīng)的鏈接分類,為int(11)值。相當(dāng)于wp_linkcategories.cat_id。
link_description – 鏈接的說明文字。用戶可以選擇顯示在鏈接下方還是顯示在title屬性中。varchar(255)值。
link_visible – 該鏈接是否可以,枚舉enum(’Y’,’N’)值,默認(rèn)為Y,即可見。
link_owner – 某個(gè)鏈接的創(chuàng)建人,為一int(11)值,默認(rèn)是1。(應(yīng)該對應(yīng)的就是wp_users.ID)
link_rating – 鏈接的等級,int(11)值。默認(rèn)為0。
link_updated – 鏈接被定義、修改的時(shí)間,datetime值。
link_rel – 鏈接與定義者的關(guān)系,由XFN Creator設(shè)置,varchar(255)值。
link_notes – 鏈接的詳細(xì)說明,mediumtext值。
link_rss – 該鏈接的RSS地址,varchar(255)值。
<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: 用于保存Wordpress相關(guān)設(shè)置、參數(shù)的表?;九渲眯畔⒈?,通常通過get_option來操作,該表通常作為插件存儲數(shù)據(jù)的一個(gè)地方。是用來存儲 WordPress 中所有全局選項(xiàng)的數(shù)據(jù)表。
option_id – 選項(xiàng)的ID,bigint(20)值,附加auto_increment屬性。
option_name – 選項(xiàng)名稱,varchar(64)值。
option_value – 選項(xiàng)的值,longtext值。
autoload – 選項(xiàng)是否每次都被自動加載,枚舉enum(’yes’,’no’)值,默認(rèn)為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: 用于保存文章的元信息(meta)的表。文章額外數(shù)據(jù)表,例如文章瀏覽次數(shù),文章的自定義字段等都存儲在這里。
meta_id – 元信息ID,bigint(20)值,附加屬性為auto_increment。
post_id – 文章ID,bigint(20)值,相當(dāng)于wp_posts.ID。
meta_key – 元信息的關(guān)鍵字,varchar(255)值。
meta_value – 元信息的值,text值。
這 些內(nèi)容主要是在文章及頁面編輯頁(Write Post, Write Page)的”Add a new custom field to this post(page):”下進(jìn)行設(shè)定的。meta_key就對應(yīng)名為”key”的下拉列表中的項(xiàng),而值由用戶自己填上(某些時(shí)候,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)的相關(guān)信息的表。文章信息表,包括了日志、附件、頁面等等信息,是WordPress最重要的一個(gè)數(shù)據(jù)表。
ID – 每篇文章的唯一ID,bigint(20)值,附加屬性auto_increment。
post_author – 每篇文章的作者的編號,int(4)值,應(yīng)該對應(yīng)的是wp_users.ID。
post_date – 每篇文章發(fā)表的時(shí)間,datetime值。它是GMT時(shí)間加上時(shí)區(qū)偏移量的結(jié)果。
post_date_gmt – 每篇文章發(fā)表時(shí)的GMT(格林威治)時(shí)間,datetime值。
post_content – 每篇文章的具體內(nèi)容,longtext值。你在后臺文章編輯頁面中寫入的所有內(nèi)容都放在這里。
post_title – 文章的標(biāo)題,text值。
post_category – 文章所屬分類,int(4)值。
post_excerpt – 文章摘要,text值。
post_status – 文章當(dāng)前的狀態(tài),枚舉enum(’publish’,’draft’,’private’,’static’,’object’)值,publish為已 發(fā)表,draft為草稿,private為私人內(nèi)容(不會被公開) ,static(不詳),object(不詳)。默認(rèn)為publish。
comment_status – 評論設(shè)置的狀態(tài),也是枚舉enum(’open’,’closed’,’registered_only’)值,open為允許評論,closed為不允 許評論,registered_only為只有注冊用戶方可評論。默認(rèn)為open,即人人都可以評論。
ping_status – ping狀態(tài),枚舉enum(’open’,’closed’)值,open指打開pingback功能,closed為關(guān)閉。默認(rèn)值是open。
post_password – 文章密碼,varchar(20)值。文章編輯才可為文章設(shè)定一個(gè)密碼,憑這個(gè)密碼才能對文章進(jìn)行重新強(qiáng)加或修改。
post_name – 文章名,varchar(200)值。這通常是用在生成permalink時(shí),標(biāo)識某篇文章的一段文本或數(shù)字,也即post slug。
to_ping – 強(qiáng)制該文章去ping某個(gè)URI。text值。
pinged – 該文章被pingback的歷史記錄,text值,為一個(gè)個(gè)的URI。
post_modified – 文章最后修改的時(shí)間,datetime值,它是GMT時(shí)間加上時(shí)區(qū)偏移量的結(jié)果。
post_modified_gmt – 文章最后修改的GMT時(shí)間,datetime值。
post_content_filtered – 不詳,text值。
post_parent – 文章的上級文章的ID,int(11)值,對應(yīng)的是wp_posts.ID。默認(rèn)為0,即沒有上級文章。
guid – 這是每篇文章的一個(gè)地址,varchar(255)值。默認(rèn)是這樣的形式: http://your.blog.site/?p=1,如果你形成permalink功能,則通常會是: 你的Wordpress站點(diǎn)地址+文章名。
menu_order – 不詳,int(11)值,默認(rèn)為0。
post_type – 文章類型,具體不詳,varchar(100)值。默認(rèn)為0。
post_mime_type – 不詳。varchar(100)值。
comment_count – 評論計(jì)數(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>這是一個(gè)范例頁面。它和博客文章不同,因?yàn)樗捻撁嫖恢檬枪潭ǖ模瑫r(shí)會顯示于您的博客導(dǎo)航欄(大多數(shù)主題中)。大多數(shù)人會新增一個(gè)“關(guān)于”頁面向訪客介紹自己。它可能類似下面這樣:\n\n<blockquote>我是一個(gè)很有趣的人,我創(chuàng)建了工廠和莊園。并且,順便提一下,我的妻子也很好。</blockquote>\n\n……或下面這樣:\n\n<blockquote>XYZ裝置公司成立于1971年,公司成立以來,我們一直向市民提供高品質(zhì)的裝置。我們位于北京市,有超過2,000名員工,對北京市有著相當(dāng)大的貢獻(xiàn)。</blockquote>\n\n作為一個(gè)新的WordPress用戶,您可以前往<a href="http://localhost:8081/wp-admin/">您的儀表盤</a>刪除這個(gè)頁面,并建立屬于您的全新內(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)的關(guān)聯(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 :文章分類、鏈接分類、標(biāo)簽的信息表。
<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)的關(guān)聯(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 – 元信息對應(yīng)的用戶ID,bigint(20)值,相當(dāng)于wp_users.ID。
meta_key – 元信息關(guān)鍵字,varchar(255)值。
meta_value – 元信息的詳細(xì)值,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使用者的相關(guān)信息的表。
ID – 用戶唯一ID,bigint(20)值,帶附加屬性auto_increment。
user_login – 用戶的注冊名稱,varchar(60)值。
user_pass – 用戶密碼,varchar(64)值,這是經(jīng)過加密的結(jié)果。好象用的是不可逆的MD5算法。
user_nicename – 用戶昵稱,varchar(50)值。
user_email – 用戶電郵地址,varchar(100)值。
user_url – 用戶網(wǎng)址,varchar(100)值。
user_registered – 用戶注冊時(shí)間,datetime值。
user_activation_key – 用戶激活碼,不詳。varchar(60)值。
user_status – 用戶狀態(tài),int(11)值,默認(rèn)為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
?

Alat AI Hot

Undress AI Tool
Gambar buka pakaian secara percuma

Undresser.AI Undress
Apl berkuasa AI untuk mencipta foto bogel yang realistik

AI Clothes Remover
Alat AI dalam talian untuk mengeluarkan pakaian daripada foto.

Clothoff.io
Penyingkiran pakaian AI

Video Face Swap
Tukar muka dalam mana-mana video dengan mudah menggunakan alat tukar muka AI percuma kami!

Artikel Panas

Alat panas

Notepad++7.3.1
Editor kod yang mudah digunakan dan percuma

SublimeText3 versi Cina
Versi Cina, sangat mudah digunakan

Hantar Studio 13.0.1
Persekitaran pembangunan bersepadu PHP yang berkuasa

Dreamweaver CS6
Alat pembangunan web visual

SublimeText3 versi Mac
Perisian penyuntingan kod peringkat Tuhan (SublimeText3)

Topik panas

Terdapat empat cara untuk menyesuaikan senarai artikel WordPress: Gunakan pilihan tema, gunakan plugin (seperti pesanan jenis pos, senarai pos WP, barangan boxy), gunakan kod (tambah tetapan dalam fail fungsi.php), atau ubah suai pangkalan data WordPress secara langsung.

Reka bentuk pembangunan web adalah bidang kerjaya yang menjanjikan. Walau bagaimanapun, industri ini juga menghadapi banyak cabaran. Memandangkan lebih banyak perniagaan dan jenama beralih ke pasaran dalam talian, pemaju web mempunyai peluang untuk menunjukkan kemahiran mereka dan berjaya dalam kerjaya mereka. Walau bagaimanapun, apabila permintaan untuk pembangunan web terus berkembang, bilangan pemaju juga semakin meningkat, mengakibatkan persaingan yang semakin sengit. Tetapi ia menarik bahawa jika anda mempunyai bakat dan kehendak, anda sentiasa dapat mencari cara baru untuk membuat reka bentuk dan idea yang unik. Sebagai pemaju web, anda mungkin perlu terus mencari alat dan sumber baru. Alat dan sumber baru ini bukan sahaja menjadikan pekerjaan anda lebih mudah, tetapi juga meningkatkan kualiti kerja anda, dengan itu membantu anda memenangi lebih banyak perniagaan dan pelanggan. Trend pembangunan web sentiasa berubah.

Mengimport kod sumber WordPress memerlukan langkah-langkah berikut: Buat sub-tema untuk pengubahsuaian tema. Import kod sumber dan ganti rugi fail dalam sub-topik. Aktifkan sub-tema untuk menjadikannya berkesan. Uji perubahan untuk memastikan semuanya berfungsi.

Untuk membina laman web menggunakan hos WordPress, anda perlu: pilih penyedia hosting yang boleh dipercayai. Beli nama domain. Sediakan akaun hosting WordPress. Pilih topik. Tambah halaman dan artikel. Pasang pemalam. Sesuaikan laman web anda. Menerbitkan laman web anda.

Adakah anda ingin menyambungkan laman web anda ke alat webmaster Yandex? Alat webmaster seperti Google Search Console, Bing dan Yandex boleh membantu anda mengoptimumkan laman web anda, memantau lalu lintas, menguruskan robots.txt, periksa kesilapan laman web, dan banyak lagi. Dalam artikel ini, kami akan berkongsi cara menambah laman web WordPress anda ke alat Webmaster Yandex untuk memantau trafik enjin carian anda. Apa itu Yandex? Yandex adalah enjin carian popular yang berpusat di Rusia, sama seperti Google dan Bing. Anda boleh cemerlang dalam yandex

Adakah anda ingin tahu cara menggunakan kuki di laman web WordPress anda? Kuki adalah alat yang berguna untuk menyimpan maklumat sementara dalam pelayar pengguna. Anda boleh menggunakan maklumat ini untuk meningkatkan pengalaman pengguna melalui pemperibadian dan penargetan tingkah laku. Dalam panduan muktamad ini, kami akan menunjukkan kepada anda bagaimana untuk menetapkan, mendapatkan, dan memadam WordPresscookies seperti profesional. Nota: Ini adalah tutorial lanjutan. Ia memerlukan anda mahir dalam laman web HTML, CSS, WordPress dan PHP. Apa itu kuki? Kuki dicipta dan disimpan apabila pengguna melawat laman web.

Adakah anda perlu membetulkan kesilapan muat naik imej HTTP di WordPress? Kesalahan ini boleh menjadi sangat mengecewakan apabila anda membuat kandungan dalam WordPress. Ini biasanya berlaku apabila anda memuat naik imej atau fail lain ke CMS anda menggunakan perpustakaan media WordPress terbina dalam. Dalam artikel ini, kami akan menunjukkan kepada anda bagaimana untuk membetulkan kesilapan muat naik imej HTTP di WordPress. Apakah sebab kesilapan HTTP semasa memuat naik media WordPress? Apabila anda cuba memuat naik fail ke WO menggunakan pemuat naik media WordPress

Untuk membuat akaun di WordPress, hanya lawati laman webnya, pilih pilihan pendaftaran, isikan borang pendaftaran, dan sahkan alamat e -mel anda. Cara lain untuk mendaftar termasuk menggunakan akaun Google atau ID Apple. Manfaat mendaftar termasuk membuat laman web, mendapatkan ciri -ciri, menyertai komuniti, dan mendapat sokongan.
