|
|
本館粉絲專頁 |
|
|
使用者:Minwei/維基筆記/Schema轉換/Tables need updated：修訂版本之間的差異
台灣棒球維基館
< 使用者:Minwei | 維基筆記 | Schema轉換
| 第204行： | 第204行： | ||
| exptime | datetime | YES | MUL | NULL | | | | exptime | datetime | YES | MUL | NULL | | | ||
+---------+------------+------+-----+---------+-------+ | +---------+------------+------+-----+---------+-------+ | ||
| + | </pre> | ||
| + | |||
| + | = Oldimage table = | ||
| + | <div class="minwei" style="float:right; border: 1px solid blue; padding: 5px 2px 5px 2px; background-color: #FFFFCC; width:150px" >MediaWiki version: 1.4</div> | ||
| + | <pre> | ||
| + | +-----------------+---------------------+------+-----+---------+-------+ | ||
| + | | Field | Type | Null | Key | Default | Extra | | ||
| + | +-----------------+---------------------+------+-----+---------+-------+ | ||
| + | | oi_name | varchar(255) binary | | MUL | | | | ||
| + | | oi_archive_name | varchar(255) binary | | | | | | ||
| + | | oi_size | int(8) unsigned | | | 0 | | | ||
| + | | oi_description | tinyblob | | | | | | ||
| + | | oi_user | int(5) unsigned | | | 0 | | | ||
| + | | oi_user_text | varchar(255) binary | | | | | | ||
| + | | oi_timestamp | varchar(14) binary | | | | | | ||
| + | +-----------------+---------------------+------+-----+---------+-------+ | ||
| + | </pre> | ||
| + | <div class="minwei" style="float:right; border: 1px solid blue; padding: 5px 2px 5px 2px; background-color: #FFFFCC; width:150px" >MediaWiki version: <b>1.9</b></div> | ||
| + | <pre> | ||
| + | mysql> describe mw_oldimage; | ||
| + | +-----------------+-----------------+------+-----+---------+-------+ | ||
| + | | Field | Type | Null | Key | Default | Extra | | ||
| + | +-----------------+-----------------+------+-----+---------+-------+ | ||
| + | | oi_name | varchar(255) | NO | MUL | NULL | | | ||
| + | | oi_archive_name | varchar(255) | NO | | NULL | | | ||
| + | | oi_size | int(8) unsigned | NO | | 0 | | | ||
| + | | oi_width | int(5) | NO | | 0 | | | ||
| + | | oi_height | int(5) | NO | | 0 | | | ||
| + | | oi_bits | int(3) | NO | | 0 | | | ||
| + | | oi_description | tinyblob | NO | | NULL | | | ||
| + | | oi_user | int(5) unsigned | NO | | 0 | | | ||
| + | | oi_user_text | varchar(255) | NO | | NULL | | | ||
| + | | oi_timestamp | char(14) | NO | | NULL | | | ||
| + | +-----------------+-----------------+------+-----+---------+-------+ | ||
| + | 10 rows in set (0.00 sec) | ||
</pre> | </pre> | ||
2007年11月28日 (三) 21:25的修訂版本
目次 |
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)
Interwiki table
MediaWiki version: 1.9
iw_local informs MediaWiki how it should treat interwiki links coming from external sources. If iw_local is 1, then it will treat these links as though they were generated from within the local wiki.
- For example, the interwiki link fr: on the en.wikipedia.org project has iw_local=1 set. Therefore, the link to http://en.wikipedia.org/wiki/fr:Accueil gracefully redirects you to the French Homepage (Accueil). However, the Wikimedia foundation project site is flagged 0 on en.wikipedia.org; the link to http://en.wikipedia.org/wiki/wikimedia:Home does not work, even though [[wikimedia:Home]] would work if it were on a local Wikipedia page.
iw_trans: is used to allow transcluding templates (or other pages) from another MediaWiki installation. Both $wgEnableScaryTranscluding and iw_trans need to be on.
mysql> describe mw_interwiki; +-----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------+------+-----+---------+-------+ | iw_prefix | char(32) | NO | PRI | NULL | | | iw_url | char(127) | NO | | NULL | | | iw_local | tinyint(1) | NO | | NULL | | | iw_trans | tinyint(1) | NO | | 0 | | +-----------+------------+------+-----+---------+-------+ 4 rows in set (0.00 sec)
Ipblocks table
MediaWiki version: 1.4
+----------------------+-----------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+-----------------+------+-----+---------+----------------+ | ipb_id | int(8) | NO | PRI | NULL | auto_increment | | ipb_address | varchar(40) | NO | MUL | NULL | | | ipb_user | int(8) unsigned | NO | MUL | 0 | | | ipb_by | int(8) unsigned | NO | | 0 | | | ipb_reason | tinyblob BINARY | NO | | NULL | | | ipb_timestamp | varchar(14) | NO | MUL | NULL | | | ipb_auto | tinyint(1) | NO | | 0 | | | ipb_anon_only | tinyint(1) | NO | | 0 | | | ipb_expiry | varchar(14) | NO | MUL | NULL | | +----------------------+-----------------+------+-----+---------+----------------+
MediaWiki version: 1.9
mysql> describe mw_ipblocks; +----------------------+-----------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+-----------------+------+-----+---------+----------------+ | ipb_id | int(8) | NO | PRI | NULL | auto_increment | | ipb_address | tinyblob | NO | MUL | NULL | | | ipb_user | int(8) unsigned | NO | MUL | 0 | | | ipb_by | int(8) unsigned | NO | | 0 | | | ipb_reason | tinyblob | NO | | NULL | | | ipb_timestamp | char(14) | NO | MUL | NULL | | | ipb_auto | tinyint(1) | NO | | 0 | | | ipb_anon_only | tinyint(1) | NO | | 0 | | | ipb_create_account | tinyint(1) | NO | | 1 | | | ipb_enable_autoblock | tinyint(1) | NO | | 1 | | | ipb_expiry | char(14) | NO | MUL | NULL | | | ipb_range_start | tinyblob | NO | MUL | NULL | | | ipb_range_end | tinyblob | NO | | NULL | | +----------------------+-----------------+------+-----+---------+----------------+ 13 rows in set (0.00 sec)
Logging table
MediaWiki version: 1.5
See Logging_table for more detail.
+---------------+------------------+------+-----+----------------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+----------------+-------+ | log_type | char(10) | NO | MUL | | | | log_action | char(10) | NO | | | | | log_timestamp | char(14) | NO | | 19700101000000 | | | log_user | int(10) unsigned | NO | MUL | 0 | | | log_namespace | int(11) | NO | MUL | 0 | | | log_title | varchar(255) | NO | | | | | log_comment | varchar(255) | NO | | | | | log_params | blob | NO | | | | +---------------+------------------+------+-----+----------------+-------+
MediaWiki version: 1.10
mysql> describe mw_logging; +---------------+------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+----------------+----------------+ | log_type | char(10) | NO | MUL | NULL | | | log_action | char(10) | NO | | NULL | | | log_timestamp | char(14) | NO | MUL | 19700101000000 | | | log_user | int(10) unsigned | NO | MUL | 0 | | | log_namespace | int(11) | NO | MUL | 0 | | | log_title | varchar(255) | NO | | NULL | | | log_comment | varchar(255) | NO | | NULL | | | log_params | blob | NO | | NULL | | | log_id | int(10) unsigned | NO | PRI | NULL | auto_increment | +---------------+------------------+------+-----+----------------+----------------+ 9 rows in set (0.02 sec)
Objectcache table
MediaWiki version: 1.4
+---------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------------+------+-----+---------+-------+ | keyname | varchar(255) binary | | PRI | | | | value | mediumblob | YES | | NULL | | | exptime | datetime | YES | MUL | NULL | | +---------+---------------------+------+-----+---------+-------+
+---------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+------------+------+-----+---------+-------+ | keyname | char(255) | NO | PRI | NULL | | | value | mediumblob | YES | | NULL | | | exptime | datetime | YES | MUL | NULL | | +---------+------------+------+-----+---------+-------+
Oldimage table
MediaWiki version: 1.4
+-----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------------------+------+-----+---------+-------+ | oi_name | varchar(255) binary | | MUL | | | | oi_archive_name | varchar(255) binary | | | | | | oi_size | int(8) unsigned | | | 0 | | | oi_description | tinyblob | | | | | | oi_user | int(5) unsigned | | | 0 | | | oi_user_text | varchar(255) binary | | | | | | oi_timestamp | varchar(14) binary | | | | | +-----------------+---------------------+------+-----+---------+-------+
MediaWiki version: 1.9
mysql> describe mw_oldimage; +-----------------+-----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-----------------+------+-----+---------+-------+ | oi_name | varchar(255) | NO | MUL | NULL | | | oi_archive_name | varchar(255) | NO | | NULL | | | oi_size | int(8) unsigned | NO | | 0 | | | oi_width | int(5) | NO | | 0 | | | oi_height | int(5) | NO | | 0 | | | oi_bits | int(3) | NO | | 0 | | | oi_description | tinyblob | NO | | NULL | | | oi_user | int(5) unsigned | NO | | 0 | | | oi_user_text | varchar(255) | NO | | NULL | | | oi_timestamp | char(14) | NO | | NULL | | +-----------------+-----------------+------+-----+---------+-------+ 10 rows in set (0.00 sec)
