1 -- cat_hidden is no longer used, delete it
3 CREATE TABLE /*_*/category_tmp (
4 cat_id
int unsigned
NOT NULL PRIMARY KEY AUTO_INCREMENT
,
5 cat_title
varchar(255) binary NOT NULL,
6 cat_pages
int signed
NOT NULL default 0,
7 cat_subcats
int signed
NOT NULL default 0,
8 cat_files
int signed
NOT NULL default 0
9 ) /*$wgDBTableOptions*/;
11 INSERT INTO /*_*/category_tmp
12 SELECT cat_id
, cat_title
, cat_pages
, cat_subcats
, cat_files
15 DROP TABLE /*_*/category
;
17 ALTER TABLE /*_*/category_tmp
RENAME TO /*_*/category
;
19 CREATE UNIQUE INDEX /*i*/cat_title
ON /*_*/category (cat_title
);
20 CREATE INDEX /*i*/cat_pages
ON /*_*/category (cat_pages
);