Manual:Externallinks table

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

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'.

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

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