Manual: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. il_from stores the ID of the page it is used on, whereas il_to the image.

DESCRIBE imagelinks confronts us with:

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