Manual:Links table

From MediaWiki.org
(Redirected from Links table)
Jump to: navigation, 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       |       |
+----------+------------------+------+-----+---------+-------+
DatabasesManual:Database layout Engines: MySQLManual:MySQLOracleManual:OraclePostgreSQLManual:PostgreSQLSQLiteManual:SQLite
Technical documentation: SchemaManual:Database layout (tablesCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associationsField prefixesDatabase field prefixesPrimary key storage in other fieldsManual:Primary key storage in other fieldsWikimedia extension tablesCategory:Wikimedia extension database tables
Configuration: SettingsManual:Configuration_settings#Database_settingsSharingManual:Shared database
Development: AccessManual:Database accessOptimizationDatabase optimizationPolicyDevelopment policy#Database_patchesUpdaterManual:DatabaseUpdater.phpExtension schema updatesManual:Hooks/LoadExtensionSchemaUpdatesPatch fileManual:SQL patch file
Core tables: archivecategorycategorylinkschange_tagconfigexternallinksfilearchivehitcounterimageimagelinksinterwikiiwlinksipblocksjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionsearchindexsitessite_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiesvalid_tagwatchlist