Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql,v
diff -u -r1.23 -r1.24
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql	27 Feb 2012 15:35:26 -0000	1.23
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql	31 May 2012 07:41:42 -0000	1.24
@@ -25,7 +25,7 @@
      , CONSTRAINT FK_lams_event_log_2 FOREIGN KEY (user_id)
                   REFERENCES lams_user (user_id)           
      , CONSTRAINT FK_lams_event_log_3 FOREIGN KEY (learning_design_id)
-                  REFERENCES lams_learning_design (learning_design_id)
+                  REFERENCES lams_learning_design (learning_design_id) ON DELETE CASCADE
      , CONSTRAINT FK_lams_event_log_4 FOREIGN KEY (lesson_id)
                   REFERENCES lams_lesson (lesson_id)
      , CONSTRAINT FK_lams_event_log_5 FOREIGN KEY (activity_id)