Manual:Iwlinks table/es
↑ Manual: Contenidos de | MediaWiki database layout | iwlinks table |
Versión de MediaWiki: | ≥ 1.17 |
The iwlinks table stores the interwiki links with their targets. Not to confuse with the Langlinks table.
Campos
iwl_from
The page_id
of the referring page (i.e. the local page that the link appears on).
iwl_prefix
interwiki prefix code of the target. This is used the same way as a namespace is used when editing.
iwl_title
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
Versión de MediaWiki: | ≥ 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 | | | +------------+------------------+------+-----+---------+-------+
Versiones de MediaWiki: | 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
Versión de MediaWiki: | ≥ 1.42 |
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 | | | +---------+------------+-----------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
Véase también
- Manual:Interwiki table
- Manual:Langlinks table
- Manual:Pagelinks table
- r65104, adding this table to the schema