Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20240315.sql =================================================================== diff -u -rdb5bb77b5d15931da025332510f19535146c4333 -r151efc677cc72f2c4c947ec0b18108a9ab6f41b6 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20240315.sql (.../patch20240315.sql) (revision db5bb77b5d15931da025332510f19535146c4333) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20240315.sql (.../patch20240315.sql) (revision 151efc677cc72f2c4c947ec0b18108a9ab6f41b6) @@ -6,8 +6,8 @@ -- LDEV-5452 Allow removing questions in live lesson ALTER TABLE lams_learner_interaction_event DROP FOREIGN KEY lams_learner_interaction_event_FK2; -ALTER TABLE lams_learner_interaction_event ADD CONSTRAINT `lams_learner_interaction_event_FK` FOREIGN KEY (`qb_tool_question_uid`) REFERENCES `lams_qb_tool_question` (`tool -_question_uid`) ON DELETE CASCADE ON UPDATE CASCADE; +ALTER TABLE lams_learner_interaction_event ADD CONSTRAINT `lams_learner_interaction_event_FK` FOREIGN KEY (`qb_tool_question_uid`) + REFERENCES `lams_qb_tool_question` (`tool_question_uid`) ON DELETE CASCADE ON UPDATE CASCADE; -- Put all sql statements above here