Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030500.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/Attic/patch02030500.sql,v
diff -u -r1.1.2.2 -r1.1.2.3
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030500.sql	25 May 2010 20:24:01 -0000	1.1.2.2
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030500.sql	15 Jun 2010 21:29:34 -0000	1.1.2.3
@@ -84,13 +84,22 @@
      , log_event_type_id INT(5) NOT NULL
      , user_id BIGINT(20) NOT NULL
      , occurred_date_time DATETIME NOT NULL
+     , learning_design_id BIGINT(20)
+     , lesson_id BIGINT(20)
+     , activity_id BIGINT(20)
      , PRIMARY KEY (id)
      , INDEX (occurred_date_time)
      , CONSTRAINT FK_lams_event_log_1 FOREIGN KEY (log_event_type_id)
                   REFERENCES lams_log_event_type (log_event_type_id)
 	 , INDEX (user_id)                  
      , CONSTRAINT FK_lams_event_log_2 FOREIGN KEY (user_id)
-                  REFERENCES lams_user (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)
+     , 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)
+                  REFERENCES lams_learning_activity (activity_id)
 )TYPE=InnoDB;
 
 DELETE FROM lams_log_event_type;