Manual:externallinks table

From MediaWiki.org
(Redirected from Externallinks table)
Jump to: navigation, search
Manual:Contents MediaWiki database layout externallinks table



The externallinks table is where MediaWiki stores and tracks external links. This table was introduced after 1.5.

Fields[edit | edit source]

MediaWiki version: 1.22
Gerrit change 51675

el_id[edit | edit source]

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

el_from[edit | edit source]

The page identifier of the referring wiki page.

el_to[edit | edit source]

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

el_index[edit | edit source]

This is the same URL as el_to search-optimised: 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'.

Schema[edit | edit source]

Current version[edit | edit source]

<translate>

MediaWiki version:</translate>

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

Previous versions[edit | edit source]

<translate>

MediaWiki versions:</translate>

1.19 – 1.20
mysql> 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    |       |
+----------+------------------+------+-----+---------+-------+


<translate>

MediaWiki version:</translate>

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


<translate>

MediaWiki version:</translate>

1.11
<translate>

MediaWiki version:</translate>

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


<translate>

MediaWiki version:</translate>

1.9
<translate>

MediaWiki version:</translate>

1.8
<translate>

MediaWiki version:</translate>

1.7
<translate>

MediaWiki version:</translate>

1.6
<translate>

MediaWiki version:</translate>

1.5
+----------+-----------------+------+-----+---------+-------+
| Field    | Type            | Null | Key | Default | Extra |
+----------+-----------------+------+-----+---------+-------+
| el_from  | int(8) unsigned |      | MUL | 0       |       |
| el_to    | blob            |      | MUL |         |       |
| el_index | blob            |      | MUL |         |       |
+----------+-----------------+------+-----+---------+-------+
Databases Engines: MySQLOraclePostgreSQLSQLite
Technical documentation: Schema (tables) – API property associationsField prefixesPrimary key storage in other fieldsWikimedia extension tables
Configuration: SettingsSharing
Development: AccessOptimizationPolicyUpdaterExtension schema updatesPatch file
Core tables: archivecategorycategorylinkschange_tagconfigexternallinksfilearchivehitcounterimageimagelinksinterwikiiwlinksipblocksjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionsearchindexsitessite_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiesvalid_tagwatchlist
Language: English  • 日本語