Manual:Category table/cs

Tabulka category sleduje všechny existující kategorie. Něco je kategorie, pokud
 * 1) má záznam někde v kategorii odkazů nebo
 * 2) to bylo jednou uděláno.

Kategorie nemusí mít odpovídající stránky, takže je třeba sledovat samostatně. ,  a.

cat_id
Primary key

cat_title
Name of the category, in the same form as page.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. This number includes the number of subcategories and the number of files.

cat_subcats
Number of sub-categories in the category.

cat_files
Number of files (i.e. Image: namespace members) in the category.

cat_hidden
Was reserved for future use; apparently no one found a use for it because it was removed in v1.20. Instead, the status of hidden categories is stored in the page props table as the property "hiddencat" in.

Schema summary
DESCRIBE category; +-+--+--+-+-++ +-+--+--+-+-++ +-+--+--+-+-++
 * Field      | Type             | Null | Key | Default | Extra          |
 * cat_id     | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
 * cat_title  | varbinary(255)   | NO   | UNI | NULL    |                |
 * cat_pages  | int(11)          | NO   | MUL | 0       |                |
 * cat_subcats | int(11)         | NO   |     | 0       |                |
 * cat_files  | int(11)          | NO   |     | 0       |                |

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