Imagelinks table

From MediaWiki.org

↑ Manual:Contents

MediaWiki database layout

Imagelinks table

The imagelinks table stores all the links to images. This is good for a variety of functions, from link caching in the output functions to the "what links here" page.

DESCRIBE imagelinks confronts us with:

Field	Type	Null	Key	Default	Extra
il_from	int(8) unsigned		MUL	0
il_to	varchar(255) binary		MUL

MediaWiki version:

1.8

DESCRIBE imagelinks; in MediaWiki 1.8 gives the following:

+---------+-----------------+------+-----+---------+-------+
| Field   | Type            | Null | Key | Default | Extra |
+---------+-----------------+------+-----+---------+-------+
| il_from | int(8) 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    |       |
+---------+-----------------+------+-----+---------+-------+

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

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