Manuel:table templatelinks

This page is a translated version of the page Manual:Templatelinks table and the translation is 100% complete.
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é du page_id de la page qui contient le lien.

tl_namespace

Versions de MediaWiki :
1.6 – 1.38

Clé du page_namespace de la page cible. Utilisé en conjonction avec tl_title.

tl_title

Versions de MediaWiki :
1.6 – 1.38

Clé du page_title de la page cible. Utilisé en conjonction avec tl_namespace.

tl_from_namespace

Version de MediaWiki :
1.24

page_namespace de la page qui contient le lien.

tl_target_id

Version de MediaWiki :
1.38

Clé externe de linktarget.lt_id

Résumé du schéma

Version de MediaWiki :
1.39

DESCRIBE templatelinks;

+-------------------+---------------------+------+-----+---------+-------+
| Field             | Type                | Null | Key | Default | Extra |
+-------------------+---------------------+------+-----+---------+-------+
| tl_from           | int(10) unsigned    | NO   | PRI | 0       |       |
| tl_target_id      | bigint(20) unsigned | NO   | PRI | NULL    |       |
| tl_from_namespace | int(11)             | NO   | MUL | 0       |       |
+-------------------+---------------------+------+-----+---------+-------+
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         |       |
+---------------+---------------------+------+-----+-----------+-------+


Les index

Version de MediaWiki :
1.39

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_target_id      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| templatelinks |          1 | tl_target_id                     |            1 | tl_target_id      | A         |           0 |     NULL | NULL   |      | 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   |      | BTREE      |         |               |
| templatelinks |          1 | tl_backlinks_namespace_target_id |            3 | tl_from           | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+---------------+------------+----------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+