Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/db/sql/create_lams_11_tables.sql,v
diff -u -r1.138.2.6.2.9 -r1.138.2.6.2.10
--- lams_common/db/sql/create_lams_11_tables.sql	1 Oct 2010 17:02:35 -0000	1.138.2.6.2.9
+++ lams_common/db/sql/create_lams_11_tables.sql	15 Jul 2011 15:39:26 -0000	1.138.2.6.2.10
@@ -886,7 +886,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)