Manual:Category table

From MediaWiki.org

↑ Manual:Contents

MediaWiki database layout

Category table

Track all existing categories. Something is a category if 1) it has an entry somewhere in categorylinks, or 2) it once did. Categories might not have corresponding pages, so they need to be tracked separately.

 +-------------+---------------------+------+-----+---------+----------------+
 | Field       | Type                | Null | Key | Default | Extra          |
 +-------------+---------------------+------+-----+---------+----------------+
 | cat_id      | int(10) unsigned    |      | PRI | NULL    | auto_increment |
 | cat_title   | varchar(255)        |      | UNI |         |                |
 | cat_pages   | int(11)             |      | MUL | 0       |                |
 | cat_subcats | int(11)             |      |     | 0       |                |
 | cat_files   | int(11)             |      |     | 0       |                |
 | cat_hidden  | tinyint(3) unsigned |      |     | 0       |                |
 +-------------+---------------------+------+-----+---------+----------------+

[edit] Fields

cat_id 

Primary key

cat_title 

Name of the category, in the same form as page_title (with underscores). If there is a category page corresponding to this category, by definition, it has this name (in the Category namespace).

cat_pages 

Number of pages in the category

cat_subcats 

Number of sub-categories in the category

cat_files 

Number of files in the category

cat_hidden 

Reserved for future use

Note: The number fields are signed to make underflow more obvious. We make the first number include the second two for better sorting: subtracting for display is easy, adding for ordering is not.

Note: If the information in this table is incorrect, run the maintenance script populateCategory.php, if neccessary with the --force option.