Fixup some SELECT * usages in sqlite schema patches

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

diff --git a/maintenance/sqlite/archives/patch-user_former_groups-fix-pk.sql b/maintenance/sqlite/archives/patch-user_former_groups-fix-pk.sql
index 4f5d622..969c24b 100644 (file)
--- a/maintenance/sqlite/archives/patch-user_former_groups-fix-pk.sql
+++ b/maintenance/sqlite/archives/patch-user_former_groups-fix-pk.sql
@@ -5,9 +5,9 @@ CREATE TABLE /*_*/user_former_groups_tmp (
   PRIMARY KEY (ufg_user,ufg_group)
 ) /*$wgDBTableOptions*/;
 
-INSERT INTO /*_*/user_former_groups_tmp
-       SELECT * FROM /*_*/user_former_groups;
+INSERT INTO /*_*/user_former_groups_tmp(ufg_user, ufg_group)
+       SELECT ufg_user, ufg_group FROM /*_*/user_former_groups;
 
 DROP TABLE /*_*/user_former_groups;
 
-ALTER TABLE /*_*/user_former_groups_tmp RENAME TO /*_*/user_former_groups;
\ No newline at end of file
+ALTER TABLE /*_*/user_former_groups_tmp RENAME TO /*_*/user_former_groups;