Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040008.sql
===================================================================
diff -u
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040008.sql	(revision 0)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040008.sql	(revision d8cad0ad05b4177fc1b94cdfd4808b357cc2457d)
@@ -0,0 +1,15 @@
+-- Turn off autocommit, so nothing is committed if there is an error
+SET AUTOCOMMIT = 0;
+
+-- LDEV-2806 Fill Activities with missing transition data
+UPDATE lams_learning_activity AS act
+ JOIN  lams_learning_transition AS trans_to
+  ON trans_to.to_activity_id = act.activity_id
+ JOIN lams_learning_transition AS trans_from
+  ON trans_from.from_activity_id = act.activity_id
+ SET act.transition_from_id = trans_from.transition_id,
+     act.transition_to_id = trans_to.transition_id;
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
\ No newline at end of file