Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040081.sql
===================================================================
diff -u
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040081.sql	(revision 0)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040081.sql	(revision d774a6eadae0d2f9b8088e0e531b31b2a946fc9b)
@@ -0,0 +1,8 @@
+-- Turn off autocommit, so nothing is committed if there is an error
+SET AUTOCOMMIT = 0;
+
+-- LDEV-4097 Change lams_ext_user_userid_map's tc_gradebook_id to text
+ALTER TABLE lams_ext_user_userid_map CHANGE COLUMN tc_gradebook_id tc_gradebook_id TEXT;
+
+COMMIT;
+SET AUTOCOMMIT = 1;