Manual:pagelinks/fr table
From Linux Web Expert
| ↑ Manuel:Contenu | <translate> MediaWiki database layout</translate> | <translate> <tvar name=1>pagelinks/fr</tvar> table</translate> |
| Version de MediaWiki : | <translate> ≥</translate> 1.5 |
The pagelinks table tracks all internal links in the wiki. Each entry contains the source page's ID and namespace (number), and the article name (in text) 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
pl_from
page_id de la page contenant le lien.
pl_namespace
page_namespace de la page cible. 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
Le titre de la page cible dans le format page_title.
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.
pl_from_namespace
| Version de MediaWiki : | <translate> ≥</translate> 1.24 |
page_namespace de la page contenant le lien.
pl_target_id
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.41
Gerrit change 941474| <translate> MediaWiki version:</translate> |
Foreign key to linktarget.
Schema summary
<translate> ≥</translate> 1.41
| <translate> MediaWiki version:</translate> |
DESCRIBE pagelinks/fr;
+-------------------+---------------------+------+-----+---------+-------+ | 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 | | +-------------------+---------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.40</tvar> is legacy version</translate>">
1.36 – 1.40
| <translate> MediaWiki versions:</translate> |
DESCRIBE pagelinks/fr;
+-------------------+------------------+------+-----+---------+-------+ | 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 | | +-------------------+------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.35</tvar> is unsupported version</translate>">
1.26 – 1.35
| <translate> MediaWiki versions:</translate> |
DESCRIBE pagelinks/fr;
+-------------------+------------------+------+-----+---------+-------+ | 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 | | | +-------------------+------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.25</tvar> is unsupported version</translate>">
1.24 – 1.25
| <translate> MediaWiki versions:</translate> |
DESCRIBE pagelinks/fr;
+-------------------+------------------+------+-----+---------+-------+ | 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 | | | +-------------------+------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.23</tvar> is unsupported version</translate>">
1.10 – 1.23
| <translate> MediaWiki versions:</translate> |
DESCRIBE pagelinks/fr;
+--------------+---------------------+------+-----+---------+-------+ | 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 | | +--------------+---------------------+------+-----+---------+-------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.9</tvar> is unsupported version</translate>">
1.5 – 1.9
| <translate> MediaWiki versions:</translate> |
DESCRIBE pagelinks/fr;
+--------------+---------------------+------+-----+---------+-------+ | 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
<translate> ≥</translate> 1.41
| <translate> MediaWiki version:</translate> |
SHOW INDEX IN pagelinks/fr;
+-----------+------------+----------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | 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_namespace | A | 0 | NULL | NULL | | BTREE | | | | pagelinks | 0 | PRIMARY | 3 | pl_title | A | 0 | NULL | NULL | | BTREE | | | | pagelinks | 1 | pl_namespace | 1 | pl_namespace | A | 0 | NULL | NULL | | BTREE | | | | pagelinks | 1 | pl_namespace | 2 | pl_title | A | 0 | NULL | NULL | | BTREE | | | | pagelinks | 1 | pl_namespace | 3 | pl_from | A | 0 | NULL | NULL | | BTREE | | | | pagelinks | 1 | pl_backlinks_namespace | 1 | pl_from_namespace | A | 0 | NULL | NULL | | BTREE | | | | pagelinks | 1 | pl_backlinks_namespace | 2 | pl_namespace | A | 0 | NULL | NULL | | BTREE | | | | pagelinks | 1 | pl_backlinks_namespace | 3 | pl_title | A | 0 | NULL | NULL | | BTREE | | | | pagelinks | 1 | pl_backlinks_namespace | 4 | pl_from | A | 0 | NULL | NULL | | BTREE | | | | pagelinks | 1 | pl_target_id | 1 | pl_target_id | A | 0 | NULL | NULL | YES | 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 | YES | BTREE | | | | pagelinks | 1 | pl_backlinks_namespace_target_id | 3 | pl_from | A | 0 | NULL | NULL | | BTREE | | | +-----------+------------+----------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
