Fixup some SELECT * usages in sqlite schema patches

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

diff --git a/maintenance/sqlite/archives/patch-log_search-fix-pk.sql b/maintenance/sqlite/archives/patch-log_search-fix-pk.sql
index 153e415..7c55993 100644 (file)
--- a/maintenance/sqlite/archives/patch-log_search-fix-pk.sql
+++ b/maintenance/sqlite/archives/patch-log_search-fix-pk.sql
@@ -8,11 +8,11 @@ CREATE TABLE /*_*/log_search_tmp (
   PRIMARY KEY (ls_field,ls_value,ls_log_id)
 ) /*$wgDBTableOptions*/;
 
-INSERT INTO /*_*/log_search_tmp
-       SELECT * FROM /*_*/log_search;
+INSERT INTO /*_*/log_search_tmp(ls_field, ls_value, ls_log_id)
+       SELECT ls_field, ls_value, ls_log_id FROM /*_*/log_search;
 
 DROP TABLE /*_*/log_search;
 
 ALTER TABLE /*_*/log_search_tmp RENAME TO /*_*/log_search;
 
-CREATE INDEX /*i*/ls_log_id ON /*_*/log_search (ls_log_id);
\ No newline at end of file
+CREATE INDEX /*i*/ls_log_id ON /*_*/log_search (ls_log_id);