View source for Manual:Externallinks table

<languages/>
{{Database layout}}
{{TOCright}}
{{MW 1.6|and after}}
<translate><!--T:1--> The <tvar name=1>'''externallinks'''</tvar> table is where MediaWiki stores and tracks external links.</translate> 

{{note|1=<translate><!--T:15--> Up to version 1.41, protocol-relative links are stored twice in this table as per <tvar name=1>[[rev:r102951|r102951]]</tvar>.</translate>}}

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

=== el_id===
{{MW 1.22|and after}}
<translate><!--T:4--> The primary key.</translate>
<translate><!--T:5--> Presently not used for anything, but will help with online schema changes.</translate>

===el_from===
<translate><!--T:6--> The [[<tvar name=page>Special:MyLanguage/Manual:Page table#page_id</tvar>|page id]] of the referring wiki page.</translate>

===el_to_domain_index===
{{MW 1.40|and after}}
<translate><!--T:17--> This is similar to <tvar name=1>el_index</tvar> but only includes the protocol specification and domain in reversed, so <tvar name=2><code><nowiki>http://en.wikipedia.org</nowiki></code></tvar> becomes <tvar name=3><code><nowiki>http://org.wikipedia.en.</nowiki></code></tvar>.</translate>

===el_to_path===
{{MW 1.40|and after}}
<translate><!--T:18--> Only the path of <tvar name=1>el_to</tvar>.</translate>
<translate><!--T:19--> Example:</translate>
<code><nowiki>/wiki/Main_Page</nowiki></code>

===el_to===
{{MW version|version=1.6|version2=1.41|gerrit change=954900}}
<translate><!--T:7--> The actual URL itself.</translate>
<translate><!--T:8--> It is passed to the browser.</translate>

===el_index===
{{MW version|version=1.6|version2=1.41|gerrit change=954900}}
<translate><!--T:9--> This is the same URL as <code>el_to</code> search-optimized: username and password information is stripped, and the other components are reversed for faster searching, so <tvar name=url1><code><nowiki>http://user:password@sub.example.com/page.html</nowiki></code></tvar> becomes <tvar name=url2><code><nowiki>http://com.example.sub./page.html</nowiki></code></tvar>, which allows searches of the form 'Show all links pointing to *.example.com'.</translate>

===el_index_60===
{{MW version|version=1.29|version2=1.41|gerrit change=954900}}
<translate><!--T:13--> This is el_index truncated to 60 bytes to allow for sortable queries that aren't supported by a partial index.</translate>

<translate>
==Schema summary== <!--T:10-->
</translate>
{{MW 1.41|and later|gerrit change=954900}}
{{describe table}}
<pre>
+--------------------+------------------+------+-----+---------+----------------+
| Field              | Type             | Null | Key | Default | Extra          |
+--------------------+------------------+------+-----+---------+----------------+
| el_id              | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| el_from            | int(10) unsigned | NO   | MUL | 0       |                |
| el_to_domain_index | varbinary(255)   | NO   | MUL |         |                |
| el_to_path         | blob             | YES  |     | NULL    |                |
+--------------------+------------------+------+-----+---------+----------------+
</pre>

{{MW 1.40}}
{{describe table}}
<pre>
+--------------------+------------------+------+-----+---------+----------------+
| Field              | Type             | Null | Key | Default | Extra          |
+--------------------+------------------+------+-----+---------+----------------+
| el_id              | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| el_from            | int(10) unsigned | NO   | MUL | 0       |                |
| el_to              | blob             | NO   | MUL | NULL    |                |
| el_index           | blob             | NO   | MUL | NULL    |                |
| el_index_60        | varbinary(60)    | NO   | MUL | NULL    |                |
| el_to_domain_index | varbinary(255)   | NO   | MUL |         |                |
| el_to_path         | blob             | YES  |     | NULL    |                |
+--------------------+------------------+------+-----+---------+----------------+
</pre>

{{MW version|version=1.30|version2=1.39}}
{{describe table}}
<pre>
+-------------+------------------+------+-----+---------+----------------+
| Field       | Type             | Null | Key | Default | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| el_id       | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| el_from     | int(10) unsigned | NO   | MUL | 0       |                |
| el_to       | blob             | NO   | MUL | NULL    |                |
| el_index    | blob             | NO   | MUL | NULL    |                |
| el_index_60 | varbinary(60)    | NO   | MUL | NULL    |                |
+-------------+------------------+------+-----+---------+----------------+
</pre>

{{MW 1.29}}
{{describe table}}
<pre>
+-------------+------------------+------+-----+---------+----------------+
| Field       | Type             | Null | Key | Default | Extra          |
+-------------+------------------+------+-----+---------+----------------+
| el_id       | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| el_from     | int(10) unsigned | NO   | MUL | 0       |                |
| el_to       | blob             | NO   | MUL | NULL    |                |
| el_index    | blob             | NO   | MUL | NULL    |                |
| el_index_60 | varbinary(60)    | NO   | MUL |         |                |
+-------------+------------------+------+-----+---------+----------------+
</pre>

{{MW version|version=1.22|version2=1.28}}
{{describe table}}
<pre>
+----------+------------------+------+-----+---------+----------------+
| Field    | Type             | Null | Key | Default | Extra          |
+----------+------------------+------+-----+---------+----------------+
| el_id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| el_from  | int(10) unsigned | NO   | MUL | 0       |                |
| el_to    | blob             | NO   | MUL | NULL    |                |
| el_index | blob             | NO   | MUL | NULL    |                |
+----------+------------------+------+-----+---------+----------------+
</pre>

{{MW version|version=1.10|version2=1.21}}
{{describe table}}
<pre>
+----------+------------------+------+-----+---------+-------+
| Field    | Type             | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| el_from  | int(10) unsigned | NO   | MUL | 0       |       |
| el_to    | blob             | NO   | MUL | NULL    |       |
| el_index | blob             | NO   | MUL | NULL    |       |
+----------+------------------+------+-----+---------+-------+
</pre>

{{MW version|version=1.6|version2=1.9}}
{{describe table}}
<pre>
+----------+-----------------+------+-----+---------+-------+
| Field    | Type            | Null | Key | Default | Extra |
+----------+-----------------+------+-----+---------+-------+
| el_from  | int(8) unsigned | NO   | MUL | 0       |       |
| el_to    | blob            | NO   | MUL | NULL    |       |
| el_index | blob            | NO   | MUL | NULL    |       |
+----------+-----------------+------+-----+---------+-------+
</pre>

<translate>
==Indexes== <!--T:16-->
</translate>
{{MW 1.41|and after}}
{{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 |
+---------------+------------+----------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| externallinks |          0 | PRIMARY                    |            1 | el_id              | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_from                    |            1 | el_from            | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_to_domain_index_to_path |            1 | el_to_domain_index | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_to_domain_index_to_path |            2 | el_to_path         | A         |           0 |       60 | NULL   | YES  | BTREE      |         |               |
+---------------+------------+----------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
</pre>

{{MW 1.40}}
{{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 |
+---------------+------------+----------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| externallinks |          0 | PRIMARY                    |            1 | el_id              | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_from                    |            1 | el_from            | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_to                      |            1 | el_to              | A         |           0 |       60 | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_to                      |            2 | el_from            | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_index                   |            1 | el_index           | A         |           0 |       60 | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_index_60                |            1 | el_index_60        | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_index_60                |            2 | el_id              | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_from_index_60           |            1 | el_from            | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_from_index_60           |            2 | el_index_60        | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_from_index_60           |            3 | el_id              | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_to_domain_index_to_path |            1 | el_to_domain_index | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_to_domain_index_to_path |            2 | el_to_path         | A         |           0 |       60 | NULL   | YES  | BTREE      |         |               |
+---------------+------------+----------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
</pre>

{{MW version|version=1.30|version2=1.39}}
{{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 |
+---------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| externallinks |          0 | PRIMARY          |            1 | el_id       | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_from          |            1 | el_from     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_from          |            2 | el_to       | A         |           0 |       40 | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_to            |            1 | el_to       | A         |           0 |       60 | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_to            |            2 | el_from     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_index         |            1 | el_index    | A         |           0 |       60 | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_index_60      |            1 | el_index_60 | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_index_60      |            2 | el_id       | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_from_index_60 |            1 | el_from     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_from_index_60 |            2 | el_index_60 | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| externallinks |          1 | el_from_index_60 |            3 | el_id       | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+---------------+------------+------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
</pre>

{{databases}}

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