View source for Manual:Imagelinks table

<languages/>
{{Database layout}}
{{TOCright}}
<translate><!--T:1--> The <tvar name=1>'''imagelinks'''</tvar> table stores inclusions of files.</translate>
<translate><!--T:2--> This is good for a variety of functions, from link caching in the output functions to the "[[<tvar name=sp>Special:WhatLinksHere</tvar>|what links here]]" page.</translate>
<translate><!--T:3--> Note that some images may be on a [[<tvar name=ForeignFileRepos>Special:MyLanguage/Manual:$wgForeignFileRepos</tvar>|foreign file repository]].</translate>
<translate><!--T:10--> In the case of Wikimedia wikis, this table includes files hosted on Wikimedia Commons.</translate>

<translate>
==Fields== <!--T:4-->
</translate>

===il_from===
<translate><!--T:5--> The <tvar name=page-id>{{ll|Manual:Page table#page_id|page_id}}</tvar> of the page the link is on.</translate>

===il_from_namespace===
{{MW 1.24|and after}}
<translate><!--T:8--> <tvar name=page-namespace>{{ll|Manual:Page table#page_namespace|page_namespace}}</tvar> of the page containing the link.</translate>

===il_to===
<translate>
<!--T:6-->
The title of the file being linked to.

==Schema summary== <!--T:9-->
</translate>

{{MW 1.36|+}}
{{describe table}}
<pre>
+-------------------+------------------+------+-----+---------+-------+
| 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       |       |
+-------------------+------------------+------+-----+---------+-------+
</pre>

{{MW version|version=1.26|version2=1.35}}
{{describe table}}
<pre>
+-------------------+------------------+------+-----+---------+-------+
| 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 |         |       |
+-------------------+------------------+------+-----+---------+-------+
</pre>

{{MW version|version=1.24|version2=1.25}}
{{describe table}}
<pre>
+-------------------+------------------+------+-----+---------+-------+
| 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 |         |       |
+-------------------+------------------+------+-----+---------+-------+
</pre>

{{MW version|version=1.10|version2=1.23}}
{{describe table}}
<pre>
+---------+---------------------+------+-----+---------+-------+
| Field   | Type                | Null | Key | Default | Extra |
+---------+---------------------+------+-----+---------+-------+
| il_from | int(10) unsigned    | NO   | PRI | 0       |       |
| il_to   | varchar(255) binary | NO   | PRI | NULL    |       |
+---------+---------------------+------+-----+---------+-------+
</pre>

{{MW version|version=1.3|version2=1.9}}
{{describe table}}
<pre>
+---------+---------------------+------+-----+---------+-------+
| Field   | Type                | Null | Key | Default | Extra |
+---------+---------------------+------+-----+---------+-------+
| il_from | int(8) unsigned     | NO   | PRI | 0       |       |
| il_to   | varchar(255) binary | NO   | PRI | NULL    |       |
+---------+---------------------+------+-----+---------+-------+
</pre>

{{MW version|version=1.1|version2=1.2}}
{{describe table}}
<pre>
+---------+---------------------+------+-----+---------+-------+
| Field   | Type                | Null | Key | Default | Extra |
+---------+---------------------+------+-----+---------+-------+
| il_from | varchar(255) binary | NO   | PRI | NULL    |       |
| il_to   | varchar(255) binary | NO   | PRI | NULL    |       |
+---------+---------------------+------+-----+---------+-------+
</pre>

<translate>
==Indexes== <!--T:11-->
</translate>
{{MW 1.30|and after}}<!--Still valid as of 1.37-->
{{show index in table}}
<pre style="overflow-x: scroll; white-space: pre;">
+------------+------------+------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| 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      |         |               |
+------------+------------+------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
</pre>

{{Databases}}

[[Category:MediaWiki database tables{{#translation:}}|Imagelinks table]]