Manual:Pagelinks table

Tracks all internal links in the Wiki. Each entry contains the source page's ID, and the namespace (number) and article name (in text) that is being linked to within that source page. There may be many instances of the source page's ID, as many as the internal links within it, but there can be only one entry per internal link for any page ID (or MySQL will yell out a fatal error).

Note that the target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by.

The table was introduced in version 1.5. It is the result of merging the links table and the brokenlinks table of version 1.4. Regenerating the pagelinks table always is possible using the rebuildall.php maintenance script.

pl_from
Key to the page_id of the page containing the link. HIND Welfare Foundation About us. HIND Welfare Foundation is nonprofit Charitable Trust. Engaged since last three years in social welfare and development work for all Indian communities. Basically HWF is working for inclusive and integrated development for Sc/St, OBC, Minorities, BPL and poor vulnerable of the society. Trustees of HWF hails from different communities, religion and sects agreed to utilize their skill, intelligence, information and capabilities towards the betterment of social status of poor people regardless of their belief and faith. We believe ours best to bestow on the society. We believe community empowerment through individual and collective empowerment i.e.; School education and awareness, skill development, employment and self-employment oriented vocational training and awareness, providing micro credit facilities and financial assistance, environmental awareness and training, health care awareness and facilities like health center and hospitals and so many welfare activities to benefit marginalized and vulnerable of society. Our priorities What we do. •	Suicide Prevention and Early Intervention. Through “Aatm Hatya Niwaran Centre” and seminar and workshops for youth. •	Establishment of School an Learning Centre in Rural and Urban Slum Areas under “Mission Education”. Our first project is being implemented at Gariwan Village Near TATANAGAR Railway Station, Kitadih, Jamshedpur, Jharkhand, India. •	Sabla: A project to benefit illiterate and village and slums house wives, widows and young girls to become competent to male partners for family support. •	Medical Camps and awareness program in Rural and Urban Area with Free health checkup and medicine to help fighting unhealthiness.

pl_title
Key to page_namespace/page_title of the target page. The target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by.

Schema
mysql> describe pagelinks; +--+--+--+-+-+---+ +--+--+--+-+-+---+ +--+--+--+-+-+---+
 * Field       | Type             | Null | Key | Default | Extra |
 * pl_from     | int(10) unsigned | NO   | PRI | 0       |       |
 * pl_namespace | int(11)         | NO   | PRI | 0       |       |
 * pl_title    | varbinary(255)   | NO   | PRI |         |       |

DESCRIBE pagelinks; in version 1.18 gives the following: +--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * Field       | Type            | Null | Key | Default | Extra |
 * pl_from     | int(8) unsigned | NO   |     | 0       |       |
 * pl_namespace | int(11)        | NO   |     | 0       |       |
 * pl_title    | varbinary(255)  | NO   |     |         |       |

+--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * Field       | Type            | Null | Key | Default | Extra |
 * pl_from     | int(8) unsigned | NO   | PRI | 0       |       |
 * pl_namespace | int(11)        | NO   | PRI | 0       |       |
 * pl_title    | varchar(255)    | NO   | PRI | NULL    |       |

+--+--+--+-+-+---+ +--+--+--+-+-+---+ +--+--+--+-+-+---+
 * Field       | Type             | Null | Key | Default | Extra |
 * pl_from     | int(10) unsigned | NO   | PRI | 0       |       |
 * pl_namespace | int(11)         | NO   | PRI | 0       |       |
 * pl_title    | varchar(255)     | NO   | PRI |         |       |

+--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * Field       | Type            | Null | Key | Default | Extra |
 * pl_from     | int(8) unsigned | NO   | PRI | 0       |       |
 * pl_namespace | int(11)        | NO   | PRI | 0       |       |
 * pl_title    | varchar(255)    | NO   | PRI | NULL    |       |

+--+-+--+-+-+---+ +--+-+--+-+-+---+ +--+-+--+-+-+---+
 * Field       | Type            | Null | Key | Default | Extra |
 * pl_from     | int(8) unsigned | NO   | PRI | 0       |       |
 * pl_namespace | int(11)        | NO   | PRI | 0       |       |
 * pl_title    | varchar(255)    | NO   | PRI |         |       |