|
|
本館粉絲專頁 |
|
|
使用者:Minwei/維基筆記/Schema轉換/Unalterable Tables：修訂版本之間的差異
台灣棒球維基館
< 使用者:Minwei | 維基筆記 | Schema轉換
| 第20行： | 第20行： | ||
+---------+-----------------+------+-----+---------+-------+ | +---------+-----------------+------+-----+---------+-------+ | ||
</pre> | </pre> | ||
| + | = 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) | ||
2007年11月28日 (三) 21:11的修訂版本
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)
