maintenance/archives/patch-querycache.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

-- Used for caching expensive grouped queries

CREATE TABLE /*$wgDBprefix*/querycache (
  -- 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*/;