1 -- Used for caching expensive grouped queries that need two links (for example double-redirects)
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,
7 -- Some sort of stored value. Sizes, counts...
8 qcc_value
int unsigned
NOT NULL default '0',
10 -- Target namespace+title
11 qcc_namespace
int NOT NULL default '0',
12 qcc_title
varchar(255) binary NOT NULL default '',
14 -- Target namespace+title2
15 qcc_namespacetwo
int NOT NULL default '0',
16 qcc_titletwo
varchar(255) binary NOT NULL default '',
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
)
22 ) /*$wgDBTableOptions*/;