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.

FieldsEdit

iwl_fromEdit

The page_id of the referring page (i.e. the local page that the link appears on).

iwl_prefixEdit

interwiki prefix code of the target. This is used the same way as a namespace is used when editing.

iwl_titleEdit

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 summaryEdit

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

IndexesEdit

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 alsoEdit