Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20181204.sql
===================================================================
diff -u -r59f6c7270b755f83ed580baaa41ef3ad33d1a92f -rdb33a5e27372fe932ade8b847c6d353f349c39d6
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20181204.sql	(.../patch20181204.sql)	(revision 59f6c7270b755f83ed580baaa41ef3ad33d1a92f)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20181204.sql	(.../patch20181204.sql)	(revision db33a5e27372fe932ade8b847c6d353f349c39d6)
@@ -7,6 +7,20 @@
 DROP TABLE lams_role_privilege;
 DROP TABLE lams_privilege;
 
+-- add group manager role to user who has got only group admin and not group manager yet
+INSERT INTO lams_user_organisation_role
+	SELECT NULL, user_organisation_id, 2
+	FROM lams_user_organisation_role AS a 
+	WHERE role_id = 6 
+	AND NOT EXISTS
+		(SELECT 1 FROM lams_user_organisation_role WHERE a.user_organisation_id = user_organisation_id AND role_id = 2);
+
+-- delete role assigments for group admin
+DELETE FROM lams_user_organisation_role WHERE role_id = 6;
+
+-- delete role itself
+DELETE FROM lams_role WHERE role_id = 6;
+
 ----------------------Put all sql statements above here-------------------------
 
 -- If there were no errors, commit and restore autocommit to on