Manual:Tabela de Interwiki

This page is a translated version of the page Manual:Interwiki table and the translation is 26% complete.
Outdated translations are marked like this.
Manual:Conteúdos Disposição da base de dados do MediaWiki Tabela das interwiki

A tabela interwiki guarda os prefixos da interwiki com os seus destinos. Consulte os [$url prefixos da interwiki predefinidos]. The interwiki links themselves are stored in the iwlinks table. This data can be accessed using the Interwiki class.

Campos

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

Versão 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

Versão 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.

Resumo de esquema

Versão 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       |       |
+-----------+---------------+------+-----+---------+-------+
Versões do 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       |       |
+-----------+---------------+------+-----+---------+-------+
Versões do 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       |       |
+-----------+------------+------+-----+---------+-------+
Versões do 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    |       |
+-----------+------------+------+-----+---------+-------+

Indexes

Versão 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      |         |               |
+-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

Ver também