Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20181204.sql
===================================================================
diff -u
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20181204.sql	(revision 0)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20181204.sql	(revision 59f6c7270b755f83ed580baaa41ef3ad33d1a92f)
@@ -0,0 +1,15 @@
+-- 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
+DROP TABLE lams_role_privilege;
+DROP TABLE lams_privilege;
+
+----------------------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
Fisheye: Tag 59f6c7270b755f83ed580baaa41ef3ad33d1a92f refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/usermanagement/Privilege.java'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 59f6c7270b755f83ed580baaa41ef3ad33d1a92f refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/usermanagement/RolePrivilege.java'.
Fisheye: No comparison available.  Pass `N' to diff?