WSoR datasets/categorylinks wp

From Meta, a Wikimedia project coordination wiki
Jump to: navigation, search

This table links WikiProject related category names with their respective WikiProject via the WikiProject main page id.

Location[edit]

db42:shawn.categorylink_wp

Fields[edit]

        shawn@internproxy:~$ mysql -h db1048 -e "EXPLAIN categorylinks_wp;SELECT * FROM categorylinks_wp LIMIT 3" shawn
        +---------------+----------------+------+-----+---------+-------+
        | Field         | Type           | Null | Key | Default | Extra |
        +---------------+----------------+------+-----+---------+-------+
        | wp_page_id    | int(11)        | YES  |     | NULL    |       |
        | category_link | varbinary(255) | YES  |     | NULL    |       |
        +---------------+----------------+------+-----+---------+-------+
        +------------+-------------------------+
        | wp_page_id | category_link           |
        +------------+-------------------------+
        |    5186090 | WikiProject_24          |
        |    5186090 | WikiProject_24_articles |
        |    5186090 | WikiProject_24_members  |
        +------------+-------------------------+

Each row represents a categorylink and the page_id of the WikiProject it is related to.

  • wp_page_id: id of the WikiProject main page
  • category_link: category link name

Reproduction[edit]

CREATE TABLE `categorylinks_wp` (

 `wp_page_id` int(11) DEFAULT NULL,
 `category_link` varbinary(255) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=binary;

Run the script categorylinks_wikiprojects.py to populate the table.

Notes[edit]

This table was generated on 2011-07-13 18:15:33. It depends on the table categorylinks.