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

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)