Merge "Move around "ا" to after "آ" and not before"

[lhc/web/wiklou.git] / maintenance / archives / patch-querycache.sql

diff --git a/maintenance/archives/patch-querycache.sql b/maintenance/archives/patch-querycache.sql
index d4a1b8e..8e1a518 100644 (file)
--- a/maintenance/archives/patch-querycache.sql
+++ b/maintenance/archives/patch-querycache.sql
@@ -1,9 +1,16 @@
 -- Used for caching expensive grouped queries
 
-CREATE TABLE querycache (
-  qc_type char(32) NOT NULL,
-  qc_value int(5) unsigned NOT NULL default '0',
-  qc_namespace tinyint(2) unsigned NOT NULL default '0',
-  qc_title char(255) binary NOT NULL default '',
+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*/;