summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-category.sql
blob: 97a5690dc832df37e7fe13e0adbe1120479705a0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
CREATE TABLE /*$wgDBprefix*/category (
  cat_id int unsigned NOT NULL auto_increment,

  cat_title varchar(255) binary NOT NULL,

  cat_pages int signed NOT NULL default 0,
  cat_subcats int signed NOT NULL default 0,
  cat_files int signed NOT NULL default 0,

  cat_hidden tinyint(1) unsigned NOT NULL default 0,

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

  KEY (cat_pages)
) /*$wgDBTableOptions*/;