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