Manual:Redirect table/es

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 13% complete.

Other languages:
English • ‎español • ‎français • ‎日本語
Manual: Contenido MediaWiki database layout redirect table/es


Versión de 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.

Campos

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 Espacio de nombres .

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

Versión de 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.

Resumen del esquema

Versión de 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    |       |
+--------------+------------------+------+-----+---------+-------+
Versiones de 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    |       |
+--------------+---------------------+------+-----+---------+-------+
Versión de 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    |       |
+--------------+---------------------+------+-----+---------+-------+