Index: lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20150930.sql =================================================================== diff -u -r4f769a0d4e83bc53d204333b902f25f40ecdbcf4 -r99e53e5c23dec6eb2ae8ed8acc1b19ad808b9f07 --- lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20150930.sql (.../patch20150930.sql) (revision 4f769a0d4e83bc53d204333b902f25f40ecdbcf4) +++ lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20150930.sql (.../patch20150930.sql) (revision 99e53e5c23dec6eb2ae8ed8acc1b19ad808b9f07) @@ -4,7 +4,7 @@ ----------------------Put all sql statements below here------------------------- -- LDEV-3564 tool session id must be unique in tool's session table -ALTER IGNORE TABLE tl_laprev11_session ADD UNIQUE (session_id); +ALTER TABLE tl_laprev11_session ADD UNIQUE (session_id); ----------------------Put all sql statements above here------------------------- Index: lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20151217.sql =================================================================== diff -u -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed -r99e53e5c23dec6eb2ae8ed8acc1b19ad808b9f07 --- lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) +++ lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 99e53e5c23dec6eb2ae8ed8acc1b19ad808b9f07) @@ -5,21 +5,21 @@ -- LDEV-3640 Add necessary cascades -ALTER IGNORE TABLE tl_laprev11_peerreview DROP FOREIGN KEY FK_NEW_1661738138_89093BF758092FB; +ALTER TABLE tl_laprev11_peerreview DROP FOREIGN KEY FK_NEW_1661738138_89093BF758092FB; ALTER TABLE tl_laprev11_peerreview ADD CONSTRAINT FK_NEW_1661738138_89093BF758092FB FOREIGN KEY (`create_by`) REFERENCES `tl_laprev11_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laprev11_session DROP FOREIGN KEY FK_NEW_1661738138_24AA78C530E79035; +ALTER TABLE tl_laprev11_session DROP FOREIGN KEY FK_NEW_1661738138_24AA78C530E79035; ALTER TABLE tl_laprev11_session ADD CONSTRAINT FK_NEW_1661738138_24AA78C530E79035 FOREIGN KEY (`peerreview_uid`) REFERENCES `tl_laprev11_peerreview` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laprev11_user DROP FOREIGN KEY FK_NEW_1661738138_30113BFC309ED320; +ALTER TABLE tl_laprev11_user DROP FOREIGN KEY FK_NEW_1661738138_30113BFC309ED320; ALTER TABLE tl_laprev11_user ADD CONSTRAINT FK_NEW_1661738138_30113BFC309ED320 FOREIGN KEY (`peerreview_uid`) REFERENCES `tl_laprev11_peerreview` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laprev11_user DROP FOREIGN KEY FK_NEW_1661738138_30113BFCEC0D3147; +ALTER TABLE tl_laprev11_user DROP FOREIGN KEY FK_NEW_1661738138_30113BFCEC0D3147; ALTER TABLE tl_laprev11_user ADD CONSTRAINT FK_NEW_1661738138_30113BFCEC0D3147 FOREIGN KEY (`session_uid`) REFERENCES `tl_laprev11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE;