本館粉絲專頁

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

分享此網頁到Facebook
分享此網頁到Plurk
分享此網頁到百度搜藏
分享此網頁到Twitter
分享此網頁到Del.icio.us
最近作者：203.73.69.231 2007年11月30日 (星期五)21:02 ；歷來作者：Minwei、61.59.239.138和其他...
台灣棒球維基館
跳轉到: 導覽、 搜尋
 
 
（由3名用戶作出的4個中途修訂版本未被顯示）
第1行： 第1行：
 +
= Categorylinks table =
 +
<div class="minwei" style="float:right; border: 1px solid blue; padding: 5px 2px 5px 2px; background-color: #FFFFCC; width:210px" >MediaWiki version: 1.9 and after</div>屬性有小變動。
 +
<pre>mysql> describe mw_categorylinks;
 +
 +
+--------------+-----------------+------+-----+-------------------+-------+
 +
| Field        | Type            | Null | Key | Default          | Extra |
 +
+--------------+-----------------+------+-----+-------------------+-------+
 +
| cl_from      | int(8) unsigned | NO  | PRI | 0                |      |
 +
| cl_to        | varchar(255)    | NO  | PRI | NULL              |      |
 +
| cl_sortkey  | varchar(86)    | NO  |    | NULL              |      |
 +
| cl_timestamp | timestamp      | YES  |    | CURRENT_TIMESTAMP |      |
 +
+--------------+-----------------+------+-----+-------------------+-------+
 +
4 rows in set (0.02 sec)</pre>
 +
 
= Hitcounter table =
 
= Hitcounter table =
 
<div class="minwei" style="float:right; border: 1px solid blue; padding: 5px 2px 5px 2px; background-color: #FFFFCC; width:230px" >MediaWiki version: 1.3 and after</div>
 
<div class="minwei" style="float:right; border: 1px solid blue; padding: 5px 2px 5px 2px; background-color: #FFFFCC; width:230px" >MediaWiki version: 1.3 and after</div>
第4行： 第18行：
 
mysql> describe mw_hitcounter;
 
mysql> describe mw_hitcounter;
 
+-------+------------------+------+-----+---------+-------+
 
+-------+------------------+------+-----+---------+-------+
−
| Field | Type             | Null | Key | Default | Extra |
+
| Field | Type             | Null | Key | Default | Extra |
 
+-------+------------------+------+-----+---------+-------+
 
+-------+------------------+------+-----+---------+-------+
−
| hc_id | int(10) unsigned | NO   |    | NULL   |      |
+
| hc_id | int(10) unsigned | NO   |    | NULL     |      |
 
+-------+------------------+------+-----+---------+-------+
 
+-------+------------------+------+-----+---------+-------+
 
1 row in set (0.00 sec)
 
1 row in set (0.00 sec)
 
</pre>
 
</pre>
 +
= Imagelinks table =
 +
<div class="minwei" style="float:right; border: 1px solid blue; padding: 5px 2px 5px 2px; background-color: #FFFFCC; width:230px" >MediaWiki version: 1.3 and after</div>
 +
<pre>
 +
+---------+-----------------+------+-----+---------+-------+
 +
| Field    | Type            | Null | Key  | Default | Extra  |
 +
+---------+-----------------+------+-----+---------+-------+
 +
| il_from | int(8) unsigned  | NO  | PRI  | 0        |      |
 +
| il_to  | varchar(255)      | NO  | PRI  | NULL    |      |
 +
+---------+-----------------+------+-----+---------+-------+
 +
</pre>
 +
= Math table =
 +
<pre>
 +
mysql> describe mw_math;
 +
+----------------------------+-------------+------+-----+---------+-------+
 +
| Field                        | Type        | Null | Key | Default  | Extra |
 +
+----------------------------+-------------+------+-----+---------+-------+
 +
| math_inputhash              | varchar(16)  | NO    | PRI | NULL    |        |
 +
| math_outputhash              | varchar(16)  | NO    |      | NULL    |      |
 +
| math_html_conservativeness  | tinyint(1)  | NO    |    | NULL    |        |
 +
| math_html                    | text        | YES  |      | NULL    |        |
 +
| math_mathml                  | text        | YES  |      | NULL    |        |
 +
+----------------------------+-------------+------+-----+---------+-------+
 +
5 rows in set (0.00 sec)
 +
</pre>
 +
 +
= User groups table =
 +
The '''user groups table''' maps the users in a particular MediaWiki installation to their corresponding [[http://www.mediawiki.org/wiki/Help:User_rights user rights]]. Each group can be assigned a mixture of permissions through [[Manual:LocalSettings.php|LocalSettings.php]] or via extensions; all users of a particular group have those permissions granted to them as a result of their membership in the group. As the table is separate from the [[user table]], this allows for the creation of a shared user database with permissions that vary from wiki to wiki within a wiki farm. This table was introduced on [http://svn.wikimedia.org/viewvc/mediawiki/trunk/phase3/maintenance/tables.sql?revision=5648&view=markup r5648], in MediaWiki 1.5.<div class="minwei" style="float:right; border: 1px solid blue; padding: 5px 2px 5px 2px; background-color: #FFFFCC; width:130px" >MediaWiki version: 1.5</div>
 +
在nadp裡面，被分割成「<b>user_rights</b>」資料表。
 +
<pre>
 +
+----------+-----------------+------+-----+---------+-------+
 +
| Field    | Type            | Null  | Key | Default | Extra  |
 +
+----------+-----------------+------+-----+---------+-------+
 +
| ug_user  | int(5) unsigned  | NO  | PRI | 0        |        |
 +
| ug_group  | char(16)        | NO  | PRI | NULL    |        |
 +
+----------+-----------------+------+-----+---------+-------+
 +
</pre>
 +
In a default mediaWiki installation, ug_group can be one of the following :
 +
<pre>
 +
query : SELECT DISTINCT ug_group FROM user_groups;
 +
+------------+
 +
| ug_group    |
 +
+------------+
 +
| bot        |
 +
| bureaucrat  |
 +
| checkuser  |
 +
| developer  |
 +
| steward    |
 +
| sysop      |
 +
+------------+
 +
</pre>
 +
 +
= User newtalk table =
 +
<pre>
 +
mysql> describe mw_user_newtalk;
 +
+---------+-------------+------+-----+---------+-------+
 +
| Field    | Type        | Null | Key | Default  | Extra |
 +
+---------+-------------+------+-----+---------+-------+
 +
| user_id | int(5)      | NO    | MUL | 0        |      |
 +
| user_ip | varchar(40)  | NO    | MUL | NULL    |      |
 +
+---------+-------------+------+-----+---------+-------+
 +
2 rows in set (0.03 sec)
 +
</pre>
 +
 +
= Validate table =
 +
It is was, and still is used as part of Extension:Review, however, no core software needs it.

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

目次

[編輯] Categorylinks table

MediaWiki version: 1.9 and after
屬性有小變動。 
mysql> describe mw_categorylinks;

+--------------+-----------------+------+-----+-------------------+-------+
| Field        | Type            | Null | Key | Default           | Extra |
+--------------+-----------------+------+-----+-------------------+-------+
| cl_from      | int(8) unsigned | NO   | PRI | 0                 |       |
| cl_to        | varchar(255)    | NO   | PRI | NULL              |       |
| cl_sortkey   | varchar(86)     | NO   |     | NULL              |       |
| cl_timestamp | timestamp       | YES  |     | CURRENT_TIMESTAMP |       |
+--------------+-----------------+------+-----+-------------------+-------+
4 rows in set (0.02 sec)

[編輯] Hitcounter table

MediaWiki version: 1.3 and after
mysql> describe mw_hitcounter;
+-------+------------------+------+-----+---------+-------+
| Field | Type              | Null  | Key | Default  | Extra |
+-------+------------------+------+-----+---------+-------+
| hc_id | int(10) unsigned  | NO    |     | NULL     |       |
+-------+------------------+------+-----+---------+-------+
1 row in set (0.00 sec)

[編輯] Imagelinks table

MediaWiki version: 1.3 and after
+---------+-----------------+------+-----+---------+-------+
| Field    | Type             | Null | Key  | Default | Extra  |
+---------+-----------------+------+-----+---------+-------+
| il_from | int(8) unsigned  | NO   | PRI  | 0        |       |
| il_to   | varchar(255)      | NO   | PRI  | NULL     |       |
+---------+-----------------+------+-----+---------+-------+

[編輯] Math table 

mysql> describe mw_math;
+----------------------------+-------------+------+-----+---------+-------+
| Field                         | Type         | Null | Key | Default  | Extra |
+----------------------------+-------------+------+-----+---------+-------+
| math_inputhash               | varchar(16)  | NO    | PRI | NULL    |        |
| math_outputhash              | varchar(16)  | NO    |      | NULL    |       |
| math_html_conservativeness   | tinyint(1)   | NO    |     | NULL    |        |
| math_html                    | text         | YES   |      | NULL    |        |
| math_mathml                  | text         | YES   |      | NULL    |        |
+----------------------------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

[編輯] User groups table

The user groups table maps the users in a particular MediaWiki installation to their corresponding [user rights]. Each group can be assigned a mixture of permissions through LocalSettings.php or via extensions; all users of a particular group have those permissions granted to them as a result of their membership in the group. As the table is separate from the user table, this allows for the creation of a shared user database with permissions that vary from wiki to wiki within a wiki farm. This table was introduced on r5648, in MediaWiki 1.5.
MediaWiki version: 1.5

在nadp裡面，被分割成「user_rights」資料表。 

+----------+-----------------+------+-----+---------+-------+
| Field     | Type             | Null  | Key | Default | Extra  |
+----------+-----------------+------+-----+---------+-------+
| ug_user   | int(5) unsigned  | NO   | PRI | 0        |        |
| ug_group  | char(16)         | NO   | PRI | NULL     |        |
+----------+-----------------+------+-----+---------+-------+

In a default mediaWiki installation, ug_group can be one of the following : 

 query : SELECT DISTINCT ug_group FROM user_groups;
+------------+
| ug_group    |
+------------+
| bot         |
| bureaucrat  |
| checkuser   |
| developer   |
| steward     |
| sysop       |
+------------+

[編輯] User newtalk table 

mysql> describe mw_user_newtalk;
+---------+-------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default  | Extra |
+---------+-------------+------+-----+---------+-------+
| user_id | int(5)       | NO    | MUL | 0        |       |
| user_ip | varchar(40)  | NO    | MUL | NULL     |       |
+---------+-------------+------+-----+---------+-------+
2 rows in set (0.03 sec)

[編輯] Validate table

It is was, and still is used as part of Extension:Review, however, no core software needs it.

取自 "http://twbsball.dils.tku.edu.tw/wiki/index.php?title=使用者:Minwei/維基筆記/Schema轉換/Unalterable_Tables&oldid=216495"