The externallinks table is where MediaWiki stores and tracks external links. This table was introduced after 1.5.
Fields [edit]
el_from [edit]
The page identifier of the referring wiki page.
The actual URL itself. It is passed to the browser.
el_index [edit]
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:[email protected]/page.html becomes http://com.example.sub./page.html , which allows searches of the form 'Show all links pointing to *.example.com'.
Schema [edit]
Current version [edit]
| MediaWiki versions: |
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 | |
+----------+------------------+------+-----+---------+-------+
Previous versions [edit]
+----------+-----------------+------+-----+---------+-------+
| 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 | |
+----------+-----------------+------+-----+---------+-------+
+----------+-----------------+------+-----+---------+-------+
| 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 | |
+----------+-----------------+------+-----+---------+-------+
+----------+-----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-----------------+------+-----+---------+-------+
| el_from | int(8) unsigned | | MUL | 0 | |
| el_to | blob | | MUL | | |
| el_index | blob | | MUL | | |
+----------+-----------------+------+-----+---------+-------+
