maintenance/archives/patch-querycachetwo.sql

   1 -- Used for caching expensive grouped queries that need two links (for example double-redirects)
   2
   3 CREATE TABLE /*$wgDBprefix*/querycachetwo (
   4   -- A key name, generally the base name of of the special page.
   5   qcc_type varbinary(32) NOT NULL,
   6
   7   -- Some sort of stored value. Sizes, counts...
   8   qcc_value int unsigned NOT NULL default '0',
   9
  10   -- Target namespace+title
  11   qcc_namespace int NOT NULL default '0',
  12   qcc_title varchar(255) binary NOT NULL default '',
  13
  14   -- Target namespace+title2
  15   qcc_namespacetwo int NOT NULL default '0',
  16   qcc_titletwo varchar(255) binary NOT NULL default '',
  17
  18   KEY qcc_type (qcc_type,qcc_value),
  19   KEY qcc_title (qcc_type,qcc_namespace,qcc_title),
  20   KEY qcc_titletwo (qcc_type,qcc_namespacetwo,qcc_titletwo)
  21
  22 ) /*$wgDBTableOptions*/;