The interwiki table stores the interwiki prefixes with their targets.
[edit] Fields
[edit] iw_prefix
The prefix of the interwiki link; this is used the same way as a namespace is used when editing.
[edit] iw_url
The target of the link; the page name is substituted for $1.
[edit] iw_api
| MediaWiki version: |
≥ 1.17 |
The URL of the file api.php. This is not used except by ApiQuerySiteinfo::appendInterwikiMap(), when an interwiki map is requested via siprop=interwikimap.
[edit] iw_wikiid
The name of the database (for a connection to be established with wfGetLB( 'wikiid' ) )
[edit] 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.
[edit] iw_trans
This is used to allow transcluding templates (or other pages) from another MediaWiki installation. Both $wgEnableScaryTranscluding and iw_trans need to be on.
[edit] Versions
| MediaWiki versions: |
1.19 – 1.20 |
mysql> describe interwiki;
+-----------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------------+------+-----+---------+-------+
| iw_prefix | varbinary(32) | NO | PRI | NULL | |
| iw_url | blob | NO | | NULL | |
| iw_api | blob | NO | | NULL | |
| iw_wikiid | varbinary(64) | NO | | NULL | |
| iw_local | tinyint(1) | NO | | NULL | |
| iw_trans | tinyint(4) | NO | | 0 | |
+-----------+---------------+------+-----+---------+-------+
+-----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| iw_prefix | varbinary(32)| NO | PRI | | |
| iw_url | blob | NO | | | |
| iw_api | blob | NO | | | |
| iw_wikiid | varbinary(64)| NO | | | |
| iw_local | bool | NO | | | |
| iw_trans | tinyint(1) | NO | | 0 | |
+-----------+--------------+------+-----+---------+-------+
+-----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------+------+-----+---------+-------+
| iw_prefix | char(32) | NO | PRI | | |
| iw_url | blob | NO | | | |
| iw_api | blob | NO | | | |
| iw_wikiid | char(64) | NO | | | |
| iw_local | bool | NO | | | |
| iw_trans | tinyint(1) | NO | | 0 | |
+-----------+------------+------+-----+---------+-------+
The two fields iw_api and iw_wikiid were added in r69542.
| MediaWiki version: |
≤ 1.16 |
| MediaWiki version: |
≥ 1.10 |
+-----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------+------+-----+---------+-------+
| iw_prefix | char(32) | NO | PRI | | |
| iw_url | blob | NO | | | |
| iw_local | bool | NO | | | |
| iw_trans | tinyint(1) | NO | | 0 | |
+-----------+------------+------+-----+---------+-------+
+-----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------+------+-----+---------+-------+
| iw_prefix | char(32) | NO | PRI | | |
| iw_url | char(127) | NO | | | |
| iw_local | bool | NO | | | |
| iw_trans | tinyint(1) | NO | | 0 | |
+-----------+------------+------+-----+---------+-------+
+-----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------+------+-----+---------+-------+
| iw_prefix | char(32) | NO | PRI | | |
| iw_url | char(127) | NO | | | |
| iw_local | bool | NO | | | |
| iw_trans | tinyint(1) | NO | | | |
+-----------+------------+------+-----+---------+-------+
[edit] See also
