本館粉絲專頁

使用者:Minwei/維基筆記/Schema轉換/Tables need updated：修訂版本之間的差異

分享此網頁到Facebook
分享此網頁到Plurk
分享此網頁到百度搜藏
分享此網頁到Twitter
分享此網頁到Del.icio.us
最近作者：Minwei 2007年11月30日 (星期五)11:16 ；歷來作者：61.59.239.138和203.73.50.55
台灣棒球維基館
跳轉到: 導覽、 搜尋
（→‎User table）
 
（由2名用戶作出的6個中途修訂版本未被顯示）
第239行： 第239行：
 
+-----------------+-----------------+------+-----+---------+-------+
 
+-----------------+-----------------+------+-----+---------+-------+
 
10 rows in set (0.00 sec)
 
10 rows in set (0.00 sec)
 +
</pre>
 +
= Querycache table =
 +
<pre>
 +
+--------------+---------------------+------+-----+---------+-------+
 +
| Field        | Type                | Null | Key | Default | Extra |
 +
+--------------+---------------------+------+-----+---------+-------+
 +
| qc_type      | char(32)            |      | MUL |        |      |
 +
| qc_value    | int(5) unsigned    |      |    | 0      |      |
 +
| qc_namespace | tinyint(2) unsigned |      |    | 0      |      |
 +
| qc_title    | char(255) binary    |      |    |        |      |
 +
+--------------+---------------------+------+-----+---------+-------+
 +
</pre>
 +
<pre>
 +
+--------------+-----------------+------+-----+---------+-------+
 +
| Field        | Type            | Null | Key | Default | Extra |
 +
+--------------+-----------------+------+-----+---------+-------+
 +
| qc_type      | char(32)        | NO  | MUL | NULL    |      |
 +
| qc_value    | int(5) unsigned | NO  |    | 0      |      |
 +
| qc_namespace | int(11)        | NO  |    | 0      |      |
 +
| qc_title    | char(255)      | NO  |    | NULL    |      |
 +
+--------------+-----------------+------+-----+---------+-------+
 +
</pre>
 +
*<b>qc_namespace</b>:tinyint(2) unsigned→int(11)
 +
 +
= Recentchanges table =
 +
== Fields ==
 +
=== rc_id ===
 +
This is the primary key for the table. (Introduced in MediaWiki 1.5)
 +
===rc_old_len===
 +
{{MW 1.9|and after}}
 +
This field stores the size, in bytes, of previous revision's text. This field is used to generate the added and removed characters feature in [[:m:Help:Recent changes|recent changes]], [[m:help:related changes|related changes]] and [[:m:Help:Watching pages|watchlists]].
 +
 +
===rc_new_len===
 +
{{MW 1.9|and after}}
 +
This field stores the size, in bytes, of the current revision's text. This field is used to generate the added and removed characters feature in [[:m:Help:Recent changes|recent changes]], [[m:help:related changes|related changes]] and [[:m:Help:Watching pages|watchlists]].
 +
 +
===rc_deleted===
 +
{{MW 1.10|and after}}
 +
This field stores a value for this particular revision's visibility within the wiki. It was created to accommodate upcoming revisions to the [[bitfields for rev_deleted|deletion system]]. The field is analogous to [[revision table#rev_deleted|rev_deleted]].
 +
 +
===rc_log_id===
 +
{{MW 1.10|and after}}
 +
This field is a [[:w:foreign key|foreign key]] to the [[logging table]], which links to [[logging table#log_id|log_id]] if this row corresponds to a log entry. The field was introduced in MediaWiki 1.10.
 +
 +
===rc_log_type===
 +
{{MW 1.10|and after}}
 +
If a log action is referenced in this row, this field stores the type of log action that was performed, and which is referenced in this row. Typical values are <code>block, delete, import, makebot, move, newusers, protect, renameuser, rights, upload</code>. This field is comparable to [[logging table#log_type|log_type]].
 +
===rc_log_action===
 +
{{MW 1.10|and after}}
 +
If a log action is referenced in this row, this field stores the type of log action that was performed, and which is referenced in this row. This field is comparable to [[logging table#log_action|log_action]].
 +
 +
===rc_params===
 +
{{MW 1.10|and after}}
 +
This field will be a mirror of [[logging table#log_params|log_params]], following the log_params text rewrite. Introduced in MediaWiki 1.10.
 +
 +
== Schema summary ==
 +
{{MW 1.10}}
 +
'''<tt>DESCRIBE recentchanges</tt>''' in MediaWiki 1.10 gives the following:
 +
<pre>
 +
mysql> describe mw_recentchanges;
 +
+-------------------+---------------------+------+-----+---------+----------------+
 +
| Field            | Type                | Null | Key | Default | Extra          |
 +
+-------------------+---------------------+------+-----+---------+----------------+
 +
| rc_id            | int(8)              | NO  | PRI | NULL    | auto_increment |
 +
| rc_timestamp      | varchar(14)        | NO  | MUL | NULL    |                |
 +
| rc_cur_time      | varchar(14)        | NO  |    | NULL    |                |
 +
| rc_user          | int(10) unsigned    | NO  |    | 0      |                |
 +
| rc_user_text      | varchar(255)        | NO  | MUL | NULL    |                |
 +
| rc_namespace      | int(11)            | NO  | MUL | 0      |                |
 +
| rc_title          | varchar(255)        | NO  |    | NULL    |                |
 +
| rc_comment        | varchar(255)        | NO  |    | NULL    |                |
 +
| rc_minor          | tinyint(3) unsigned | NO  |    | 0      |                |
 +
| rc_bot            | tinyint(3) unsigned | NO  |    | 0      |                |
 +
| rc_new            | tinyint(3) unsigned | NO  | MUL | 0      |                |
 +
| rc_cur_id        | int(10) unsigned    | NO  | MUL | 0      |                |
 +
| rc_this_oldid    | int(10) unsigned    | NO  |    | 0      |                |
 +
| rc_last_oldid    | int(10) unsigned    | NO  |    | 0      |                |
 +
| rc_type          | tinyint(3) unsigned | NO  |    | 0      |                |
 +
| rc_moved_to_ns    | tinyint(3) unsigned | NO  |    | 0      |                |
 +
| rc_moved_to_title | varchar(255)        | NO  |    | NULL    |                |
 +
| rc_patrolled      | tinyint(3) unsigned | NO  |    | 0      |                |
 +
| rc_ip            | char(15)            | NO  | MUL | NULL    |                |
 +
| rc_old_len        | int(10)            | YES  |    | NULL    |                |
 +
| rc_new_len        | int(10)            | YES  |    | NULL    |                |
 +
| rc_deleted        | tinyint(1) unsigned | NO  |    | 0      |                |
 +
| rc_logid          | int(10) unsigned    | NO  |    | 0      |                |
 +
| rc_log_type      | varchar(255)        | YES  |    | NULL    |                |
 +
| rc_params        | blob                | NO  |    | NULL    |                |
 +
+-------------------+---------------------+------+-----+---------+----------------+
 +
25 rows in set (0.24 sec)
 +
</pre>
 +
 +
{{MW 1.4}}
 +
'''<tt>DESCRIBE recentchanges</tt>''' in MediaWiki 1.4 gives the following:
 +
<pre>
 +
+-------------------+---------------------+------+-----+---------+----------------+
 +
| Field            | Type                | Null | Key | Default | Extra          |
 +
+-------------------+---------------------+------+-----+---------+----------------+
 +
| rc_timestamp      | varchar(14)        | NO  | MUL |        |                |
 +
| rc_cur_time      | varchar(14)        | NO  |    |        |                |
 +
| rc_user          | int(10) unsigned    | NO  |    | 0      |                |
 +
| rc_user_text      | varchar(255)        | NO  |    |        |                |
 +
| rc_namespace      | int(11)            | NO  | MUL | 0      |                |
 +
| rc_title          | varchar(255)        | NO  |    |        |                |
 +
| rc_comment        | varchar(255)        | NO  |    |        |                |
 +
| rc_minor          | tinyint(3) unsigned | NO  |    | 0      |                |
 +
| rc_bot            | tinyint(3) unsigned | NO  |    | 0      |                |
 +
| rc_new            | tinyint(3) unsigned | NO  | MUL | 0      |                |
 +
| rc_cur_id        | int(10) unsigned    | NO  | MUL | 0      |                |
 +
| rc_this_oldid    | int(10) unsigned    | NO  |    | 0      |                |
 +
| rc_last_oldid    | int(10) unsigned    | NO  |    | 0      |                |
 +
| rc_type          | tinyint(3) unsigned | NO  |    | 0      |                |
 +
| rc_moved_to_ns    | tinyint(3) unsigned | NO  |    | 0      |                |
 +
| rc_moved_to_title | varchar(255)        | NO  |    |        |                |
 +
| rc_patrolled      | tinyint(3) unsigned | NO  |    | 0      |                |
 +
| rc_ip            | char(15)            | NO  | MUL |        |                |
 +
+-------------------+---------------------+------+-----+---------+----------------+
 +
18 rows in set
 +
</pre>
 +
 +
= Site stats table =
 +
<div class="minwei" style="float:right; border: 1px solid blue; padding: 5px 2px 5px 2px; background-color: #FFFFCC; width:140px" >MediaWiki version: 1.4</div>
 +
<pre>
 +
+------------------+---------------------+------+-----+---------+-------+
 +
| Field            | Type                | Null | Key | Default | Extra |
 +
+------------------+---------------------+------+-----+---------+-------+
 +
| ss_row_id        | int(8) unsigned    |      | PRI | 0      |      |
 +
| ss_total_views  | bigint(20) unsigned | YES  |    | 0      |      |
 +
| ss_total_edits  | bigint(20) unsigned | YES  |    | 0      |      |
 +
| ss_good_articles | bigint(20) unsigned | YES  |    | 0      |      |
 +
+------------------+---------------------+------+-----+---------+-------+
 +
</pre>
 +
<div class="minwei" style="float:right; border: 1px solid blue; padding: 5px 2px 5px 2px; background-color: #FFFFCC; width:140px" >MediaWiki version: 1.9</div>
 +
<pre>
 +
mysql> describe mw_site_stats;
 +
+------------------+---------------------+------+-----+---------+-------+
 +
| Field            | Type                | Null | Key | Default | Extra |
 +
+------------------+---------------------+------+-----+---------+-------+
 +
| ss_row_id        | int(8) unsigned    | NO  | PRI | NULL    |      |
 +
| ss_total_views  | bigint(20) unsigned | YES  |    | 0      |      |
 +
| ss_total_edits  | bigint(20) unsigned | YES  |    | 0      |      |
 +
| ss_good_articles | bigint(20) unsigned | YES  |    | 0      |      |
 +
| ss_total_pages  | bigint(20)          | YES  |    | -1      |      |
 +
| ss_users        | bigint(20)          | YES  |    | -1      |      |
 +
| ss_admins        | int(10)            | YES  |    | -1      |      |
 +
| ss_images        | int(10)            | YES  |    | 0      |      |
 +
+------------------+---------------------+------+-----+---------+-------+
 +
</pre>
 +
 +
= Watchlist table =
 +
<div class="minwei" style="float:right; border: 1px solid blue; padding: 5px 2px 5px 2px; background-color: #FFFFCC; width:140px" >MediaWiki version: 1.4</div>
 +
<pre>
 +
+------------------+---------------------+------+-----+---------+----------------+
 +
| Field              | Type                  | Null | Key | Default  | Extra          |
 +
+------------------+---------------------+------+-----+---------+----------------+
 +
| wl_user            | int(5) unsigned      |      |      |          |                  |
 +
| wl_namespace      | tinyint(2) unsigned  |      |      |    0    |                  |
 +
| wl_title          | varchar(255) binary  |      |      |    ''    |                  |
 +
+------------------+---------------------+------+-----+---------+----------------+
 +
</pre>
 +
<div class="minwei" style="float:right; border: 1px solid blue; padding: 5px 2px 5px 2px; background-color: #FFFFCC; width:140px" >MediaWiki version: 1.9</div>
 +
<pre>
 +
+--------------------------+-----------------+------+-----+---------+-------+
 +
| Field                      | Type              | Null | Key  | Default  | Extra |
 +
+--------------------------+-----------------+------+-----+---------+-------+
 +
| wl_user                    | int(5) unsigned  | NO  | PRI  | NULL    |        |
 +
| wl_namespace              | int(11)          | NO  | PRI  | 0      |        |
 +
| wl_title                  | varchar(255)      | NO  | PRI  | NULL    |        |
 +
| wl_notificationtimestamp  | varchar(14)      | YES  |      | NULL    |        |
 +
+--------------------------+-----------------+------+-----+---------+-------+
 +
</pre>
 +
 +
= User table =
 +
<div class="minwei" style="float:right; border: 1px solid blue; padding: 5px 2px 5px 2px; background-color: #FFFFCC; width:140px" >MediaWiki version: 1.4</div>自行增設的欄位：<br />
 +
*<b>user_real_name</b>:varchar(255);否 (1.5後亦有)
 +
*<b>user_token</b>:varchar(32) (1.5後亦有)
 +
*<b>user_regdate</b>:varchar(14)<div class="minwei" style="float:right; border: 1px solid blue; padding: 5px 2px 5px 2px; background-color: #FFFFFF; width:140px" >請參考:<br />user_edits:[http://twbsball.dils.tku.edu.tw/wiki/index.php/User:台灣阿成/我的工作日誌/2006/08]<br /></div>
 +
*<b>user_regtime</b>:varchar(6)
 +
*<b>user_usetimes</b>:int(11)
 +
*<b>user_edits</b>:bigint(20) 
 +
<pre>
 +
+------------------+---------------------+------+-----+---------+----------------+
 +
| Field            | Type                  | Null | Key | Default | Extra            |
 +
+------------------+---------------------+------+-----+---------+----------------+
 +
| user_id          | int(5) unsigned      |      | PRI  | NULL    | auto_increment  |
 +
| user_name        | varchar(255) binary  |      |      |          |                  |
 +
| user_rights      | tinyblob              |      |      |          |                  |
 +
| user_password    | tinyblob              |      |      |          |                  |
 +
| user_newpassword  | tinyblob              |      |      |          |                  |
 +
| user_email        | tinytext              |      |      |          |                  |
 +
| user_options      | blob                  |      |      |          |                  |
 +
| user_touched      | varchar(14) binary    |      |      |          |                  |
 +
+------------------+---------------------+------+-----+---------+----------------+
 +
</pre>
 +
<div class="minwei" style="float:right; border: 1px solid blue; padding: 5px 2px 5px 2px; background-color: #FFFFCC; width:140px" >MediaWiki version: 1.9</div>
 +
<pre>
 +
+--------------------------+-----------------+------+-----+-------------------+----------------+
 +
| Field                    | Type            | Null | Key | Default          | Extra          |
 +
+--------------------------+-----------------+------+-----+-------------------+----------------+
 +
| user_id                  | int(5) unsigned | NO  | PRI | NULL              | auto_increment |
 +
| user_name                | varchar(255)    | NO  | UNI | NULL              |                |
 +
| user_real_name          | varchar(255)    | NO  |    | NULL              |                |
 +
| user_password            | tinyblob        | NO  |    | NULL              |                |
 +
| user_newpassword        | tinyblob        | NO  |    | NULL              |                |
 +
| user_email              | tinytext        | NO  |    | NULL              |                |
 +
| user_options            | blob            | NO  |    | NULL              |                |
 +
| user_touched            | char(14)        | NO  |    | NULL              |                |
 +
| user_token              | char(32)        | NO  |    | NULL              |                |
 +
| user_email_authenticated | char(14)        | YES  |    | NULL              |                |
 +
| user_email_token        | char(32)        | YES  | MUL | NULL              |                |
 +
| user_email_token_expires | char(14)        | YES  |    | NULL              |                |
 +
| user_registration        | char(14)        | YES  |    | NULL              |                |
 +
| user_newpass_time        | timestamp      | YES  |    | CURRENT_TIMESTAMP |                |
 +
| user_editcount          | int(11)        | YES  |    | NULL              |                |
 +
+--------------------------+-----------------+------+-----+-------------------+----------------+
 
</pre>
 
</pre>

2007年11月30日 (五) 11:16的最新修訂版本

目次

[編輯] Archive table

[編輯] 欄位

[編輯] ar_text

MediaWiki version: 1.4 and before

[編輯] ar_rev_id

MediaWiki version: 1.5 and after

[編輯] ar_text_id

MediaWiki version: 1.5 and after

[編輯] ar_deleted

MediaWiki version: 1.10 and after

[編輯] ar_len

MediaWiki version: 1.10 and after

[編輯] Schema summary

DESCRIBE archive in MediaWiki 1.10 gives the following: 

mysql> describe mw_archive;
+---------------+---------------------+------+-----+---------+-------+
| Field         | Type                | Null | Key | Default | Extra |
+---------------+---------------------+------+-----+---------+-------+
| ar_namespace  | int(11)             | NO   | MUL | 0       |       |
| ar_title      | varchar(255)        | NO   |     | NULL    |       |
| ar_text       | mediumblob          | NO   |     | NULL    |       |
| ar_comment    | tinyblob            | NO   |     | NULL    |       |
| ar_user       | int(5) unsigned     | NO   |     | 0       |       |
| ar_user_text  | varchar(255)        | NO   |     | NULL    |       |
| ar_timestamp  | char(14)            | NO   |     | NULL    |       |
| ar_minor_edit | tinyint(1)          | NO   |     | 0       |       |
| ar_flags      | tinyblob            | NO   |     | NULL    |       |
| ar_rev_id     | int(8) unsigned     | YES  |     | NULL    |       |
| ar_text_id    | int(8) unsigned     | YES  |     | NULL    |       |
| ar_deleted    | tinyint(1) unsigned | NO   |     | 0       |       |
| ar_len        | int(8) unsigned     | YES  |     | NULL    |       |
+---------------+---------------------+------+-----+---------+-------+
13 rows in set (0.02 sec)

DESCRIBE archive in versions before 1.5 gives the following: 

+---------------+---------------------+------+-----+---------+-------+
| Field         | Type                | Null | Key | Default | Extra |
+---------------+---------------------+------+-----+---------+-------+
| ar_namespace  | tinyint(2) unsigned |      |     | 0       |       |
| ar_title      | varchar(255) binary |      |     |         |       |
| ar_text       | mediumtext          |      |     |         |       |
| ar_comment    | tinyblob            |      |     |         |       |
| ar_user       | int(5) unsigned     |      |     | 0       |       |
| ar_user_text  | varchar(255) binary |      |     |         |       |
| ar_timestamp  | varchar(14) binary  |      |     |         |       |
| ar_minor_edit | tinyint(1)          |      |     | 0       |       |
| ar_flags      | tinyblob            |      |     |         |       |
+---------------+---------------------+------+-----+---------+-------+

[編輯] Image table

MediaWiki version: 1.4
+-----------------+---------------------+------+-----+---------+-------+
| Field           | Type                | Null | Key | Default | Extra |
+-----------------+---------------------+------+-----+---------+-------+
| img_name        | varchar(255) binary |      |     |         |       |
| img_size        | int(8) unsigned     |      |     | 0       |       |
| img_description | tinyblob            |      |     |         |       |
| img_user        | int(5) unsigned     |      |     | 0       |       |
| img_user_text   | varchar(255) binary |      |     |         |       |
| img_timestamp   | varchar(14) binary  |      |     |         |       |
+-----------------+---------------------+------+-----+---------+-------+
MediaWiki version: 1.9

mysql> describe mw_image; 

+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field           | Type                                                                                                   | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name        | varchar(255)                                                                                           | NO   | PRI | NULL    |       |
| img_size        | int(8) unsigned                                                                                        | NO   | MUL | 0       |       |
| img_width       | int(5)                                                                                                 | NO   |     | 0       |       |
| img_height      | int(5)                                                                                                 | NO   |     | 0       |       |
| img_metadata    | mediumblob                                                                                             | NO   |     | NULL    |       |
| img_bits        | int(3)                                                                                                 | NO   |     | 0       |       |
| img_media_type  | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES  |     | NULL    |       |
| img_major_mime  | enum('unknown','application','audio','image','text','video','message','model','multipart')             | NO   |     | unknown |       |
| img_minor_mime  | varchar(32)                                                                                            | NO   |     | unknown |       |
| img_description | tinyblob                                                                                               | NO   |     | NULL    |       |
| img_user        | int(5) unsigned                                                                                        | NO   |     | 0       |       |
| img_user_text   | varchar(255)                                                                                           | NO   |     | NULL    |       |
| img_timestamp   | char(14)                                                                                               | NO   | MUL | NULL    |       |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
13 rows in set (0.00 sec)

[編輯] Interwiki table

MediaWiki version: 1.9
iw_local informs MediaWiki how it should treat interwiki links coming from external sources. If iw_local is 1, then it will treat these links as though they were generated from within the local wiki.
For example, the interwiki link fr: on the en.wikipedia.org project has iw_local=1 set. Therefore, the link to http://en.wikipedia.org/wiki/fr:Accueil gracefully redirects you to the French Homepage (Accueil). However, the Wikimedia foundation project site is flagged 0 on en.wikipedia.org; the link to http://en.wikipedia.org/wiki/wikimedia:Home does not work, even though [[wikimedia:Home]] would work if it were on a local Wikipedia page.

iw_trans: is used to allow transcluding templates (or other pages) from another MediaWiki installation. Both $wgEnableScaryTranscluding and iw_trans need to be on. 

mysql> describe mw_interwiki;
+-----------+------------+------+-----+---------+-------+
| Field     | Type       | Null | Key | Default | Extra |
+-----------+------------+------+-----+---------+-------+
| iw_prefix | char(32)   | NO   | PRI | NULL    |       |
| iw_url    | char(127)  | NO   |     | NULL    |       |
| iw_local  | tinyint(1) | NO   |     | NULL    |       |
| iw_trans  | tinyint(1) | NO   |     | 0       |       |
+-----------+------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

[編輯] Ipblocks table

MediaWiki version: 1.4
+----------------------+-----------------+------+-----+---------+----------------+
| Field                | Type            | Null | Key | Default | Extra          |
+----------------------+-----------------+------+-----+---------+----------------+
| ipb_id               | int(8)          | NO   | PRI | NULL    | auto_increment |
| ipb_address          | varchar(40)     | NO   | MUL | NULL    |                |
| ipb_user             | int(8) unsigned | NO   | MUL | 0       |                |
| ipb_by               | int(8) unsigned | NO   |     | 0       |                |
| ipb_reason           | tinyblob BINARY | NO   |     | NULL    |                |
| ipb_timestamp        | varchar(14)     | NO   | MUL | NULL    |                |
| ipb_auto             | tinyint(1)      | NO   |     | 0       |                |
| ipb_anon_only        | tinyint(1)      | NO   |     | 0       |                |
| ipb_expiry           | varchar(14)     | NO   | MUL | NULL    |                |
+----------------------+-----------------+------+-----+---------+----------------+
MediaWiki version: 1.9
mysql> describe mw_ipblocks;
+----------------------+-----------------+------+-----+---------+----------------+
| Field                | Type            | Null | Key | Default | Extra          |
+----------------------+-----------------+------+-----+---------+----------------+
| ipb_id               | int(8)          | NO   | PRI | NULL    | auto_increment |
| ipb_address          | tinyblob        | NO   | MUL | NULL    |                |
| ipb_user             | int(8) unsigned | NO   | MUL | 0       |                |
| ipb_by               | int(8) unsigned | NO   |     | 0       |                |
| ipb_reason           | tinyblob        | NO   |     | NULL    |                |
| ipb_timestamp        | char(14)        | NO   | MUL | NULL    |                |
| ipb_auto             | tinyint(1)      | NO   |     | 0       |                |
| ipb_anon_only        | tinyint(1)      | NO   |     | 0       |                |
| ipb_create_account   | tinyint(1)      | NO   |     | 1       |                |
| ipb_enable_autoblock | tinyint(1)      | NO   |     | 1       |                |
| ipb_expiry           | char(14)        | NO   | MUL | NULL    |                |
| ipb_range_start      | tinyblob        | NO   | MUL | NULL    |                |
| ipb_range_end        | tinyblob        | NO   |     | NULL    |                |
+----------------------+-----------------+------+-----+---------+----------------+
13 rows in set (0.00 sec)

[編輯] Logging table

MediaWiki version: 1.5
See Logging_table for more detail. 
+---------------+------------------+------+-----+----------------+-------+
| Field         | Type             | Null | Key | Default        | Extra |
+---------------+------------------+------+-----+----------------+-------+
| log_type      | char(10)         | NO   | MUL |                |       |
| log_action    | char(10)         | NO   |     |                |       |
| log_timestamp | char(14)         | NO   |     | 19700101000000 |       |
| log_user      | int(10) unsigned | NO   | MUL | 0              |       |
| log_namespace | int(11)          | NO   | MUL | 0              |       |
| log_title     | varchar(255)     | NO   |     |                |       |
| log_comment   | varchar(255)     | NO   |     |                |       |
| log_params    | blob             | NO   |     |                |       |
+---------------+------------------+------+-----+----------------+-------+
MediaWiki version: 1.10
mysql> describe mw_logging;
+---------------+------------------+------+-----+----------------+----------------+
| Field         | Type             | Null | Key | Default        | Extra          |
+---------------+------------------+------+-----+----------------+----------------+
| log_type      | char(10)         | NO   | MUL | NULL           |                |
| log_action    | char(10)         | NO   |     | NULL           |                |
| log_timestamp | char(14)         | NO   | MUL | 19700101000000 |                |
| log_user      | int(10) unsigned | NO   | MUL | 0              |                |
| log_namespace | int(11)          | NO   | MUL | 0              |                |
| log_title     | varchar(255)     | NO   |     | NULL           |                |
| log_comment   | varchar(255)     | NO   |     | NULL           |                |
| log_params    | blob             | NO   |     | NULL           |                |
| log_id        | int(10) unsigned | NO   | PRI | NULL           | auto_increment |
+---------------+------------------+------+-----+----------------+----------------+
9 rows in set (0.02 sec)

[編輯] Objectcache table

MediaWiki version: 1.4
+---------+---------------------+------+-----+---------+-------+
| Field   | Type                | Null | Key | Default | Extra |
+---------+---------------------+------+-----+---------+-------+
| keyname | varchar(255) binary |      | PRI |         |       |
| value   | mediumblob          | YES  |     | NULL    |       |
| exptime | datetime            | YES  | MUL | NULL    |       |
+---------+---------------------+------+-----+---------+-------+

+---------+------------+------+-----+---------+-------+
| Field   | Type       | Null | Key | Default | Extra |
+---------+------------+------+-----+---------+-------+
| keyname | char(255)  | NO   | PRI | NULL    |       |
| value   | mediumblob | YES  |     | NULL    |       |
| exptime | datetime   | YES  | MUL | NULL    |       |
+---------+------------+------+-----+---------+-------+

[編輯] Oldimage table

MediaWiki version: 1.4
 +-----------------+---------------------+------+-----+---------+-------+
 | Field           | Type                | Null | Key | Default | Extra |
 +-----------------+---------------------+------+-----+---------+-------+
 | oi_name         | varchar(255) binary |      | MUL |         |       |
 | oi_archive_name | varchar(255) binary |      |     |         |       |
 | oi_size         | int(8) unsigned     |      |     | 0       |       |
 | oi_description  | tinyblob            |      |     |         |       |
 | oi_user         | int(5) unsigned     |      |     | 0       |       |
 | oi_user_text    | varchar(255) binary |      |     |         |       |
 | oi_timestamp    | varchar(14) binary  |      |     |         |       |
 +-----------------+---------------------+------+-----+---------+-------+
MediaWiki version: 1.9
mysql> describe mw_oldimage;
+-----------------+-----------------+------+-----+---------+-------+
| Field           | Type            | Null | Key | Default | Extra |
+-----------------+-----------------+------+-----+---------+-------+
| oi_name         | varchar(255)    | NO   | MUL | NULL    |       |
| oi_archive_name | varchar(255)    | NO   |     | NULL    |       |
| oi_size         | int(8) unsigned | NO   |     | 0       |       |
| oi_width        | int(5)          | NO   |     | 0       |       |
| oi_height       | int(5)          | NO   |     | 0       |       |
| oi_bits         | int(3)          | NO   |     | 0       |       |
| oi_description  | tinyblob        | NO   |     | NULL    |       |
| oi_user         | int(5) unsigned | NO   |     | 0       |       |
| oi_user_text    | varchar(255)    | NO   |     | NULL    |       |
| oi_timestamp    | char(14)        | NO   |     | NULL    |       |
+-----------------+-----------------+------+-----+---------+-------+
10 rows in set (0.00 sec)

[編輯] Querycache table 

+--------------+---------------------+------+-----+---------+-------+
| Field        | Type                | Null | Key | Default | Extra |
+--------------+---------------------+------+-----+---------+-------+
| qc_type      | char(32)            |      | MUL |         |       |
| qc_value     | int(5) unsigned     |      |     | 0       |       |
| qc_namespace | tinyint(2) unsigned |      |     | 0       |       |
| qc_title     | char(255) binary    |      |     |         |       |
+--------------+---------------------+------+-----+---------+-------+

+--------------+-----------------+------+-----+---------+-------+
| Field        | Type            | Null | Key | Default | Extra |
+--------------+-----------------+------+-----+---------+-------+
| qc_type      | char(32)        | NO   | MUL | NULL    |       |
| qc_value     | int(5) unsigned | NO   |     | 0       |       |
| qc_namespace | int(11)         | NO   |     | 0       |       |
| qc_title     | char(255)       | NO   |     | NULL    |       |
+--------------+-----------------+------+-----+---------+-------+
  • qc_namespace:tinyint(2) unsigned→int(11)

[編輯] Recentchanges table

[編輯] Fields

[編輯] rc_id

This is the primary key for the table. (Introduced in MediaWiki 1.5)

[編輯] rc_old_len

模板:MW 1.9 This field stores the size, in bytes, of previous revision's text. This field is used to generate the added and removed characters feature in recent changes, related changes and watchlists.

[編輯] rc_new_len

模板:MW 1.9 This field stores the size, in bytes, of the current revision's text. This field is used to generate the added and removed characters feature in recent changes, related changes and watchlists.

[編輯] rc_deleted

模板:MW 1.10 This field stores a value for this particular revision's visibility within the wiki. It was created to accommodate upcoming revisions to the deletion system. The field is analogous to rev_deleted.

[編輯] rc_log_id

模板:MW 1.10 This field is a foreign key to the logging table, which links to log_id if this row corresponds to a log entry. The field was introduced in MediaWiki 1.10.

[編輯] rc_log_type

模板:MW 1.10 If a log action is referenced in this row, this field stores the type of log action that was performed, and which is referenced in this row. Typical values are block, delete, import, makebot, move, newusers, protect, renameuser, rights, upload. This field is comparable to log_type.

[編輯] rc_log_action

模板:MW 1.10 If a log action is referenced in this row, this field stores the type of log action that was performed, and which is referenced in this row. This field is comparable to log_action.

[編輯] rc_params

模板:MW 1.10 This field will be a mirror of log_params, following the log_params text rewrite. Introduced in MediaWiki 1.10.

[編輯] Schema summary

模板:MW 1.10 DESCRIBE recentchanges in MediaWiki 1.10 gives the following: 

mysql> describe mw_recentchanges;
+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| rc_id             | int(8)              | NO   | PRI | NULL    | auto_increment |
| rc_timestamp      | varchar(14)         | NO   | MUL | NULL    |                |
| rc_cur_time       | varchar(14)         | NO   |     | NULL    |                |
| rc_user           | int(10) unsigned    | NO   |     | 0       |                |
| rc_user_text      | varchar(255)        | NO   | MUL | NULL    |                |
| rc_namespace      | int(11)             | NO   | MUL | 0       |                |
| rc_title          | varchar(255)        | NO   |     | NULL    |                |
| rc_comment        | varchar(255)        | NO   |     | NULL    |                |
| rc_minor          | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_bot            | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_new            | tinyint(3) unsigned | NO   | MUL | 0       |                |
| rc_cur_id         | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_this_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_last_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_type           | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_moved_to_ns    | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_moved_to_title | varchar(255)        | NO   |     | NULL    |                |
| rc_patrolled      | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_ip             | char(15)            | NO   | MUL | NULL    |                |
| rc_old_len        | int(10)             | YES  |     | NULL    |                |
| rc_new_len        | int(10)             | YES  |     | NULL    |                |
| rc_deleted        | tinyint(1) unsigned | NO   |     | 0       |                |
| rc_logid          | int(10) unsigned    | NO   |     | 0       |                |
| rc_log_type       | varchar(255)        | YES  |     | NULL    |                |
| rc_params         | blob                | NO   |     | NULL    |                |
+-------------------+---------------------+------+-----+---------+----------------+
25 rows in set (0.24 sec)

模板:MW 1.4 DESCRIBE recentchanges in MediaWiki 1.4 gives the following: 

+-------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                | Null | Key | Default | Extra          |
+-------------------+---------------------+------+-----+---------+----------------+
| rc_timestamp      | varchar(14)         | NO   | MUL |         |                |
| rc_cur_time       | varchar(14)         | NO   |     |         |                |
| rc_user           | int(10) unsigned    | NO   |     | 0       |                |
| rc_user_text      | varchar(255)        | NO   |     |         |                |
| rc_namespace      | int(11)             | NO   | MUL | 0       |                |
| rc_title          | varchar(255)        | NO   |     |         |                |
| rc_comment        | varchar(255)        | NO   |     |         |                |
| rc_minor          | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_bot            | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_new            | tinyint(3) unsigned | NO   | MUL | 0       |                |
| rc_cur_id         | int(10) unsigned    | NO   | MUL | 0       |                |
| rc_this_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_last_oldid     | int(10) unsigned    | NO   |     | 0       |                |
| rc_type           | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_moved_to_ns    | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_moved_to_title | varchar(255)        | NO   |     |         |                |
| rc_patrolled      | tinyint(3) unsigned | NO   |     | 0       |                |
| rc_ip             | char(15)            | NO   | MUL |         |                |
+-------------------+---------------------+------+-----+---------+----------------+
18 rows in set

[編輯] Site stats table

MediaWiki version: 1.4
+------------------+---------------------+------+-----+---------+-------+
| Field            | Type                | Null | Key | Default | Extra |
+------------------+---------------------+------+-----+---------+-------+
| ss_row_id        | int(8) unsigned     |      | PRI | 0       |       |
| ss_total_views   | bigint(20) unsigned | YES  |     | 0       |       |
| ss_total_edits   | bigint(20) unsigned | YES  |     | 0       |       |
| ss_good_articles | bigint(20) unsigned | YES  |     | 0       |       |
+------------------+---------------------+------+-----+---------+-------+
MediaWiki version: 1.9
mysql> describe mw_site_stats;
+------------------+---------------------+------+-----+---------+-------+
| Field            | Type                | Null | Key | Default | Extra |
+------------------+---------------------+------+-----+---------+-------+
| ss_row_id        | int(8) unsigned     | NO   | PRI | NULL    |       |
| ss_total_views   | bigint(20) unsigned | YES  |     | 0       |       |
| ss_total_edits   | bigint(20) unsigned | YES  |     | 0       |       |
| ss_good_articles | bigint(20) unsigned | YES  |     | 0       |       |
| ss_total_pages   | bigint(20)          | YES  |     | -1      |       |
| ss_users         | bigint(20)          | YES  |     | -1      |       |
| ss_admins        | int(10)             | YES  |     | -1      |       |
| ss_images        | int(10)             | YES  |     | 0       |       |
+------------------+---------------------+------+-----+---------+-------+

[編輯] Watchlist table

MediaWiki version: 1.4
+------------------+---------------------+------+-----+---------+----------------+
| Field              | Type                  | Null | Key | Default  | Extra           |
+------------------+---------------------+------+-----+---------+----------------+
| wl_user            | int(5) unsigned      |      |      |          |                  |
| wl_namespace       | tinyint(2) unsigned  |      |      |    0     |                  |
| wl_title           | varchar(255) binary  |      |      |    ''    |                  |
+------------------+---------------------+------+-----+---------+----------------+
MediaWiki version: 1.9
+--------------------------+-----------------+------+-----+---------+-------+
| Field                      | Type              | Null | Key  | Default  | Extra |
+--------------------------+-----------------+------+-----+---------+-------+
| wl_user                    | int(5) unsigned  | NO   | PRI  | NULL    |        |
| wl_namespace               | int(11)           | NO   | PRI  | 0       |        |
| wl_title                   | varchar(255)      | NO   | PRI  | NULL    |        |
| wl_notificationtimestamp   | varchar(14)       | YES  |      | NULL    |        |
+--------------------------+-----------------+------+-----+---------+-------+

[編輯] User table

MediaWiki version: 1.4
自行增設的欄位：
  • user_real_name:varchar(255);否 (1.5後亦有)
  • user_token:varchar(32) (1.5後亦有)
  • user_regdate:varchar(14)
    請參考:
    user_edits:[1]
  • user_regtime:varchar(6)
  • user_usetimes:int(11)
  • user_edits:bigint(20) 
+------------------+---------------------+------+-----+---------+----------------+
| Field             | Type                   | Null | Key | Default | Extra            |
+------------------+---------------------+------+-----+---------+----------------+
| user_id           | int(5) unsigned       |      | PRI  | NULL    | auto_increment  |
| user_name         | varchar(255) binary   |      |      |          |                  |
| user_rights       | tinyblob              |      |      |          |                  |
| user_password     | tinyblob              |      |      |          |                  |
| user_newpassword  | tinyblob              |      |      |          |                  |
| user_email        | tinytext              |      |      |          |                  |
| user_options      | blob                  |      |      |          |                  |
| user_touched      | varchar(14) binary    |      |      |          |                  |
+------------------+---------------------+------+-----+---------+----------------+
MediaWiki version: 1.9
+--------------------------+-----------------+------+-----+-------------------+----------------+
| Field                    | Type            | Null | Key | Default           | Extra          |
+--------------------------+-----------------+------+-----+-------------------+----------------+
| user_id                  | int(5) unsigned | NO   | PRI | NULL              | auto_increment |
| user_name                | varchar(255)    | NO   | UNI | NULL              |                |
| user_real_name           | varchar(255)    | NO   |     | NULL              |                |
| user_password            | tinyblob        | NO   |     | NULL              |                |
| user_newpassword         | tinyblob        | NO   |     | NULL              |                |
| user_email               | tinytext        | NO   |     | NULL              |                |
| user_options             | blob            | NO   |     | NULL              |                |
| user_touched             | char(14)        | NO   |     | NULL              |                |
| user_token               | char(32)        | NO   |     | NULL              |                |
| user_email_authenticated | char(14)        | YES  |     | NULL              |                |
| user_email_token         | char(32)        | YES  | MUL | NULL              |                |
| user_email_token_expires | char(14)        | YES  |     | NULL              |                |
| user_registration        | char(14)        | YES  |     | NULL              |                |
| user_newpass_time        | timestamp       | YES  |     | CURRENT_TIMESTAMP |                |
| user_editcount           | int(11)         | YES  |     | NULL              |                |
+--------------------------+-----------------+------+-----+-------------------+----------------+
取自 "http://twbsball.dils.tku.edu.tw/wiki/index.php?title=使用者:Minwei/維基筆記/Schema轉換/Tables_need_updated&oldid=216497"