Manual:Tabla brokenlinks
↑ Manual: Contenidos de | MediaWiki database layout | brokenlinks table |
Versión de MediaWiki: | ≤ 1.4 |
Since MediaWiki 1.5, the
links
and brokenlinks
tables have been merged to a single pagelinks table, which records the namespace+title key pair of target links rather than the page ID or the prefixed title. mailarchive:wikitech-l/2005-May/017434.htmlThe brokenlinks table stored links to articles that don't exist yet. This was used for Special:Wantedpages (which was sometimes disabled), and perhaps for some link caching. It was the twin of the links table.
Beginning with the MediaWiki 1.5 release this table is not used, and can be safely deleted.
The contents have been migrated to the pagelinks table on update.
Regenerating the pagelinks
table always is possible using the rebuildall.php maintenance script.
bl_from stores the cur_id
of the article which contains the link, bl_to stores the name (including namespace prefix) of the desired article.
Schema summary
Versiones de MediaWiki: | 1.2 – 1.4 |
+---------+-----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-----------------+------+-----+---------+-------+ | bl_from | int(8) unsigned | NO | PRI | 0 | | | bl_to | varchar(255) | NO | PRI | | | +---------+-----------------+------+-----+---------+-------+
Versión de MediaWiki: | 1.1 |
+---------+-----------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-----------------+------+-----+---------+-------+ | bl_from | int(8) unsigned | NO | | 0 | | | bl_to | varchar(255) | NO | | | | +---------+-----------------+------+-----+---------+-------+
Indexes
Versiones de MediaWiki: | 1.2 – 1.4 |
SHOW INDEX IN brokenlinks;
+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | brokenlinks | 0 | bl_from | 1 | bl_from | A | 0 | NULL | NULL | | BTREE | | | | brokenlinks | 0 | bl_from | 2 | bl_to | A | 0 | NULL | NULL | | BTREE | | | | brokenlinks | 1 | bl_to | 1 | bl_to | A | 0 | NULL | NULL | | BTREE | | | +-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+