Manual:iwlinks table

From MediaWiki.org
Jump to: navigation, search

Other languages:
English • ‎español • ‎日本語 • ‎polski
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[edit]

iwl_from[edit]

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

iwl_prefix[edit]

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

iwl_title[edit]

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

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

DatabasesManual:Database layout Engines: MySQL/MariaDBManual:MySQLOracleManual:OraclePostgreSQLManual:PostgreSQLSQLiteManual:SQLiteSQL ServerManual:Microsoft SQL Server

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: archivebot_passwordscategorycategorylinkschange_tagconfigexternallinksfilearchivehitcounterimageimagelinksinterwikiiwlinksipblocksjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionsearchindexsitessite_identifiers - site_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiestag_summaryvalid_tagwatchlist