Manual:externallinks table

The externallinks table is where MediaWiki stores and tracks external links. Note unless $wgRegisterInternalExternals is enabled (it is disabled by default), links to the same server are not recorded.

The primary key. Presently not used for anything, but will help with online schema changes.

The page id of the referring wiki page.

This is similar to el_index but only includes the protocol specification and domain in reverse, so http://en.wikipedia.org becomes http://org.wikipedia.en..

Only the path of el_to. Example: /wiki/Main_Page

The actual URL itself. It is passed to the browser.

This is the same URL as el_to search-optimized: username and password information is stripped, and the other components are reversed for faster searching, so http://user:password@sub.example.com/page.html becomes http://com.example.sub./page.html, which allows searches of the form 'Show all links pointing to *.example.com'.

This is el_index truncated to 60 bytes to allow for sortable queries that aren't supported by a partial index.

DESCRIBEexternallinks;

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

DESCRIBEexternallinks;

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

DESCRIBEexternallinks;

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

DESCRIBEexternallinks;

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

DESCRIBEexternallinks;

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

DESCRIBEexternallinks;

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

DESCRIBEexternallinks;

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

SHOWINDEXINexternallinks;

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

SHOWINDEXINexternallinks;

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

SHOWINDEXINexternallinks;

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

• MediaWiki database tables