Jump to content

Manual:site_identifiers テーブル

From mediawiki.org
This page is a translated version of the page Manual:Site identifiers table and the translation is 40% complete.
Manual:コンテンツ MediaWiki のデータベース レイアウト site_identifiers テーブル
MediaWiki バージョン:
1.21

The site_identifiers table contains:

フィールド

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.

スキーマの要約

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

インデックス

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