Manual:interwiki テーブル
| ↑ Manual:コンテンツ | MediaWiki のデータベース レイアウト | interwiki テーブル |
interwiki テーブルは、インターウィキ接頭辞とそのターゲットを保持します。 既定のインターウィキ接頭辞を参照してください。 インターウィキ リンク自身は iwlinks テーブルに格納されます。 このデータは Interwiki クラスを使用してアクセスできます。
フィールド
iw_prefix
The prefix of the interwiki link; this is used the same way as a namespace is used when editing.
iw_url
The target of the link; the page name is substituted for $1.
iw_api
| MediaWiki バージョン: | ≧ 1.17 |
The URL of the file api.php. This is not used except by ApiQuerySiteinfo::appendInterwikiMap(), when an interwiki map is requested via siprop=interwikimap.
iw_wikiid
| MediaWiki バージョン: | ≧ 1.17 |
The name of the database (for a connection to be established with wfGetLB( 'wikiid' ))
iw_local
Informs MediaWiki how it should treat interwiki links coming from external sources. If iw_local is 1, then it will treat these links as though they were generated from within the local wiki.
- For example, the interwiki link fr: on the en.wikipedia.org project has iw_local=1 set.
Therefore, the link to https://en.wikipedia.org/wiki/fr:Accueil gracefully redirects you to the French Homepage (Accueil).
However, the WorldCat ISSN catalog is flagged 0 on en.wikipedia.org; the link to https://en.wikipedia.org/wiki/issn:1021-9749 does not work, even though [[issn:1021-9749]] would work if it were on a local Wikipedia page.
iw_trans
This is used to allow transcluding templates (or other pages) from another MediaWiki installation.
Both $wgEnableScaryTranscluding and iw_trans need to be on.
スキーマの要約
| MediaWiki バージョン: | ≧ 1.17 |
DESCRIBE interwiki;
+-----------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------------+------+-----+---------+-------+ | iw_prefix | varbinary(32) | NO | PRI | NULL | | | iw_url | blob | NO | | NULL | | | iw_api | blob | NO | | NULL | | | iw_wikiid | varbinary(64) | NO | | NULL | | | iw_local | tinyint(1) | NO | | NULL | | | iw_trans | tinyint(4) | NO | | 0 | | +-----------+---------------+------+-----+---------+-------+
| MediaWiki バージョン: | 1.10 – 1.16 |
DESCRIBE interwiki;
+-----------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------------+------+-----+---------+-------+ | iw_prefix | varbinary(32) | NO | PRI | NULL | | | iw_url | blob | NO | | NULL | | | iw_local | tinyint(1) | NO | | NULL | | | iw_trans | tinyint(4) | NO | | 0 | | +-----------+---------------+------+-----+---------+-------+
| MediaWiki バージョン: | 1.5 – 1.9 |
DESCRIBE interwiki;
+-----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------+------+-----+---------+-------+ | iw_prefix | char(32) | NO | PRI | NULL | | | iw_url | char(127) | NO | | NULL | | | iw_local | bool | NO | | NULL | | | iw_trans | tinyint(1) | NO | | 0 | | +-----------+------------+------+-----+---------+-------+
| MediaWiki バージョン: | 1.1 – 1.4 |
DESCRIBE interwiki;
+-----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------+------+-----+---------+-------+ | iw_prefix | char(32) | NO | PRI | NULL | | | iw_url | char(127) | NO | | NULL | | | iw_local | bool | NO | | NULL | | +-----------+------------+------+-----+---------+-------+
インデックス
| MediaWiki バージョン: | ≧ 1.32 |
SHOW INDEX IN interwiki;
+-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | interwiki | 0 | PRIMARY | 1 | iw_prefix | A | 0 | NULL | NULL | | BTREE | | | +-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+