Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20180218.sql =================================================================== diff -u -r60bb00f4c9a5e7d210df42c766cfc31b6b99f2bb -r653cff8d28f2026dd9db358929a3023b3a029147 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20180218.sql (.../patch20180218.sql) (revision 60bb00f4c9a5e7d210df42c766cfc31b6b99f2bb) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20180218.sql (.../patch20180218.sql) (revision 653cff8d28f2026dd9db358929a3023b3a029147) @@ -9,11 +9,11 @@ ALTER TABLE lams_learning_activity DROP FOREIGN KEY FK_lams_learning_activity_15; ALTER TABLE lams_learning_activity ADD CONSTRAINT FK_lams_learning_activity_15 FOREIGN KEY (transition_to_id) -REFERENCES lams_learning_transition (transition_id) ON DELETE SET NULL ON UPDATE SET NULL; +REFERENCES lams_learning_transition (transition_id) ON DELETE SET NULL ON UPDATE CASCADE; ALTER TABLE lams_learning_activity DROP FOREIGN KEY FK_lams_learning_activity_16; ALTER TABLE lams_learning_activity ADD CONSTRAINT FK_lams_learning_activity_16 FOREIGN KEY (transition_from_id) -REFERENCES lams_learning_transition (transition_id) ON DELETE SET NULL ON UPDATE SET NULL; +REFERENCES lams_learning_transition (transition_id) ON DELETE SET NULL ON UPDATE CASCADE; ALTER TABLE lams_learning_transition DROP FOREIGN KEY lddefn_transition_ibfk_1; ALTER TABLE lams_learning_transition ADD CONSTRAINT lddefn_transition_ibfk_1 FOREIGN KEY (learning_design_id)