1 files changed, 16 insertions, 0 deletions
diff --git a/www/wiki/maintenance/archives/patch-querycache.sql b/www/wiki/maintenance/archives/patch-querycache.sql
new file mode 100644
index 00000000..8e1a5188
--- /dev/null
+++ b/www/wiki/maintenance/archives/patch-querycache.sql
@@ -0,0 +1,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*/;