Manual:Brokenlinks table

Note: 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.wikitech-l/2005-May/017434.html

The brokenlinks table stores links to articles that don't exist yet. This is used for Special:Wantedpages (which is sometimes disabled), and perhaps for some link caching. It is the twin of the links table.

++-+--+-+-+---+ | Field     | Type                | Null | Key | Default | Extra | ++-+--+-+-+---+ | bl_from   | int(8) unsigned     |      | MUL | 0       |       | | bto       | varchar(255) binary |      | MUL |         |       | ++-+--+-+-+---+

bl_from stores the cur_id of the article where the link was put, bl_to stores the name (including namespace prefix) of the desired article.