|
|
本館粉絲專頁 |
|
|
使用者:Minwei/維基筆記/Schema轉換/Tables need updated
台灣棒球維基館
目次 |
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)
