Manuel:table templatelinks

This page is a translated version of the page Manual:Templatelinks table and the translation is 46% complete.
Outdated translations are marked like this.
Manuel:Contenu Schéma de base de données MédiaWiki table templatelinks
Version de MediaWiki :
1.6

La table templatelinks contient pour chaque transclusion actuelle, l'id de la page hôte, le numéro de l'espace de noms de la page incluse, et son titre sans l'espace de noms.

La page cible peut exister ou pas, et suite aux renommages et aux suppressions elle peut faire référence à différents enregistrements de la page dans le temps.

Champs

tl_from

Clé de l'id de la page qui contient le lien.

tl_namespace

Clé de $ns de la page cible. Utilisé en conjonction avec $title.

tl_title

Clé de $title de la page cible. Utilisé en conjonction avec $ns.

tl_from_namespace

Version de MediaWiki :
1.24

page_namespace de la page qui contient le lien.

tl_target_id

Foreign key to linktarget.lt_id

Résumé du schéma

Version de MediaWiki :
1.38

DESCRIBE templatelinks;

+-------------------+---------------------+------+-----+---------+-------+
| Field             | Type                | Null | Key | Default | Extra |
+-------------------+---------------------+------+-----+---------+-------+
| tl_from           | int(10) unsigned    | NO   | PRI | 0       |       |
| tl_namespace      | int(11)             | NO   | PRI | 0       |       |
| tl_title          | varbinary(255)      | NO   | PRI |         |       |
| tl_from_namespace | int(11)             | NO   | MUL | 0       |       |
| tl_target_id      | bigint(20) unsigned | YES  | MUL | NULL    |       |
+-------------------+---------------------+------+-----+---------+-------+
Versions de MediaWiki :
1.36 – 1.37

DESCRIBE templatelinks;

+-------------------+------------------+------+-----+---------+-------+
| Field             | Type             | Null | Key | Default | Extra |
+-------------------+------------------+------+-----+---------+-------+
| tl_from           | int(10) unsigned | NO   | PRI | 0       |       |
| tl_namespace      | int(11)          | NO   | PRI | 0       |       |
| tl_title          | varbinary(255)   | NO   | PRI |         |       |
| tl_from_namespace | int(11)          | NO   | MUL | 0       |       |
+-------------------+------------------+------+-----+---------+-------+
Versions de MediaWiki :
1.26 – 1.35

DESCRIBE templatelinks;

+-------------------+------------------+------+-----+---------+-------+
| Field             | Type             | Null | Key | Default | Extra |
+-------------------+------------------+------+-----+---------+-------+
| tl_from           | int(10) unsigned | NO   | PRI | 0       |       |
| tl_from_namespace | int(11)          | NO   | MUL | 0       |       |
| tl_namespace      | int(11)          | NO   | PRI | 0       |       |
| tl_title          | varbinary(255)   | NO   | PRI |         |       |
+-------------------+------------------+------+-----+---------+-------+
Versions de MediaWiki :
1.24 – 1.25

DESCRIBE templatelinks;

+-------------------+---------------------+------+-----+-----------+-------+
| Field             | Type                | Null | Key | Default   | Extra |
+-------------------+---------------------+------+-----+-----------+-------+
| tl_from           | int(10) unsigned    | NO   | PRI | 0         |       |
| tl_from_namespace | int(11)             | NO   |     | 0         |       |
| tl_namespace      | int(11)             | NO   | PRI | 0         |       |
| tl_title          | varchar(255) binary | NO   | PRI | 0         |       |
+-------------------+---------------------+------+-----+-----------+-------+
Versions de MediaWiki :
1.10 – 1.23

DESCRIBE templatelinks;

+---------------+---------------------+------+-----+-----------+-------+
| Field         | Type                | Null | Key | Default   | Extra |
+---------------+---------------------+------+-----+-----------+-------+
| tl_from       | int(10) unsigned    | NO   | PRI | 0         |       |
| tl_namespace  | int(11)             | NO   | PRI | 0         |       |
| tl_title      | varchar(255) binary | NO   | PRI | 0         |       |
+---------------+---------------------+------+-----+-----------+-------+
Versions de MediaWiki :
1.6 – 1.9

DESCRIBE templatelinks;

+---------------+---------------------+------+-----+-----------+-------+
| Field         | Type                | Null | Key | Default   | Extra |
+---------------+---------------------+------+-----+-----------+-------+
| tl_from       | int(8) unsigned     | NO   | PRI | 0         |       |
| tl_namespace  | int(8)              | NO   | PRI | 0         |       |
| tl_title      | varchar(255) binary | NO   | PRI | 0         |       |
+---------------+---------------------+------+-----+-----------+-------+

Indexes

Version de MediaWiki :
1.38

SHOW INDEX IN templatelinks;

+---------------+------------+----------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table         | Non_unique | Key_name                         | Seq_in_index | Column_name       | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------------+------------+----------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| templatelinks |          0 | PRIMARY                          |            1 | tl_from           | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| templatelinks |          0 | PRIMARY                          |            2 | tl_namespace      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| templatelinks |          0 | PRIMARY                          |            3 | tl_title          | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| templatelinks |          1 | tl_namespace                     |            1 | tl_namespace      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| templatelinks |          1 | tl_namespace                     |            2 | tl_title          | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| templatelinks |          1 | tl_namespace                     |            3 | tl_from           | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| templatelinks |          1 | tl_backlinks_namespace           |            1 | tl_from_namespace | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| templatelinks |          1 | tl_backlinks_namespace           |            2 | tl_namespace      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| templatelinks |          1 | tl_backlinks_namespace           |            3 | tl_title          | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| templatelinks |          1 | tl_backlinks_namespace           |            4 | tl_from           | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| templatelinks |          1 | tl_target_id                     |            1 | tl_target_id      | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
| templatelinks |          1 | tl_target_id                     |            2 | tl_from           | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| templatelinks |          1 | tl_backlinks_namespace_target_id |            1 | tl_from_namespace | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| templatelinks |          1 | tl_backlinks_namespace_target_id |            2 | tl_target_id      | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
| templatelinks |          1 | tl_backlinks_namespace_target_id |            3 | tl_from           | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+---------------+------------+----------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+