Manual:redirect table
↑ Manual:Contents | MediaWiki database layout | redirect table |
MediaWiki version: | ≥ 1.9 |
The redirect table contains for each page that is currently a redirect (i.e., not for old revisions which are redirects) the ID of the source page and the information about target. The target page may or may not exist.
Fields
editA target is broken into four parts: interwiki prefix (should be empty for a regular redirect), namespace, title and fragment.
rd_from
editContains the page_id of the source page.
rd_namespace
editContains the number of the target's Namespace .
rd_title
editContains the sanitized title of the target page. It is stored as text, with spaces replaced by underscores.
rd_interwiki
editMediaWiki version: | ≥ 1.16 |
This field is not empty only if an interwiki prefix is used: #REDIRECT [[prefix:…]] (a prefix such as "w:" for Wikipedia, or an interlanguage link prefix such as "nl:" for Dutch, but not both).
In this case a redirect is not visible in Special:WhatLinksHere (even if the target lies in the same wiki), rd_namespace
is always 0 and rd_title
may contain a possible namespace prefix, but rd_fragment
may be non-NULL.
rd_fragment
editContains the target's fragment ID if present (see also bugzilla:218), otherwise is NULL.
Schema summary
editMediaWiki version: | ≥ 1.16 |
DESCRIBE redirect;
+--------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------------+------+-----+---------+-------+ | rd_from | int(10) unsigned | NO | PRI | 0 | | | rd_namespace | int(11) | NO | MUL | 0 | | | rd_title | varbinary(255) | NO | | | | | rd_interwiki | varbinary(32) | YES | | NULL | | | rd_fragment | varbinary(255) | YES | | NULL | | +--------------+------------------+------+-----+---------+-------+
MediaWiki versions: | 1.10 – 1.15 |
DESCRIBE redirect;
+--------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+---------------------+------+-----+---------+-------+ | rd_from | int(10) unsigned | NO | PRI | 0 | | | rd_namespace | int(11) | NO | MUL | 0 | | | rd_title | varchar(255) binary | NO | | NULL | | +--------------+---------------------+------+-----+---------+-------+
MediaWiki version: | 1.9 |
DESCRIBE redirect;
+--------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+---------------------+------+-----+---------+-------+ | rd_from | int(8) unsigned | NO | PRI | 0 | | | rd_namespace | int(11) | NO | MUL | 0 | | | rd_title | varchar(255) binary | NO | | NULL | | +--------------+---------------------+------+-----+---------+-------+
Indexes
editMediaWiki version: | ≥ 1.9 |
SHOW INDEX IN redirect;
+----------+------------+-------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +----------+------------+-------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | redirect | 0 | PRIMARY | 1 | rd_from | A | 0 | NULL | NULL | | BTREE | | | | redirect | 1 | rd_ns_title | 1 | rd_namespace | A | 0 | NULL | NULL | | BTREE | | | | redirect | 1 | rd_ns_title | 2 | rd_title | A | 0 | NULL | NULL | | BTREE | | | | redirect | 1 | rd_ns_title | 3 | rd_from | A | 0 | NULL | NULL | | BTREE | | | +----------+------------+-------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+