Index: lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20151217.sql =================================================================== diff -u -r1cc2a9ceba256eb4abb0cbdb42c28085c9fc7d42 -r56c726e417b125e5c5c6ab27cb1bb58140bcfadd --- lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cc2a9ceba256eb4abb0cbdb42c28085c9fc7d42) +++ lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 56c726e417b125e5c5c6ab27cb1bb58140bcfadd) @@ -32,6 +32,10 @@ ALTER TABLE tl_lascrt11_user ADD CONSTRAINT FK_NEW_610529188_30113BFCEC0D3147 FOREIGN KEY (`session_uid`) REFERENCES `tl_lascrt11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; +ALTER TABLE tl_lascrt11_user DROP FOREIGN KEY FK_NEW_610529188_30113BFC309ED320; +ALTER TABLE tl_lascrt11_user ADD CONSTRAINT FK_NEW_610529188_30113BFC309ED320 FOREIGN KEY (`scratchie_uid`) +REFERENCES `tl_lascrt11_scratchie` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; + ALTER TABLE tl_lascrt11_answer_log DROP FOREIGN KEY sessionIdIndex; ALTER TABLE tl_lascrt11_answer_log ADD CONSTRAINT sessionIdIndex FOREIGN KEY (`session_id`)