使用者:Minwei/維基筆記/Schema轉換/Unalterable Tables

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.