Manual:imagelinks table
(Redirected from 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. Note that some images may be on a foreign file repository. In the case of Wikimedia wikis, this table includes files hosted on Wikimedia Commons.
Fields
[edit]il_from
[edit]The page_id of the page the link is on.
il_from_namespace
[edit]| MediaWiki version: | ≥ 1.24 |
page_namespace of the page containing the link.
il_to
[edit]The title of the file being linked to.
Schema summary
[edit]| MediaWiki version: | ≥ 1.36 |
DESCRIBE imagelinks;
+-------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+-------+ | il_from | int(10) unsigned | NO | PRI | 0 | | | il_to | varbinary(255) | NO | PRI | | | | il_from_namespace | int(11) | NO | MUL | 0 | | +-------------------+------------------+------+-----+---------+-------+
| MediaWiki versions: | 1.26 – 1.35 |
DESCRIBE imagelinks;
+-------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+-------+ | il_from | int(10) unsigned | NO | PRI | 0 | | | il_from_namespace | int(11) | NO | MUL | 0 | | | il_to | varbinary(255) | NO | PRI | | | +-------------------+------------------+------+-----+---------+-------+
| MediaWiki versions: | 1.24 – 1.25 |
DESCRIBE imagelinks;
+-------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+-------+ | il_from | int(10) unsigned | NO | PRI | 0 | | | il_from_namespace | int(11) | NO | | 0 | | | il_to | varbinary(255) | NO | PRI | | | +-------------------+------------------+------+-----+---------+-------+
| MediaWiki versions: | 1.10 – 1.23 |
DESCRIBE imagelinks;
+---------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------------+------+-----+---------+-------+ | il_from | int(10) unsigned | NO | PRI | 0 | | | il_to | varchar(255) binary | NO | PRI | NULL | | +---------+---------------------+------+-----+---------+-------+
| MediaWiki versions: | 1.3 – 1.9 |
DESCRIBE imagelinks;
+---------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------------+------+-----+---------+-------+ | il_from | int(8) unsigned | NO | PRI | 0 | | | il_to | varchar(255) binary | NO | PRI | NULL | | +---------+---------------------+------+-----+---------+-------+
| MediaWiki versions: | 1.1 – 1.2 |
DESCRIBE imagelinks;
+---------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------------+------+-----+---------+-------+ | il_from | varchar(255) binary | NO | PRI | NULL | | | il_to | varchar(255) binary | NO | PRI | NULL | | +---------+---------------------+------+-----+---------+-------+
Indexes
[edit]| MediaWiki version: | ≥ 1.30 |
SHOW INDEX IN imagelinks;
+------------+------------+------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +------------+------------+------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | imagelinks | 0 | PRIMARY | 1 | il_from | A | 0 | NULL | NULL | | BTREE | | | | imagelinks | 0 | PRIMARY | 2 | il_to | A | 0 | NULL | NULL | | BTREE | | | | imagelinks | 1 | il_to | 1 | il_to | A | 0 | NULL | NULL | | BTREE | | | | imagelinks | 1 | il_to | 2 | il_from | A | 0 | NULL | NULL | | BTREE | | | | imagelinks | 1 | il_backlinks_namespace | 1 | il_from_namespace | A | 0 | NULL | NULL | | BTREE | | | | imagelinks | 1 | il_backlinks_namespace | 2 | il_to | A | 0 | NULL | NULL | | BTREE | | | | imagelinks | 1 | il_backlinks_namespace | 3 | il_from | A | 0 | NULL | NULL | | BTREE | | | +------------+------------+------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+