Category table

From MediaWiki.org

Jump to: navigation, search
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.

MediaWiki version: 1.14

DESCRIBE category

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  

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 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 Note: If the information in this table is incorrect, run the maintenance script populateCategory.php, if neccessary with the --force option.

[edit] Previous Versions

MediaWiki version: 1.13

DESCRIBE category

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  
Personal tools