Manual:links table

From MediaWiki.org
(Redirected from Links table)
Jump to navigation Jump to search

Other languages:
English • ‎español • ‎日本語 • ‎polski • ‎中文
Manual:ContentsManual:Contents MediaWiki database layoutManual:Database layout links table


Note Note: The links and brokenlinks tables have been merged to a single pagelinksManual:Pagelinks table table, which records the namespace+title key pair of target links rather than the page ID or the prefixed title. See [1]

The links table stored all the links to existing articles. This was good for a variety of functions, from link caching in the output functions to the "what links here" page. It was the "good twin" of the brokenlinksManual:brokenlinks table table.

Beginning with the MediaWiki 1.5 release this table is not used, and can be safely deleted. The contents have been migrated to the table pagelinksManual:Pagelinks table table on update. Regenerating the pagelinks table always is possible using the rebuildallManual:rebuildall.php maintenance script.


MediaWiki version: 1.3
+----------+------------------+------+-----+---------+-------+
| Field    | Type             | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| l_from   | int(8) unsigned  | NO   | UNI | 0       |       |
| l_to     | int(8) unsigned  | NO   |     | 0       |       |
+----------+------------------+------+-----+---------+-------+

l_from is the cur_id of the article that contains the link. (This is a change from 1.2, wherein the title of the article was stored. This was not very wise, and has now been fixed.)

l_to is the cur_id of the "target" article.


MediaWiki version: 1.2
MediaWiki version: 1.1
+----------+------------------+------+-----+---------+-------+
| Field    | Type             | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| l_from   | varchar(255)     | NO   | UNI | 0       |       |
| l_to     | int(8) unsigned  | NO   |     | 0       |       |
+----------+------------------+------+-----+---------+-------+