Index: lams_common/db/sql/create_lams_11_tables.sql
===================================================================
diff -u -re2e2aa63f31be07287637a2bec159d1574c0ba2c -r413a7a7d4d5415d45c4ec4ad549e5f15cfee3d44
--- lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision e2e2aa63f31be07287637a2bec159d1574c0ba2c)
+++ lams_common/db/sql/create_lams_11_tables.sql	(.../create_lams_11_tables.sql)	(revision 413a7a7d4d5415d45c4ec4ad549e5f15cfee3d44)
@@ -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)