Manual:imagelinks table

From mediawiki.org

Translate this page

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.

The page_id of the page the link is on.

page_namespace of the page containing the link.

The title of the file being linked to.

DESCRIBEimagelinks;

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

DESCRIBEimagelinks;

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

DESCRIBEimagelinks;

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

DESCRIBEimagelinks;

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

DESCRIBEimagelinks;

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

DESCRIBEimagelinks;

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

SHOWINDEXINimagelinks;

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

Retrieved from "https://www.mediawiki.org/w/index.php?title=Manual:Imagelinks_table&oldid=5064037"

Category:

• MediaWiki database tables