Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20181213.sql
===================================================================
diff -u
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20181213.sql	(revision 0)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20181213.sql	(revision 9de614a8136bd627bcdcae80eff52de70e485a39)
@@ -0,0 +1,17 @@
+-- Turn off autocommit, so nothing is committed if there is an error
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS=0;
+----------------------Put all sql statements below here-------------------------
+
+-- LDEV-4705 Remove course admin role
+SET @admin_roles = (SELECT config_value FROM lams_configuration WHERE config_key = 'LDAPGroupAdminMap');
+UPDATE lams_configuration SET config_value = CONCAT(config_value, ';', @admin_roles)
+WHERE config_key = 'LDAPGroupManagerMap';
+
+DELETE FROM lams_configuration WHERE config_key = 'LDAPGroupAdminMap';
+----------------------Put all sql statements above here-------------------------
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
\ No newline at end of file