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

↑ Manuál:Obsah

MediaWiki schéma databáze

Tabulka site_identifiers

Verze MediaWiki:

≥ 1.21

Tabulka site_identifiers obsahuje:

Pole

si_site

Id of site record in sites table.

si_type

One of two values:

• interwiki: the key is an interwiki link identifier such as en, tr, simple
• equivalent: the key is a navigation id used in e.g. the "language links" section

In most cases these entries are both present and are identical for Wikimedia sites. Some sites have only an interwiki entry, for example commons, mediawiki, meta.

si_key

A language code or other link code, such as en, tr, simple, commons, plwikimedia, identifying a site's type for purposes of links between sites in a wiki farm.

Přehled změn ve schématu tabulky

Verze MediaWiki:

≥ 1.35

DESCRIBE site_identifiers;

+---------+------------------+------+-----+---------+-------+
| Field   | Type             | Null | Key | Default | Extra |
+---------+------------------+------+-----+---------+-------+
| si_type | varbinary(32)    | NO   | PRI | NULL    |       |
| si_key  | varbinary(32)    | NO   | PRI | NULL    |       |
| si_site | int(10) unsigned | NO   | MUL | NULL    |       |
+---------+------------------+------+-----+---------+-------+

Verze MediaWiki:

1.21 – 1.34

DESCRIBE site_identifiers;

+---------+------------------+------+-----+---------+-------+
| Field   | Type             | Null | Key | Default | Extra |
+---------+------------------+------+-----+---------+-------+
| si_site | int(10) unsigned | NO   | MUL | NULL    |       |
| si_type | varbinary(32)    | NO   | PRI | NULL    |       |
| si_key  | varbinary(32)    | NO   | PRI | NULL    |       |
+---------+------------------+------+-----+---------+-------+

Indexy

Verze MediaWiki:

≥ 1.36

SHOW INDEX IN site_identifiers;

+------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table            | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| site_identifiers |          0 | PRIMARY  |            1 | si_type     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| site_identifiers |          0 | PRIMARY  |            2 | si_key      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| site_identifiers |          1 | si_site  |            1 | si_site     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| site_identifiers |          1 | si_key   |            1 | si_key      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+