Fixup some SELECT * usages in sqlite schema patches

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

diff --git a/maintenance/sqlite/archives/patch-categorylinks-fix-pk.sql b/maintenance/sqlite/archives/patch-categorylinks-fix-pk.sql
index 13a75a3..6bf2295 100644 (file)
--- a/maintenance/sqlite/archives/patch-categorylinks-fix-pk.sql
+++ b/maintenance/sqlite/archives/patch-categorylinks-fix-pk.sql
@@ -40,8 +40,8 @@ CREATE TABLE /*_*/categorylinks_tmp (
   PRIMARY KEY (cl_from,cl_to)
 ) /*$wgDBTableOptions*/;
 
-INSERT INTO /*_*/categorylinks_tmp
-       SELECT *
+INSERT INTO /*_*/categorylinks_tmp(cl_from, cl_to, cl_sortkey, cl_sortkey_prefix, cl_timestamp, cl_collation, cl_type)
+       SELECT cl_from, cl_to, cl_sortkey, cl_sortkey_prefix, cl_timestamp, cl_collation, cl_type
                FROM /*_*/categorylinks;
 
 DROP TABLE /*_*/categorylinks;
@@ -57,4 +57,4 @@ CREATE INDEX /*i*/cl_sortkey ON /*_*/categorylinks (cl_to,cl_type,cl_sortkey,cl_
 CREATE INDEX /*i*/cl_timestamp ON /*_*/categorylinks (cl_to,cl_timestamp);
 
 -- Used when updating collation (e.g. updateCollation.php)
-CREATE INDEX /*i*/cl_collation_ext ON /*_*/categorylinks (cl_collation, cl_to, cl_type, cl_from);
\ No newline at end of file
+CREATE INDEX /*i*/cl_collation_ext ON /*_*/categorylinks (cl_collation, cl_to, cl_type, cl_from);