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]

Fields

tl_from

Key to the page_id of the page containing the link.

tl_from_namespace

MediaWiki version:

≥ 1.24

page_namespace of the page containing the link.

tl_namespace

Key to page_namespace of the target page. Used in conjunction with tl_title.

tl_title

Key to page_title of the target page. Used in conjunction with tl_namespace.

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

Databases

Engines: MySQL – Oracle – PostgreSQL – SQLite Technical documentation: Schema (tables) – API property associations – Field prefixes – Primary key storage in other fields – Wikimedia extension tables Configuration: Settings – Sharing Development: Access – Optimization – Policy – Updater – Extension schema updates – Patch file Core tables: archive – category – categorylinks – change_tag – config – externallinks – filearchive – hitcounter – image – imagelinks – interwiki – iwlinks – ipblocks – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – searchindex – sites – site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist