Manual:iwlinks table
↑ Manual:Contents | MediaWiki database layout | iwlinks table |
MediaWiki version: | ≥ 1.17 |
The iwlinks table stores the interwiki links with their targets. Not to confuse with the Langlinks table.
Fields[edit]
iwl_from[edit]
The page_id
of the referring page (i.e. the local page that the link appears on).
iwl_prefix[edit]
interwiki prefix code of the target. This is used the same way as a namespace is used when editing.
iwl_title[edit]
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".
Schema summary[edit]
MediaWiki version: | ≥ 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 | | | +------------+------------------+------+-----+---------+-------+
MediaWiki versions: | 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 | | | +------------+------------------+------+-----+---------+-------+
Indexes[edit]
MediaWiki version: | ≥ 1.30 |
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 | | | | iwlinks | 1 | iwl_prefix_from_title | 1 | iwl_prefix | A | 0 | NULL | NULL | | BTREE | | | | iwlinks | 1 | iwl_prefix_from_title | 2 | iwl_from | A | 0 | NULL | NULL | | BTREE | | | | iwlinks | 1 | iwl_prefix_from_title | 3 | iwl_title | A | 0 | NULL | NULL | | BTREE | | | +---------+------------+-----------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
See also[edit]
- Manual:Interwiki table
- Manual:Langlinks table
- Manual:Pagelinks table
- r65104, adding this table to the schema