Fixup some SELECT * usages in sqlite schema patches

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

diff --git a/maintenance/sqlite/archives/patch-iwlinks-fix-pk.sql b/maintenance/sqlite/archives/patch-iwlinks-fix-pk.sql
index 91ce251..e973c9d 100644 (file)
--- a/maintenance/sqlite/archives/patch-iwlinks-fix-pk.sql
+++ b/maintenance/sqlite/archives/patch-iwlinks-fix-pk.sql
@@ -10,8 +10,8 @@ CREATE TABLE /*_*/iwlinks_tmp (
   PRIMARY KEY (iwl_from,iwl_prefix,iwl_title)
 ) /*$wgDBTableOptions*/;
 
-INSERT INTO /*_*/iwlinks_tmp
-       SELECT * FROM /*_*/iwlinks;
+INSERT INTO /*_*/iwlinks_tmp(iwl_from, iwl_prefix, iwl_title)
+       SELECT iwl_from, iwl_prefix, iwl_title FROM /*_*/iwlinks;
 
 DROP TABLE /*_*/iwlinks;
 
@@ -21,4 +21,4 @@ ALTER TABLE /*_*/iwlinks_tmp RENAME TO /*_*/iwlinks;
 CREATE INDEX /*i*/iwl_prefix_title_from ON /*_*/iwlinks (iwl_prefix, iwl_title, iwl_from);
 
 -- Index for ApiQueryIWLinks
-CREATE INDEX /*i*/iwl_prefix_from_title ON /*_*/iwlinks (iwl_prefix, iwl_from, iwl_title);
\ No newline at end of file
+CREATE INDEX /*i*/iwl_prefix_from_title ON /*_*/iwlinks (iwl_prefix, iwl_from, iwl_title);