Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20180201.sql
===================================================================
diff -u -rd15ad2104997c36ac5ccb243c2d3db1d42e60f33 -r86eaa0ccf8539aef510325a640e219fdd23668fd
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20180201.sql	(.../patch20180201.sql)	(revision d15ad2104997c36ac5ccb243c2d3db1d42e60f33)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20180201.sql	(.../patch20180201.sql)	(revision 86eaa0ccf8539aef510325a640e219fdd23668fd)
@@ -2,6 +2,8 @@
 set FOREIGN_KEY_CHECKS = 0;
  
 --  LDEV-4507 Make sure that duplicate groups are not created
+UPDATE lams_grouping AS gi JOIN lams_group AS g ON gi.staff_group_id = g.group_id SET g.order_id = 2;
+
 ALTER TABLE lams_group ADD UNIQUE KEY UQ_lams_group_1 (grouping_id, order_id);
  
 COMMIT;