Manual:Externallinks table

The externallinks table is where MediaWiki stores and tracks external links.

Note: protocol-relative links are stored twice in this table as per https://phabricator.wikimedia.org/rSVN102951.

This table was introduced after 1.5.

el_id
The primary key.

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

el_from
The page>Special:MyLanguage/Manual:Page_table#page_id|page identifier of the referring wiki page.

el_to
The actual URL itself.

It is passed to the browser.

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

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

@todo Drop the default once this is deployed everywhere and code is populating it.

el_from_namespace
On WMF databases this field is present, but shouldn't be used and still has to be cleaned up, see T114117

Schema summary
DESCRIBE externallinks; +-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++
 * 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   |     | ''      |                |

DESCRIBE externallinks; +--+--+--+-+-+---+ +--+--+--+-+-+---+ +--+--+--+-+-+---+
 * 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    |       |

DESCRIBE externallinks; +--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * 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    |       |