|
|
本館粉絲專頁 |
|
|
使用者:Minwei/維基筆記/Schema轉換/Tables need updated：修訂版本之間的差異
台灣棒球維基館
< 使用者:Minwei | 維基筆記 | Schema轉換
（→Image table） |
|||
| 第73行： | 第73行： | ||
<div class="minwei" style="float:right; border: 1px solid blue; padding: 5px 2px 5px 2px; background-color: #FFFFCC; width:150px" >MediaWiki version: 1.9</div> | <div class="minwei" style="float:right; border: 1px solid blue; padding: 5px 2px 5px 2px; background-color: #FFFFCC; width:150px" >MediaWiki version: 1.9</div> | ||
mysql> describe mw_image; | mysql> describe mw_image; | ||
| + | <pre> | ||
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | ||
| Field | Type | Null | Key | Default | Extra | | | Field | Type | Null | Key | Default | Extra | | ||
| 第91行： | 第92行： | ||
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | ||
13 rows in set (0.00 sec) | 13 rows in set (0.00 sec) | ||
| + | </pre> | ||
2007年11月22日 (四) 19:57的修訂版本
目次 |
Archive table
欄位
ar_text
MediaWiki version: 1.4 and before
ar_rev_id
MediaWiki version: 1.5 and after
ar_text_id
MediaWiki version: 1.5 and after
ar_deleted
MediaWiki version: 1.10 and after
ar_len
MediaWiki version: 1.10 and after
Schema summary
DESCRIBE archive in MediaWiki 1.10 gives the following:
mysql> describe mw_archive; +---------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+---------+-------+ | ar_namespace | int(11) | NO | MUL | 0 | | | ar_title | varchar(255) | NO | | NULL | | | ar_text | mediumblob | NO | | NULL | | | ar_comment | tinyblob | NO | | NULL | | | ar_user | int(5) unsigned | NO | | 0 | | | ar_user_text | varchar(255) | NO | | NULL | | | ar_timestamp | char(14) | NO | | NULL | | | ar_minor_edit | tinyint(1) | NO | | 0 | | | ar_flags | tinyblob | NO | | NULL | | | ar_rev_id | int(8) unsigned | YES | | NULL | | | ar_text_id | int(8) unsigned | YES | | NULL | | | ar_deleted | tinyint(1) unsigned | NO | | 0 | | | ar_len | int(8) unsigned | YES | | NULL | | +---------------+---------------------+------+-----+---------+-------+ 13 rows in set (0.02 sec)
DESCRIBE archive in versions before 1.5 gives the following:
+---------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+---------+-------+ | ar_namespace | tinyint(2) unsigned | | | 0 | | | ar_title | varchar(255) binary | | | | | | ar_text | mediumtext | | | | | | ar_comment | tinyblob | | | | | | ar_user | int(5) unsigned | | | 0 | | | ar_user_text | varchar(255) binary | | | | | | ar_timestamp | varchar(14) binary | | | | | | ar_minor_edit | tinyint(1) | | | 0 | | | ar_flags | tinyblob | | | | | +---------------+---------------------+------+-----+---------+-------+
Image table
MediaWiki version: 1.4
+-----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------------------+------+-----+---------+-------+ | img_name | varchar(255) binary | | | | | | img_size | int(8) unsigned | | | 0 | | | img_description | tinyblob | | | | | | img_user | int(5) unsigned | | | 0 | | | img_user_text | varchar(255) binary | | | | | | img_timestamp | varchar(14) binary | | | | | +-----------------+---------------------+------+-----+---------+-------+
MediaWiki version: 1.9
mysql> describe mw_image;
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name | varchar(255) | NO | PRI | NULL | |
| img_size | int(8) unsigned | NO | MUL | 0 | |
| img_width | int(5) | NO | | 0 | |
| img_height | int(5) | NO | | 0 | |
| img_metadata | mediumblob | NO | | NULL | |
| img_bits | int(3) | NO | | 0 | |
| img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | |
| img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') | NO | | unknown | |
| img_minor_mime | varchar(32) | NO | | unknown | |
| img_description | tinyblob | NO | | NULL | |
| img_user | int(5) unsigned | NO | | 0 | |
| img_user_text | varchar(255) | NO | | NULL | |
| img_timestamp | char(14) | NO | MUL | NULL | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
13 rows in set (0.00 sec)
