Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20240216.sql
===================================================================
diff -u -r84e266ca8a2c095d3a3e302242703502e2c5ccfb -r1cb902b27c120d3b00c596b40a451d003db782ea
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20240216.sql	(.../patch20240216.sql)	(revision 84e266ca8a2c095d3a3e302242703502e2c5ccfb)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20240216.sql	(.../patch20240216.sql)	(revision 1cb902b27c120d3b00c596b40a451d003db782ea)
@@ -11,10 +11,14 @@
   FOR EACH ROW
   SET new.uuid = IFNULL(new.uuid, UUID_TO_BIN(UUID()));
 
+ALTER TABLE lams_qb_question ADD INDEX UQ_uuid (uuid);
+
 -- Remove duplicate UUIDs and make sure they are unique in the future
 UPDATE lams_qb_question AS q1, lams_qb_question AS q2 SET q2.uuid = UUID_TO_BIN(UUID())
 WHERE q1.uuid = q2.uuid AND q1.uid < q2.uid;
 
+ALTER TABLE lams_qb_question DROP INDEX UQ_uuid;
+
 ALTER TABLE lams_qb_question ADD CONSTRAINT UQ_uuid UNIQUE (uuid);
 
 -- Put all sql statements above here