X-Git-Url: http://git.cyclocoop.org/?a=blobdiff_plain;f=maintenance%2Fsqlite%2Farchives%2Fpatch-user_former_groups-fix-pk.sql;h=969c24b5d10459b2e6f37cde5637d4d0c8d9117b;hb=e6c7fa26e938d06fb1eb274e90f7ab22667c7cd8;hp=4f5d62253a6b869ffc5ca6f71487e7bde43a27ca;hpb=79344bab3b1490c9c607b0c91919749e2ebf2948;p=lhc%2Fweb%2Fwiklou.git

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 4f5d62253a..969c24b5d1 100644
--- 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;