Manual:interwiki table

↑ Manual:Contents

MediaWiki database layout

interwiki table

The interwiki table stores the interwiki prefixes with their targets. See default interwiki prefixes. The interwiki links themselves are stored in the iwlinks table.

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 http://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.

Versions

MediaWiki version:

≥ 1.21

+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| iw_prefix | varchar(32) | NO   | PRI | NULL    |       |
| iw_url    | blob        | NO   |     | NULL    |       |
| iw_api    | blob        | NO   |     | NULL    |       |
| iw_wikiid | varchar(64) | NO   |     | NULL    |       |
| iw_local  | tinyint(1)  | NO   |     | NULL    |       |
| iw_trans  | tinyint(4)  | NO   |     | 0       |       |
+-----------+-------------+------+-----+---------+-------+

MediaWiki versions:

1.19 – 1.20

+-----------+---------------+------+-----+---------+-------+
| 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 version:

1.18

+-----------+--------------+------+-----+---------+-------+
| 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       |       |
+-----------+--------------+------+-----+---------+-------+

MediaWiki version:

1.17

+-----------+------------+------+-----+---------+-------+
| 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 versions:

1.10 – 1.16

+-----------+------------+------+-----+---------+-------+
| 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       |       |
+-----------+------------+------+-----+---------+-------+

MediaWiki versions:

1.5 – 1.9

+-----------+------------+------+-----+---------+-------+
| 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       |       |
+-----------+------------+------+-----+---------+-------+

MediaWiki versions:

1.3 – 1.4

+-----------+------------+------+-----+---------+-------+
| 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   |     |         |       |
+-----------+------------+------+-----+---------+-------+

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

Databases

Engines: MySQL – Oracle – PostgreSQL – SQLite Technical documentation: Schema (tables) – API property associations – Field prefixes – Primary key storage in other fields – Wikimedia extension tables Configuration: Settings – Sharing Development: Access – Optimization – Policy – Updater – Extension schema updates – Patch file Core tables: archive – category – categorylinks – change_tag – config – externallinks – filearchive – hitcounter – image – imagelinks – interwiki – iwlinks – ipblocks – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – searchindex – sites – site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist