* (bug 719) Increase namespace fields from tinyint to regular int
[lhc/web/wiklou.git] / maintenance / archives / patch-querycache.sql
1 -- Used for caching expensive grouped queries
2
3 CREATE TABLE /*$wgDBprefix*/querycache (
4 -- A key name, generally the base name of of the special page.
5 qc_type char(32) NOT NULL,
6
7 -- Some sort of stored value. Sizes, counts...
8 qc_value int(5) unsigned NOT NULL default '0',
9
10 -- Target namespace+title
11 qc_namespace int NOT NULL default '0',
12 qc_title char(255) binary NOT NULL default '',
13
14 KEY (qc_type,qc_value)
15
16 ) TYPE=InnoDB;