Manual:pagelinks Table - MediaWiki

Languages:

• Deutsch
• English
• Tiếng Việt
• Yorùbá
• français
• português
• čeština
• 中文
• 日本語

↑ Manual:Contents MediaWiki database layout pagelinks table

MediaWiki version:

≥ 1.5

The pagelinks table tracks all internal links in the wiki. Each entry contains the source page's ID and a reference to the linktarget table which has the title and namespace (number) that is being linked to from within that source page. There may be many instances of the source page's ID, as many as the internal links within it, but there can be only one entry per internal link for any page ID (or MySQL will yell out a fatal error).

Note that the target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by.

The table was introduced in version 1.5. It is the result of merging the links table and the brokenlinks table of version 1.4. Regenerating the pagelinks table is always possible using the rebuildall.php maintenance script.

Fields

[edit]

pl_from

[edit]

The page_id of the page containing the link.

pl_from_namespace

[edit]

MediaWiki version:

≥ 1.24

The page_namespace of the page containing the link.

pl_target_id

[edit]

MediaWiki version:

≥ 1.41Gerrit change 941474

Foreign key to linktarget.

pl_namespace

[edit]

MediaWiki version:

≤ 1.42

The page_namespace of the target page. The target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by.

pl_title

[edit]

MediaWiki version:

≤ 1.42

The title of the target page in the page_title format. The target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by. Spaces are converted to underscores, and the first letter may be automatically capitalized. So for example, a link to foo bar would have a pl_title of "Foo_bar" assuming $wgCapitalLinks = true; and no $wgCapitalLinkOverrides.

Schema summary

[edit]

MediaWiki version:

≥ 1.43

DESCRIBEpagelinks;

+-------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+---------------------+------+-----+---------+-------+ | pl_from | int(10) unsigned | NO | PRI | 0 | | | pl_target_id | bigint(20) unsigned | NO | PRI | NULL | | | pl_from_namespace | int(11) | NO | MUL | 0 | | +-------------------+---------------------+------+-----+---------+-------+

MediaWiki versions:

1.41 – 1.42

DESCRIBEpagelinks;

+-------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+---------------------+------+-----+---------+-------+ | pl_from | int(10) unsigned | NO | PRI | 0 | | | pl_namespace | int(11) | NO | PRI | 0 | | | pl_title | varbinary(255) | NO | PRI | | | | pl_from_namespace | int(11) | NO | MUL | 0 | | | pl_target_id | bigint(20) unsigned | YES | MUL | NULL | | +-------------------+---------------------+------+-----+---------+-------+

MediaWiki versions:

1.36 – 1.40

DESCRIBEpagelinks;

+-------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+-------+ | pl_from | int(10) unsigned | NO | PRI | 0 | | | pl_namespace | int(11) | NO | PRI | 0 | | | pl_title | varbinary(255) | NO | PRI | | | | pl_from_namespace | int(11) | NO | MUL | 0 | | +-------------------+------------------+------+-----+---------+-------+

MediaWiki versions:

1.26 – 1.35

DESCRIBEpagelinks;

+-------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+-------+ | pl_from | int(10) unsigned | NO | PRI | 0 | | | pl_from_namespace | int(11) | NO | MUL | 0 | | | pl_namespace | int(11) | NO | PRI | 0 | | | pl_title | varbinary(255) | NO | PRI | | | +-------------------+------------------+------+-----+---------+-------+

MediaWiki versions:

1.24 – 1.25

DESCRIBEpagelinks;

+-------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+------------------+------+-----+---------+-------+ | pl_from | int(10) unsigned | NO | PRI | 0 | | | pl_from_namespace | int(11) | NO | | 0 | | | pl_namespace | int(11) | NO | PRI | 0 | | | pl_title | varbinary(255) | NO | PRI | | | +-------------------+------------------+------+-----+---------+-------+

MediaWiki versions:

1.10 – 1.23

DESCRIBEpagelinks;

+--------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+---------------------+------+-----+---------+-------+ | pl_from | int(10) unsigned | NO | PRI | 0 | | | pl_namespace | int(11) | NO | PRI | 0 | | | pl_title | varchar(255) binary | NO | PRI | NULL | | +--------------+---------------------+------+-----+---------+-------+

MediaWiki versions:

1.5 – 1.9

DESCRIBEpagelinks;

+--------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+---------------------+------+-----+---------+-------+ | pl_from | int(8) unsigned | NO | PRI | 0 | | | pl_namespace | int(11) | NO | PRI | 0 | | | pl_title | varchar(255) binary | NO | PRI | NULL | | +--------------+---------------------+------+-----+---------+-------+

Indexes

[edit]

MediaWiki version:

≥ 1.43

SHOWINDEXINpagelinks;

+-----------+------------+----------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-----------+------------+----------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | pagelinks | 0 | PRIMARY | 1 | pl_from | A | 0 | NULL | NULL | | BTREE | | | | pagelinks | 0 | PRIMARY | 2 | pl_target_id | A | 0 | NULL | NULL | | BTREE | | | | pagelinks | 1 | pl_target_id | 1 | pl_target_id | A | 0 | NULL | NULL | | BTREE | | | | pagelinks | 1 | pl_target_id | 2 | pl_from | A | 0 | NULL | NULL | | BTREE | | | | pagelinks | 1 | pl_backlinks_namespace_target_id | 1 | pl_from_namespace | A | 0 | NULL | NULL | | BTREE | | | | pagelinks | 1 | pl_backlinks_namespace_target_id | 2 | pl_target_id | A | 0 | NULL | NULL | | BTREE | | | | pagelinks | 1 | pl_backlinks_namespace_target_id | 3 | pl_from | A | 0 | NULL | NULL | | BTREE | | | +-----------+------------+----------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

v t e Databases
Engines	Current MariaDB MySQL PostgreSQL SQLite Former Oracle SQL Server
Technical documentation	Schema (tables) API property associations Field prefixes Primary key storage in other fields Wikimedia extension tables Inconsistencies
Configuration	Settings Sharing
Development	Access Optimisation Policy Updater Extension schema updates Schema changes
Core tables	Current actor archive block block_target bot_passwords category categorylinks change_tag change_tag_def collation comment content content_models existencelinks externallinks file filearchive filerevision filetypes image imagelinks interwiki iwlinks ipblocks_restrictions ip_changes job l10n_cache langlinks linktarget logging log_search objectcache oldimage page pagelinks page_props page_restrictions protected_titles querycache querycachetwo querycache_info recentchanges redirect revision searchindex sites site_identifiers site_stats slots slot_roles templatelinks text updatelog uploadstash user user_autocreate_serial user_former_groups user_groups user_newtalk user_properties watchlist watchlist_expiry watchlist_label watchlist_label_member Former blobs brokenlinks config cur external_user hitcounter image_comment_temp ipblocks ipblocks_old links linkscc math module_deps msg_resource msg_resource_links old profiling revision_actor_temp revision_comment_temp tag_summary trackbacks transcache user_rights valid_tag validate