User:VasilievVV/patch-categories.sql

CREATE TABLE /*$wgDBprefix*/categories (
  cat_id int unsigned NOT NULL auto_increment,
  cat_title varchar(255) binary NOT NULL default '',
  cat_size int unsigned NOT NULL, --Without subcategories
  cat_subcategories int unsigned NOT NULL, --number of them
  cat_page int unsigned NOT NULL, --page id or 0

  PRIMARY KEY cat_id (cat_id),
  UNIQUE INDEX cat_title (cat_title),
  INDEX (cat_page)

) /*$wgDBTableOptions*/;