Manual:redirect table

From mediawiki.org
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[edit]

A target is broken into four parts: interwiki prefix (should be empty for a regular redirect), namespace, title and fragment.

rd_from[edit]

Contains the page_id of the source page.

rd_namespace[edit]

Contains the number of the target's Namespace .

rd_title[edit]

Contains the sanitized title of the target page. It is stored as text, with spaces replaced by underscores.

rd_interwiki[edit]

MediaWiki 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[edit]

Contains the target's fragment ID if present (see also bugzilla:218), otherwise is NULL.

Schema summary[edit]

MediaWiki 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[edit]

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