Manual:redirect テーブル

From MediaWiki.org
Jump to navigation Jump to search
This page is a translated version of the page Manual:Redirect table and the translation is 20% complete.
Other languages:
English • ‎español • ‎français • ‎日本語
Manual:コンテンツ MediaWiki のデータベース レイアウト redirect table/ja


MediaWiki バージョン: 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.

フィールド

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 名前空間 .

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

MediaWiki バージョン: 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.

スキーマの要約

MediaWiki バージョン: 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 バージョン: 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 バージョン: 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    |       |
+--------------+---------------------+------+-----+---------+-------+