|
|
本館粉絲專頁 |
|
|
使用者:Minwei/維基筆記/Schema轉換/Unalterable Tables：修訂版本之間的差異
台灣棒球維基館
< 使用者:Minwei | 維基筆記 | Schema轉換
| 第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> | ||
2007年11月29日 (四) 10:15的修訂版本
目次 |
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)
