Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040000.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040000.sql,v diff -u -r1.4 -r1.5 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040000.sql 26 Aug 2009 01:37:43 -0000 1.4 +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040000.sql 25 Feb 2010 23:30:01 -0000 1.5 @@ -39,18 +39,5 @@ , PRIMARY KEY (data_flow_object_id) )TYPE=InnoDB; --- LDEV-2380 Add recently modified learning design list to Pedagogical Planner -CREATE TABLE lams_planner_recent_learning_designs ( - user_id BIGINT(20) NOT NULL - , learning_design_id BIGINT(20) NOT NULL - , last_modified_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP - , CONSTRAINT FK_lams_planner_recent_learning_designs_1 FOREIGN KEY (user_id) - REFERENCES lams_user (user_id) ON DELETE CASCADE ON UPDATE CASCADE - , CONSTRAINT FK_lams_planner_recent_learning_designs_2 FOREIGN KEY (learning_design_id) - REFERENCES lams_learning_design (learning_design_id) ON DELETE CASCADE ON UPDATE CASCADE - , PRIMARY KEY (user_id,learning_design_id) -)TYPE=InnoDB; - - COMMIT; -SET AUTOCOMMIT = 1; \ No newline at end of file +SET AUTOCOMMIT = 1;