Fixup some SELECT * usages in sqlite schema patches

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

diff --git a/maintenance/sqlite/archives/patch-querycache_info-fix-pk.sql b/maintenance/sqlite/archives/patch-querycache_info-fix-pk.sql
index d9483be..6960667 100644 (file)
--- a/maintenance/sqlite/archives/patch-querycache_info-fix-pk.sql
+++ b/maintenance/sqlite/archives/patch-querycache_info-fix-pk.sql
@@ -7,9 +7,9 @@ CREATE TABLE /*_*/querycache_info_tmp (
   qci_timestamp binary(14) NOT NULL default '19700101000000'
 ) /*$wgDBTableOptions*/;
 
-INSERT INTO /*_*/querycache_info_tmp
-       SELECT * FROM /*_*/querycache_info;
+INSERT INTO /*_*/querycache_info_tmp(qci_type, qci_timestamp)
+       SELECT qci_type, qci_timestamp FROM /*_*/querycache_info;
 
 DROP TABLE /*_*/querycache_info;
 
-ALTER TABLE /*_*/querycache_info_tmp RENAME TO /*_*/querycache_info;
\ No newline at end of file
+ALTER TABLE /*_*/querycache_info_tmp RENAME TO /*_*/querycache_info;