Manual:Links table


 * Note: 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. See 

The links table stores all the links to existing articles. This is good for a variety of functions, from link caching in the output functions to the "what links here" page. It is the good twin of the brokenlinks table.

+--+--+--+-+-+---+ +--+--+--+-+-+---+ +--+--+--+-+-+---+
 * Field   | Type             | Null | Key | Default | Extra |
 * l_from  | int(8) unsigned  | NO   | UNI | 0       |       |
 * l_to    | int(8) unsigned  | NO   |     | 0       |       |

l_from is the cur_id of the article that contains the link. (This is a change from 1.2, wherein the title of the article was stored. This was not very wise, and has now been fixed.)

l_to is the cur_id of the "target" article.

+--+--+--+-+-+---+ +--+--+--+-+-+---+ +--+--+--+-+-+---+
 * Field   | Type             | Null | Key | Default | Extra |
 * l_from  | varchar(255)     | NO   | UNI | 0       |       |
 * l_to    | int(8) unsigned  | NO   |     | 0       |       |