Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql
===================================================================
diff -u -r6330fd59a06591611896d5204fd58953f7d36219 -re3878ab18d10633a1f8ccff9a061f0c2f65d9137
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql	(.../patch02040006.sql)	(revision 6330fd59a06591611896d5204fd58953f7d36219)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql	(.../patch02040006.sql)	(revision e3878ab18d10633a1f8ccff9a061f0c2f65d9137)
@@ -153,12 +153,15 @@
 -- all statements below should be moved to a next patch file?
 ALTER TABLE lams_planner_nodes CHANGE COLUMN teachers_permissions permissions INTEGER, ADD COLUMN user_id BIGINT(20), ADD CONSTRAINT FK_lams_planner_node_user FOREIGN KEY (user_id) REFERENCES lams_user(user_id) ON DELETE SET NULL ON UPDATE SET NULL;
 
-
 -- LDEV-2664 Switch learner interface for learners if they use a mobile device
 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;
 
+
 COMMIT;
 SET AUTOCOMMIT = 1;
 set FOREIGN_KEY_CHECKS = 1;