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.157 -r1.158
--- lams_common/db/sql/create_lams_11_tables.sql	6 Mar 2011 09:55:42 -0000	1.157
+++ lams_common/db/sql/create_lams_11_tables.sql	15 Jul 2011 15:40:02 -0000	1.158
@@ -902,7 +902,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)