Manual:brokenlinks table

↑ Podręcznik:Spis treści

Opis i struktura bazy danych MediaWiki

Tabela brokenlinks

Wersja 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.html

Tabela brokenlinks przechowuje linki do artykułów, które jeszcze nie zostały utworzone a podano do nich linki w innych artykułach. This was used for Special:Wantedpages (which was sometimes disabled), and perhaps for some link caching. Parą jest tabela links .

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 przechowuje cur_id artykułu, gdzie umieszczono link, bl_to przechowuje nazwę(wraz z prefiksem przestrzeni nazw) docelowego artykułu.

Schema summary

Wersje 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 |         |       |
+---------+-----------------+------+-----+---------+-------+

Wersja MediaWiki:

1.1

+---------+-----------------+------+-----+---------+-------+
| Field   | Type            | Null | Key | Default | Extra |
+---------+-----------------+------+-----+---------+-------+
| bl_from | int(8) unsigned | NO   |     | 0       |       |
| bl_to   | varchar(255)    | NO   |     |         |       |
+---------+-----------------+------+-----+---------+-------+

Indexes

Wersje 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      |         |               |
+-------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+