| ↑ Manual:Contents | MediaWiki database layout | interwiki table |
The interwiki table stores the {{ll|Help:Interwiki linking|interwiki}} prefixes with their targets. See default interwiki prefixes. The interwiki links themselves are stored in the iwlinks table. This data can be accessed using the Interwiki class.
Fields
iw_prefix
The prefix of the interwiki link; this is used the same way as a namespace is used when editing.
iw_url
The target of the link; the page name is substituted for $1.
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.
iw_wikiid
The name of the database (for a connection to be established with wfGetLB( 'wikiid' ))
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 https://en.wikipedia.org/wiki/fr:Accueil gracefully redirects you to the French Homepage (Accueil). However, the WorldCat ISSN catalog is flagged 0 on en.wikipedia.org; the link to https://en.wikipedia.org/wiki/issn:1021-9749 does not work, even though [[issn:1021-9749]] would work if it were on a local Wikipedia page. See m:Help:Interwiki linking#Non-local interwikis.
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.
Schema summary
| MediaWiki version: | ≥ 1.17 |
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 | | +-----------+---------------+------+-----+---------+-------+
| MediaWiki versions: | 1.10 – 1.16 |
DESCRIBE interwiki;
+-----------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------------+------+-----+---------+-------+ | iw_prefix | varbinary(32) | NO | PRI | NULL | | | iw_url | blob | NO | | NULL | | | iw_local | tinyint(1) | NO | | NULL | | | iw_trans | tinyint(4) | NO | | 0 | | +-----------+---------------+------+-----+---------+-------+
| MediaWiki versions: | 1.5 – 1.9 |
DESCRIBE interwiki;
+-----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------+------+-----+---------+-------+ | iw_prefix | char(32) | NO | PRI | NULL | | | iw_url | char(127) | NO | | NULL | | | iw_local | bool | NO | | NULL | | | iw_trans | tinyint(1) | NO | | 0 | | +-----------+------------+------+-----+---------+-------+
| MediaWiki versions: | 1.1 – 1.4 |
DESCRIBE interwiki;
+-----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------+------+-----+---------+-------+ | iw_prefix | char(32) | NO | PRI | NULL | | | iw_url | char(127) | NO | | NULL | | | iw_local | bool | NO | | NULL | | +-----------+------------+------+-----+---------+-------+
Indexes
| MediaWiki version: | ≥ 1.32 |
SHOW INDEX IN interwiki;
+-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | interwiki | 0 | PRIMARY | 1 | iw_prefix | A | 0 | NULL | NULL | | BTREE | | | +-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
See also
- Manual:Interwiki
- Extension:Interwiki - produces Special:Interwiki
- Extension:InterwikiMap - populates interwiki table with data pulled from another wiki's interwiki map
- Interwiki cache
- Interwiki map of MediaWiki.org