↑ 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.

As of August 2007, database dumps for Wikipedia and other Wikimedia projects as provided on https://dumps.wikimedia.org/ have incomplete data in this table: only redirect pages that have been created or edited after summer 2007 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_interwiki

MediaWiki version:
≥ 1.16

This field is not empty only if an {{ll|Manual:Interwiki table|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

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

Schema summary

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

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      |         |               |
+----------+------------+-------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
This article is issued from Mediawiki. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.