Manual:imagelinks table

From MediaWiki.org
Jump to navigation Jump to search

Other languages:
Deutsch • ‎English • ‎Tiếng Việt • ‎español • ‎italiano • ‎polski • ‎português • ‎português do Brasil • ‎中文 • ‎日本語
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]

il_from[edit]

The page_id of the page the link is on.

il_from_namespace[edit]

MediaWiki version: 1.24

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