Manual:Interwiki table

From MediaWiki.org
Jump to: navigation, search
Manual:ContentsManual:Contents MediaWiki database layoutManual: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]

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

DatabasesManual:Database layout Engines: MySQLManual:MySQLOracleManual:OraclePostgreSQLManual:PostgreSQLSQLiteManual:SQLite
Technical documentation: SchemaManual:Database layout (tablesCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associationsField prefixesDatabase field prefixesPrimary key storage in other fieldsManual:Primary key storage in other fieldsWikimedia extension tablesCategory:Wikimedia extension database tables
Configuration: SettingsManual:Configuration_settings#Database_settingsSharingManual:Shared database
Development: AccessManual:Database accessOptimizationDatabase optimizationPolicyDevelopment policy#Database_patchesUpdaterManual:DatabaseUpdater.phpExtension schema updatesManual:Hooks/LoadExtensionSchemaUpdatesPatch fileManual:SQL patch 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