[Summary view] [Print] [Text view]

   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*/;