Příručka:Databázová tabulka templatelinks

From mediawiki.org

This page is a translated version of the page Manual:Templatelinks table and the translation is 100% complete.

Tabulka templatelinks obsahuje pro každou aktuální transkluzi ID hostitelské stránky, číslo jmenného prostoru zahrnuté stránky a její název bez jmenného prostoru.

Cílová stránka může nebo nemusí existovat a v důsledku přejmenování a smazání může časem odkazovat na různé záznamy stránky.

Navzdory názvu nejsou transkluze omezeny na šablony ani na mechanismus transkluze analyzátoru MediaWiki. Různá rozšíření používají tuto tabulku k označení, že začlenili obsah z jiné stránky. (Např. Scribunto {{#invoke:...}} a TemplateStyles <templatestyles src="..." /> oba zaznamenají cílovou stránku v tabulce templatelinks.)

Klíč k page_id na stránce provádějící transkluzi.

Klíč k page_namespace převáděné stránky. Používá se ve spojení s tl_title.

Klíč k page_title převáděné stránky. Používá se ve spojení s tl_namespace.

page_namespace stránky provádějící transkluzi.

Cizí klíč k linktarget.lt_id

DESCRIBEtemplatelinks;

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

DESCRIBEtemplatelinks;

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

DESCRIBEtemplatelinks;

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

DESCRIBEtemplatelinks;

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

DESCRIBEtemplatelinks;

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

DESCRIBEtemplatelinks;

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

DESCRIBEtemplatelinks;

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

SHOWINDEXINtemplatelinks;

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

Retrieved from "https://www.mediawiki.org/w/index.php?title=Manual:Templatelinks_table/cs&oldid=6657831"

Category:

• MediaWiki database tables/cs