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:ContentsManual:Contents MediaWiki database layoutManual: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]

il_from[edit]

The page_idManual:Page table#page_id of the page the link is on.

il_from_namespace[edit]

MediaWiki version: 1.24

page_namespaceManual:Page table#page_namespace of the page containing the link.

il_to[edit]

The title of the file being linked to.

Schema summary[edit]

MediaWiki version: 1.24

DESCRIBE imagelinks;

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


MediaWiki versions: 1.10 – 1.23

DESCRIBE imagelinks;

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


MediaWiki versions: 1.3 – 1.9

DESCRIBE imagelinks;

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


MediaWiki versions: 1.1 – 1.2

DESCRIBE imagelinks;

+---------+---------------------+------+-----+---------+-------+
| Field   | Type                | Null | Key | Default | Extra |
+---------+---------------------+------+-----+---------+-------+
| il_from | varchar(255) binary | NO   | PRI | NULL    |       |
| il_to   | varchar(255) binary | NO   | PRI | NULL    |       |
+---------+---------------------+------+-----+---------+-------+
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_tagcommentconfigexternallinksfilearchivehitcounterimageimagelinksimage_comment_tempinterwikiiwlinksipblocksip_changesjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionrevision_comment_tempsearchindexsitessite_identifiers - site_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiestag_summaryvalid_tagwatchlist