Interwiki table

From MediaWiki.org

↑ Manual:Contents

MediaWiki database layout

Interwiki table

The interwiki table stores the interwiki prefixes with their targets.

SVN: http://svn.wikimedia.org/viewvc/mediawiki/trunk/phase3/maintenance/interwiki.sql?view=markup

DESCRIBE interwiki; confronts us with:

Field	Type	Null	Key	Default	Extra
iw_prefix	char(32)		PRI
iw_url	char(127)
iw_local	tinyint(1)			0
iw_trans	tinyint(1)			0

iw_prefix is the prefix of the interwiki link; this is used the same way as a namespace is used when editing.

iw_url is the target of the link; the page name is substituted for $1.

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.

MediaWiki version:

1.9

MediaWiki version:

1.8

DESCRIBE interwiki; in MediaWiki 1.8/1.9 gives the following:

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

MediaWiki version:

1.12

MediaWiki version:

1.11

DESCRIBE interwiki; in MediaWiki 1.11/1.12 gives the following:

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