Manual:imagelinks table

↑ 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.

Fields

il_from

The page_id of the page the link is on.

il_to

The title of the file being linked to.

Versions

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 version:

1.10

MediaWiki version:

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