summaryrefslogtreecommitdiff
path: root/www/wiki/maintenance/sqlite/archives/patch-querycache_info-fix-pk.sql
diff options
context:
space:
mode:
Diffstat (limited to 'www/wiki/maintenance/sqlite/archives/patch-querycache_info-fix-pk.sql')
-rw-r--r--www/wiki/maintenance/sqlite/archives/patch-querycache_info-fix-pk.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/www/wiki/maintenance/sqlite/archives/patch-querycache_info-fix-pk.sql b/www/wiki/maintenance/sqlite/archives/patch-querycache_info-fix-pk.sql
new file mode 100644
index 00000000..d9483be4
--- /dev/null
+++ b/www/wiki/maintenance/sqlite/archives/patch-querycache_info-fix-pk.sql
@@ -0,0 +1,15 @@
+CREATE TABLE /*_*/querycache_info_tmp (
+ -- Special page name
+ -- Corresponds to a qc_type value
+ qci_type varbinary(32) NOT NULL default '' PRIMARY KEY,
+
+ -- Timestamp of last update
+ qci_timestamp binary(14) NOT NULL default '19700101000000'
+) /*$wgDBTableOptions*/;
+
+INSERT INTO /*_*/querycache_info_tmp
+ SELECT * FROM /*_*/querycache_info;
+
+DROP TABLE /*_*/querycache_info;
+
+ALTER TABLE /*_*/querycache_info_tmp RENAME TO /*_*/querycache_info; \ No newline at end of file