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.
| 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: 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.
[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 |
