diff options
Diffstat (limited to 'www/wiki/maintenance/sqlite/archives/patch-objectcache-fix-pk.sql')
-rw-r--r-- | www/wiki/maintenance/sqlite/archives/patch-objectcache-fix-pk.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/www/wiki/maintenance/sqlite/archives/patch-objectcache-fix-pk.sql b/www/wiki/maintenance/sqlite/archives/patch-objectcache-fix-pk.sql new file mode 100644 index 00000000..f2bef583 --- /dev/null +++ b/www/wiki/maintenance/sqlite/archives/patch-objectcache-fix-pk.sql @@ -0,0 +1,14 @@ +CREATE TABLE /*_*/objectcache_tmp ( + keyname varbinary(255) NOT NULL default '' PRIMARY KEY, + value mediumblob, + exptime datetime +) /*$wgDBTableOptions*/; + +INSERT INTO /*_*/objectcache_tmp + SELECT * FROM /*_*/objectcache; + +DROP TABLE /*_*/objectcache; + +ALTER TABLE /*_*/objectcache_tmp RENAME TO /*_*/objectcache; + +CREATE INDEX /*i*/exptime ON /*_*/objectcache (exptime);
\ No newline at end of file |