Manual: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 "sp>Special:WhatLinksHere|what links here" page.

Note that some images may be on a ForeignFileRepos>Special:MyLanguage/Manual:$wgForeignFileRepos|foreign file repository.

il_from
The page_id of the page the link is on.

il_from_namespace
page_namespace of the page containing the link.

il_to
The title of the file being linked to.

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

DESCRIBE imagelinks; +-+-+--+-+-+---+ +-+-+--+-+-+---+ +-+-+--+-+-+---+
 * Field  | Type                | Null | Key | Default | Extra |
 * il_from | int(10) unsigned   | NO   | PRI | 0       |       |
 * il_to  | varchar(255) binary | NO   | PRI | NULL    |       |

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

DESCRIBE imagelinks; +-+-+--+-+-+---+ +-+-+--+-+-+---+ +-+-+--+-+-+---+
 * Field  | Type                | Null | Key | Default | Extra |
 * il_from | varchar(255) binary | NO  | PRI | NULL    |       |
 * il_to  | varchar(255) binary | NO   | PRI | NULL    |       |