Manuel:table templatelinks
↑ 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 | | | +---------------+------------+----------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+