Templatelinks table

From MediaWiki.org

↑ Manual:Contents

MediaWiki database layout

Templatelinks table

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]

MediaWiki version:

1.6

New to version 1.6.

DESCRIBE templatelinks results in:

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

MediaWiki version:

1.8

DESCRIBE templatelinks in MediaWiki 1.8 results in:

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

mysql> describe mw_templatelinks;
+--------------+-----------------+------+-----+---------+-------+
| 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    |       |
+--------------+-----------------+------+-----+---------+-------+
3 rows in set (0.02 sec)