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

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

↑ Manuál:Obsah

MediaWiki schéma databáze

Tabulka iwlinks

Verze MediaWiki:

≥ 1.17

The iwlinks table stores the interwiki links with their targets. Not to confuse with the Langlinks table.

Pole

iwl_from

The page_id of the referring page (i.e. the local page that the link appears on).

iwl_prefix

interwiki prefix code of the target. This is used the same way as a namespace is used when editing.

iwl_title

The title of the target page, including namespace (FULLPAGENAME style). Spaces are converted to underscores, but the first letter is not automatically capitalized. So for example, an interwiki link to w:foo bar would have an iwl_title of "foo_bar".

Přehled změn ve schématu tabulky

Verze MediaWiki:

≥ 1.35

DESCRIBE iwlinks;

+------------+------------------+------+-----+---------+-------+
| Field      | Type             | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| iwl_from   | int(10) unsigned | NO   | PRI | 0       |       |
| iwl_prefix | varbinary(32)    | NO   | PRI |         |       |
| iwl_title  | varbinary(255)   | NO   | PRI |         |       |
+------------+------------------+------+-----+---------+-------+

Verze MediaWiki:

1.17 – 1.34

DESCRIBE iwlinks;

+------------+------------------+------+-----+---------+-------+
| Field      | Type             | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+-------+
| iwl_from   | int(10) unsigned | NO   | PRI | 0       |       |
| iwl_prefix | varbinary(20)    | NO   | PRI |         |       |
| iwl_title  | varbinary(255)   | NO   | PRI |         |       |
+------------+------------------+------+-----+---------+-------+

Indexy

Verze MediaWiki:

≥ 1.42

SHOW INDEX IN iwlinks;

+---------+------------+-----------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table   | Non_unique | Key_name              | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+---------+------------+-----------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| iwlinks |          0 | PRIMARY               |            1 | iwl_from    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| iwlinks |          0 | PRIMARY               |            2 | iwl_prefix  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| iwlinks |          0 | PRIMARY               |            3 | iwl_title   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| iwlinks |          1 | iwl_prefix_title_from |            1 | iwl_prefix  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| iwlinks |          1 | iwl_prefix_title_from |            2 | iwl_title   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| iwlinks |          1 | iwl_prefix_title_from |            3 | iwl_from    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+---------+------------+-----------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

Viz též