Manual:Interwiki table

The interwiki table stores the prefixes with their targets.

See [https://phabricator.wikimedia.org/diffusion/MW/browse/master/maintenance/interwiki.sql default interwiki prefixes].

The interwiki links themselves are stored in the  table.

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
The URL of the file .

This is not used except by , when an interwiki map is requested via .

iw_wikiid
The name of the database (for a connection to be established with  )

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 <tvar|1>fr:</> on the en.wikipedia.org project has <tvar|2>iw_local=1</> set.

Therefore, the link to <tvar|1>http://en.wikipedia.org/wiki/fr:Accueil</> gracefully redirects you to the French Homepage (<tvar|2>Accueil</>).

However, the WorldCat ISSN catalog is flagged 0 on en.wikipedia.org; the link to <tvar|1>https://en.wikipedia.org/wiki/issn:1021-9749</> does not work, even though <tvar|2> 1021-9749 </> would work if it were on a local Wikipedia page.

See 1>m:Special:MyLanguage/Help:Interwiki linking#Non-local interwikis</>|m:Help:Interwiki linking#Non-local interwikis.

iw_trans
This is used to allow transcluding templates (or other pages) from another MediaWiki installation.

Both <tvar|1> </> and <tvar|2> </> need to be on.

Schema summary
<tt>DESCRIBE interwiki;</tt> +---+-+--+-+-+---+ +---+-+--+-+-+---+ +---+-+--+-+-+---+
 * 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       |       |

<tt>DESCRIBE interwiki;</tt> +---+-+--+-+-+---+ +---+-+--+-+-+---+ +---+-+--+-+-+---+
 * Field    | Type        | Null | Key | Default | Extra |
 * iw_prefix | varchar(32) | NO  | PRI | NULL    |       |
 * iw_url   | blob        | NO   |     | NULL    |       |
 * iw_local | bool        | NO   |     | NULL    |       |
 * iw_trans | tinyint(1)  | NO   |     | 0       |       |

<tt>DESCRIBE interwiki;</tt> +---++--+-+-+---+ +---++--+-+-+---+ +---++--+-+-+---+
 * 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       |       |

<tt>DESCRIBE interwiki;</tt> +---++--+-+-+---+ +---++--+-+-+---+ +---++--+-+-+---+
 * Field    | Type       | Null | Key | Default | Extra |
 * iw_prefix | char(32)  | NO   | PRI | NULL    |       |
 * iw_url   | char(127)  | NO   |     | NULL    |       |
 * iw_local | bool       | NO   |     | NULL    |       |