Manual:Templatelinks table

↑ Manual:Contents

MediaWiki database layout

Templatelinks table

MediaWiki version:

≥ 1.6

Contains for each current page inclusion 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.[1]

Schema summary

MediaWiki version:

1.16

DESCRIBE templatelinks; on MediaWiki 1.16 gives the following:

+--------------+------------------+------+-----+---------+-------+
| 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 |         |       |
+--------------+------------------+------+-----+---------+-------+

MediaWiki version:

1.9

DESCRIBE templatelinks; on MediaWiki 1.9 gives the following:

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

MediaWiki version:

1.8

DESCRIBE templatelinks; on MediaWiki 1.8 gives the following:

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

MediaWiki version:

1.6

This table is new in version 1.6.

DESCRIBE templatelinks; on MediaWiki 1.6 gives the following:

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