使用者: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)