Manual:imagelinks table

From MediaWiki.org
Jump to: navigation, search

Other languages:
Deutsch • ‎English • ‎español • ‎italiano • ‎日本語 • ‎polski • ‎português • ‎português do Brasil • ‎Tiếng Việt
Manual:Contents MediaWiki database layout imagelinks table



The imagelinks table stores inclusions of files. This is good for a variety of functions, from link caching in the output functions to the "what links here" page. Note that some images may be on a foreign file repository.

Fields[edit | edit source]

il_from[edit | edit source]

The page_id of the page the link is on.

il_from_namespace[edit | edit source]

MediaWiki version: 1.24

page_namespace of the page containing the link.

il_to[edit | edit source]

The title of the file being linked to.

Versions[edit | edit source]

MediaWiki versions: 1.19 – 1.20


+---------+------------------+------+-----+---------+-------+
| Field   | Type             | Null | Key | Default | Extra |
+---------+------------------+------+-----+---------+-------+
| il_from | int(10) unsigned | NO   | PRI | 0       |       |
| il_to   | varchar(255)     | NO   | PRI |         |       |
+---------+------------------+------+-----+---------+-------+


MediaWiki version: 1.12


+---------+-----------------+------+-----+---------+-------+
| Field   | Type            | Null | Key | Default | Extra |
+---------+-----------------+------+-----+---------+-------+
| il_from | int(8) unsigned | NO   |     | 0       |       |
| il_to   | varchar(255)    | NO   |     |         |       |
+---------+-----------------+------+-----+---------+-------+


MediaWiki versions: 1.10 – 1.11


+---------+-----------------+------+-----+---------+-------+
| Field   | Type            | Null | Key | Default | Extra |
+---------+-----------------+------+-----+---------+-------+
| il_from | int(10) unsigned| NO   | PRI | 0       |       |
| il_to   | varchar(255)    | NO   | PRI | NULL    |       |
+---------+-----------------+------+-----+---------+-------+


MediaWiki version: 1.9


+---------+-----------------+------+-----+---------+-------+
| Field   | Type            | Null | Key | Default | Extra |
+---------+-----------------+------+-----+---------+-------+
| il_from | int(8) unsigned | NO   | PRI | 0       |       |
| il_to   | varchar(255)    | NO   | PRI | NULL    |       |
+---------+-----------------+------+-----+---------+-------+
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