Manual:Redirect table

↑ Manual:Contents

MediaWiki database layout

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.

NOTE: as of August 2007, database dumps for Wikipedia and other Wikimedia projects as provided on http://download.wikimedia.org/ have incomplete data in this table: only redirect pages that have been created or edited recently are present. For older redirects, resort to using the pagelinks table.

Fields

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

rd_from

Contains the page_id of the source page.

rd_namespace

Contains the number of the target's namespace.

rd_title

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

rd_fragment

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

rd_interwiki

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.

Schema summary

MediaWiki version:

1.19

mysql> 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 version:

1.18

DESCRIBE redirect; in MediaWiki 1.18 results in:

+--------------+-----------------+------+-----+---------+-------+
| Field        | Type            | Null | Key | Default | Extra |
+--------------+-----------------+------+-----+---------+-------+
| rd_from      | int(8) unsigned | NO   |     | 0       |       |
| rd_namespace | int(11)         | NO   |     | 0       |       |
| rd_title     | varbinary(255)  | NO   |     |         |       |
| rd_interwiki | varbinary(32)   | YES  |     | NULL    |       |
| rd_fragment  | varbinary(255)  | YES  |     | NULL    |       |
+--------------+-----------------+------+-----+---------+-------+

MediaWiki version:

1.9

DESCRIBE mw_redirect; in version 1.9 gives the following:

mysql> describe mw_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)    | NO   |     | NULL    |       |
+--------------+-----------------+------+-----+---------+-------+
3 rows in set (0.02 sec)

Language:	English  • 日本語