Manual:interwiki table

↑ 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

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.

Schema summary

MediaWiki version:

≥ 1.17

DESCRIBE interwiki;

+-----------+-------------+------+-----+---------+-------+
| 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  | bool        | NO   |     | NULL    |       |
| iw_trans  | tinyint(1)  | NO   |     | 0       |       |
+-----------+-------------+------+-----+---------+-------+

MediaWiki versions:

1.10 – 1.16

DESCRIBE interwiki;

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

MediaWiki versions:

1.5 – 1.9

DESCRIBE interwiki;

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

MediaWiki versions:

1.1 – 1.4

DESCRIBE interwiki;

+-----------+------------+------+-----+---------+-------+
| Field     | Type       | Null | Key | Default | Extra |
+-----------+------------+------+-----+---------+-------+
| iw_prefix | char(32)   | NO   | PRI | NULL    |       |
| iw_url    | char(127)  | NO   |     | NULL    |       |
| iw_local  | bool       | NO   |     | NULL    |       |
+-----------+------------+------+-----+---------+-------+

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

DatabasesManual:Database layout

Engines: MySQL/MariaDBManual:MySQL – OracleManual:Oracle – PostgreSQLManual:PostgreSQL – SQLiteManual:SQLite – SQL ServerManual:Microsoft SQL Server Technical documentation: SchemaManual:Database layout (tablesCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associations – Field prefixesDatabase field prefixes – Primary key storage in other fieldsManual:Primary key storage in other fields – Wikimedia extension tablesCategory:Wikimedia extension database tables Configuration: SettingsManual:Configuration_settings#Database_settings – SharingManual:Shared database Development: AccessManual:Database access – OptimizationDatabase optimization – PolicyDevelopment policy#Database_patches – UpdaterManual:DatabaseUpdater.php – Extension schema updatesManual:Hooks/LoadExtensionSchemaUpdates – Patch fileManual:SQL patch file Core tables: archive – bot_passwords – 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_identifiers - site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – tag_summary – valid_tag – watchlist

Language:Project:Language policy	English  • 日本語 • slovenčina