Manual:templatelinks table
| ↑ Manual:Contents | MediaWiki database layout | templatelinks table |
| MediaWiki version: | ≥ 1.6 |
The templatelinks table contains for each current transclusion the id of the host page, the namespace number of the included page, and its title without namespace.
The target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by.
Fields[edit]
tl_from[edit]
Key to the page_id of the page containing the link.
tl_namespace[edit]
| MediaWiki versions: | 1.6 – 1.38 |
Key to page_namespace of the target page. Used in conjunction with tl_title.
tl_title[edit]
| MediaWiki versions: | 1.6 – 1.38 |
Key to page_title of the target page. Used in conjunction with tl_namespace.
tl_from_namespace[edit]
| MediaWiki version: | ≥ 1.24 |
page_namespace of the page containing the link.
tl_target_id[edit]
| MediaWiki version: | ≥ 1.38 |
Foreign key to linktarget.lt_id
Schema summary[edit]
| MediaWiki version: | ≥ 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 | | +-------------------+---------------------+------+-----+---------+-------+
| MediaWiki version: | 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 | | +-------------------+---------------------+------+-----+---------+-------+
| MediaWiki versions: | 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 | | +-------------------+------------------+------+-----+---------+-------+
| MediaWiki versions: | 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 | | | +-------------------+------------------+------+-----+---------+-------+
| MediaWiki versions: | 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 | | +-------------------+---------------------+------+-----+-----------+-------+
| MediaWiki versions: | 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 | | +---------------+---------------------+------+-----+-----------+-------+
| MediaWiki versions: | 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[edit]
| MediaWiki version: | ≥ 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 | | | +---------------+------------+----------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+