Manual:interwiki table

From MediaWiki.org
(Redirected from Interwiki table)
Jump to: navigation, search
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[edit | edit source]

iw_prefix[edit | edit source]

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

iw_url[edit | edit source]

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

iw_api[edit | edit source]

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[edit | edit source]

The name of the database (for a connection to be established with wfGetLB( 'wikiid' ) )

iw_local[edit | edit source]

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.

iw_trans[edit | edit source]

This is used to allow transcluding templates (or other pages) from another MediaWiki installation. Both $wgEnableScaryTranscluding and iw_trans need to be on.

Versions[edit | edit source]

<translate>

MediaWiki versions:</translate>

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


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.


<translate>

MediaWiki versions:</translate>

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


<translate>

MediaWiki versions:</translate>

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


<translate>

MediaWiki versions:</translate>

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[edit | edit source]

Databases Engines: MySQLOraclePostgreSQLSQLite
Technical documentation: Schema (tables) – API property associationsField prefixesPrimary key storage in other fieldsWikimedia extension tables
Configuration: SettingsSharing
Development: AccessOptimizationPolicyUpdaterExtension schema updatesPatch file
Core tables: archivecategorycategorylinkschange_tagconfigexternallinksfilearchivehitcounterimageimagelinksinterwikiiwlinksipblocksjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionsearchindexsitessite_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiesvalid_tagwatchlist
Language: English  • 日本語 • slovenčina