Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20240216.sql
===================================================================
diff -u
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20240216.sql	(revision 0)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20240216.sql	(revision 6726b401c59323726beb691db2a294eb4cd15319)
@@ -0,0 +1,19 @@
+-- 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-4746 Rewrite QB question insert trigger so it accepts existing UUID if it is provided
+DROP TRIGGER IF EXISTS before_insert_qb_question;
+
+CREATE TRIGGER before_insert_qb_question
+  BEFORE INSERT ON lams_qb_question
+  FOR EACH ROW
+  SET new.uuid = IFNULL(new.uuid, UUID_TO_BIN(UUID()));
+
+-- 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