Manual:iwlinks table

↑ Manual:ContentsManual:Contents

MediaWiki database layoutManual:Database layout

iwlinks table

MediaWiki version:

≥ 1.17

The iwlinks table stores the interwiki links with their targets. Not to confuse with the LanglinksManual:Langlinks table table.

Fields

iwl_from

The page_idManual:Page table#page_id of the referring page (i.e. the local page that the link appears on).

iwl_prefix

interwiki prefix code of the target. This is used the same way as a namespace is used when editing.

iwl_title

The title of the target page, including namespace (FULLPAGENAMEE style). Spaces are converted to underscores, but the first letter is not automatically capitalized. So for example, an interwiki link to w:foo bar would have an iwl_title of "foo_bar".

Schema summary

MediaWiki version:

1.17

DESCRIBE iwlinks;

+------------+---------------------+------+-----+---------+-------+
| Field      | Type                | Null | Key | Default | Extra |
+------------+---------------------+------+-----+---------+-------+
| iwl_from   | int(10) unsigned    | NO   | PRI | 0       |       |
| iwl_prefix | varbinary(20)       | NO   | PRI |         |       |
| iwl_title  | varchar(255) binary | NO   | PRI |         |       |
+------------+---------------------+------+-----+---------+-------+

See also

• Manual:Interwiki tableManual:Interwiki table
• Manual:Langlinks tableManual:Langlinks table
• Manual:Pagelinks tableManual:Pagelinks table
• r65104, adding this table to the schema

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: actor – archive – bot_passwords – category – categorylinks – change_tag – comment – config – externallinks – filearchive – hitcounter – image – imagelinks – image_comment_temp – interwiki – iwlinks – ipblocks – ip_changes – 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 – revision_comment_temp – 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