Fixup some SELECT * usages in sqlite schema patches

[lhc/web/wiklou.git] / maintenance / sqlite / archives / patch-objectcache-fix-pk.sql

diff --git a/maintenance/sqlite/archives/patch-objectcache-fix-pk.sql b/maintenance/sqlite/archives/patch-objectcache-fix-pk.sql
index f2bef58..c3228a9 100644 (file)
--- a/maintenance/sqlite/archives/patch-objectcache-fix-pk.sql
+++ b/maintenance/sqlite/archives/patch-objectcache-fix-pk.sql
@@ -4,11 +4,11 @@ CREATE TABLE /*_*/objectcache_tmp (
   exptime datetime
 ) /*$wgDBTableOptions*/;
 
-INSERT INTO /*_*/objectcache_tmp
-       SELECT * FROM /*_*/objectcache;
+INSERT INTO /*_*/objectcache_tmp(keyname, "value", exptime)
+       SELECT keyname, "value", exptime 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
+CREATE INDEX /*i*/exptime ON /*_*/objectcache (exptime);