Manual:langlinks table

From MediaWiki.org
Jump to: navigation, search
Manual:ContentsManual:Contents MediaWiki database layoutManual:Database layout langlinks table


langlinks table tracks interlanguage links.

This table is used for displaying pages, as a quick means to find the links that typically appear in the left margin, underneath the navigational and toolbox links. Without this table, MediaWiki would have to parse through the wikitext for each page display. The table has a primary key on page (ll_from) and target language (ll_lang), so each page can only store one link per language.

The table has three columns: ll_from (an integer), ll_lang (20 characters), ll_title (255 characters). If the wiki page "Sweden" contains the interlanguage link [[fr:Suède]], then ll_from will indicate the page Sweden where the link goes from, ll_lang will be "fr" and ll_title will be "Suède". In February 2009 for the Swedish language Wikipedia, this table has 3.2 million rows, of which 145,000 (4.5 %) have ll_lang "fr".

As a side effect of having this table, you can:

  • Find out which are the most popular target languages: select count(*), ll_lang from langlinks group by 2 order by 1 desc limit 20;
  • Find out which pages have the most interlanguage links: select count(*), ll_from from langlinks group by 2 order by 1 desc limit 20;
    (But then you would need to translate ll_from into useful page names.)
  • Interlanguage link statistics are included in the monthly Wikipedia statistics.

Note:

  • Interlanguage links are often referred to as interwiki links. For example, interlanguage links are updated by so-called "interwiki bots". While this table can have millions of rows, the interwiki table typically only has a few hundred.
  • ll_title is a single varchar string, to be used in the URL on the target language wiki. This table alone is not sufficient to determine if that link is unique, since it could lead to a redirect or a namespace alias. For example, the interlanguage links [[fr:Catégorie:Suède]] and [[fr:Category:Suède]] are synonymous even though the namespace is spelled differently.

Fields[edit]

ll_from[edit]

page_id of the referring page.

ll_lang[edit]

Language code of the target, in the ISO 639-1 standard.

ll_title[edit]

Title of the target, including namespace (FULLPAGENAMEE style).

Schema summary[edit]

MediaWiki version: 1.10

DESCRIBE langlinks;

+----------+---------------------+------+-----+---------+-------+
| Field    | Type                | Null | Key | Default | Extra |
+----------+---------------------+------+-----+---------+-------+
| ll_from  | int(10) unsigned    | NO   | PRI | 0       |       |
| ll_lang  | varbinary(20)       | NO   | PRI | NULL    |       |
| ll_title | varchar(255) binary | NO   |     | NULL    |       |
+----------+---------------------+------+-----+---------+-------+


MediaWiki versions: 1.7 – 1.9

DESCRIBE langlinks;

+----------+---------------------+------+-----+---------+-------+
| Field    | Type                | Null | Key | Default | Extra |
+----------+---------------------+------+-----+---------+-------+
| ll_from  | int(8) unsigned     | NO   | PRI | 0       |       |
| ll_lang  | varchar(10) binary  | NO   | PRI | NULL    |       |
| ll_title | varchar(255) binary | NO   |     | NULL    |       |
+----------+---------------------+------+-----+---------+-------+
DatabasesManual:Database layout Engines: MySQL/MariaDBManual:MySQLOracleManual:OraclePostgreSQLManual:PostgreSQLSQLiteManual:SQLiteSQL ServerManual:Microsoft SQL Server

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: archivebot_passwordscategorycategorylinkschange_tagcommentconfigexternallinksfilearchivehitcounterimageimagelinksimage_comment_tempinterwikiiwlinksipblocksip_changesjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionrevision_comment_tempsearchindexsitessite_identifiers - site_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiestag_summaryvalid_tagwatchlist
Language:Project:Language policy English  • 日本語