Manual:Templatelinks table/pl

From mediawiki.org
This page is a translated version of the page Manual:Templatelinks table and the translation is 0% complete.
Podręcznik:Spis treści Opis i struktura bazy danych MediaWiki Tabela templatelinks
Wersja MediaWiki:
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

tl_from

Key to the page_id of the page containing the link.

tl_namespace

Wersje MediaWiki:
1.6 – 1.38

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

tl_title

Wersje MediaWiki:
1.6 – 1.38

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

tl_from_namespace

Wersja MediaWiki:
1.24

page_namespace of the page containing the link.

tl_target_id

Wersja MediaWiki:
1.38

Foreign key to linktarget.lt_id

Schema summary

Wersja MediaWiki:
1.39

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_target_id      | bigint(20) unsigned | YES  | MUL | NULL    |       |
+-------------------+---------------------+------+-----+---------+-------+
Wersja 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    |       |
+-------------------+---------------------+------+-----+---------+-------+
Wersje 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       |       |
+-------------------+------------------+------+-----+---------+-------+
Wersje 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 |         |       |
+-------------------+------------------+------+-----+---------+-------+
Wersje 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         |       |
+-------------------+---------------------+------+-----+-----------+-------+
Wersje 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         |       |
+---------------+---------------------+------+-----+-----------+-------+
Wersje 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

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