WSoR datasets/categorylinks wp

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.