-- Used for caching expensive grouped queries
CREATE TABLE /*$wgDBprefix*/querycache (
- qc_type char(32) NOT NULL,
- qc_value int(5) unsigned NOT NULL default '0',
- qc_namespace tinyint(2) unsigned NOT NULL default '0',
- qc_title char(255) binary NOT NULL default '',
+ -- A key name, generally the base name of of the special page.
+ qc_type varbinary(32) NOT NULL,
+
+ -- Some sort of stored value. Sizes, counts...
+ qc_value int unsigned NOT NULL default '0',
+
+ -- Target namespace+title
+ qc_namespace int NOT NULL default '0',
+ qc_title varchar(255) binary NOT NULL default '',
+
KEY (qc_type,qc_value)
-);
+
+) /*$wgDBTableOptions*/;