Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030501.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/Attic/patch02030501.sql,v diff -u -r1.1.2.4 -r1.1.2.5 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030501.sql 1 Apr 2011 18:36:31 -0000 1.1.2.4 +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02030501.sql 15 Jul 2011 11:39:20 -0000 1.1.2.5 @@ -24,6 +24,10 @@ insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) values ('ForceMobileDevToUseFlashless','false', 'config.force.mobile.use.flashlesh', 'config.header.features', 'BOOLEAN', 1); +-- LDEV-2704 Weaken foreign key's constraints due to problems with learning designs removal +ALTER TABLE lams_log_event DROP FOREIGN KEY FK_lams_event_log_3; +ALTER TABLE lams_log_event ADD CONSTRAINT FK_lams_event_log_3 FOREIGN KEY (learning_design_id) REFERENCES lams_learning_design (learning_design_id ) ON DELETE CASCADE; + -- If there were no errors, commit and restore autocommit to on COMMIT; SET AUTOCOMMIT = 1; \ No newline at end of file