diff options
Diffstat (limited to 'maintenance/archives/patch-category.sql')
-rw-r--r-- | maintenance/archives/patch-category.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/maintenance/archives/patch-category.sql b/maintenance/archives/patch-category.sql new file mode 100644 index 00000000..416500c3 --- /dev/null +++ b/maintenance/archives/patch-category.sql @@ -0,0 +1,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*/; + |