Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20150928.sql =================================================================== diff -u -r4009b3e6ac274a76b6de4bb4a664ef20ec76b330 -raea8f2cfafb5aa6839e979a9128a20727af6b65e --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20150928.sql (.../patch20150928.sql) (revision 4009b3e6ac274a76b6de4bb4a664ef20ec76b330) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20150928.sql (.../patch20150928.sql) (revision aea8f2cfafb5aa6839e979a9128a20727af6b65e) @@ -4,7 +4,7 @@ ----------------------Put all sql statements below here------------------------- -- LDEV-3564 session_id must be unique -ALTER IGNORE TABLE tl_laasse10_session ADD UNIQUE (session_id); +ALTER TABLE tl_laasse10_session ADD UNIQUE (session_id); ----------------------Put all sql statements above here------------------------- Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20151217.sql =================================================================== diff -u -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed -raea8f2cfafb5aa6839e979a9128a20727af6b65e --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision aea8f2cfafb5aa6839e979a9128a20727af6b65e) @@ -5,81 +5,81 @@ -- LDEV-3640 Add necessary cascades -ALTER IGNORE TABLE tl_laasse10_assessment_overall_feedback DROP FOREIGN KEY FK_tl_laasse10_assessment_overall_feedback_1; +ALTER TABLE tl_laasse10_assessment_overall_feedback DROP FOREIGN KEY FK_tl_laasse10_assessment_overall_feedback_1; ALTER TABLE tl_laasse10_assessment_overall_feedback ADD CONSTRAINT FK_tl_laasse10_assessment_overall_feedback_1 FOREIGN KEY (`assessment_uid`) REFERENCES `tl_laasse10_assessment` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laasse10_assessment_question DROP FOREIGN KEY FK_NEW_1720029621_F52D1F9330E79035; +ALTER TABLE tl_laasse10_assessment_question DROP FOREIGN KEY FK_NEW_1720029621_F52D1F9330E79035; ALTER TABLE tl_laasse10_assessment_question ADD CONSTRAINT FK_NEW_1720029621_F52D1F9330E79035 FOREIGN KEY (`assessment_uid`) REFERENCES `tl_laasse10_assessment` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laasse10_assessment_question DROP FOREIGN KEY FK_NEW_1720029621_F52D1F93758092FB; +ALTER TABLE tl_laasse10_assessment_question DROP FOREIGN KEY FK_NEW_1720029621_F52D1F93758092FB; ALTER TABLE tl_laasse10_assessment_question ADD CONSTRAINT FK_NEW_1720029621_F52D1F93758092FB FOREIGN KEY (`create_by`) REFERENCES `tl_laasse10_user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laasse10_assessment_question DROP FOREIGN KEY FK_NEW_1720029621_F52D1F93EC0D3147; +ALTER TABLE tl_laasse10_assessment_question DROP FOREIGN KEY FK_NEW_1720029621_F52D1F93EC0D3147; ALTER TABLE tl_laasse10_assessment_question ADD CONSTRAINT FK_NEW_1720029621_F52D1F93EC0D3147 FOREIGN KEY (`session_uid`) REFERENCES `tl_laasse10_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laasse10_assessment_result DROP FOREIGN KEY FK_tl_laasse10_assessment_result_2; +ALTER TABLE tl_laasse10_assessment_result DROP FOREIGN KEY FK_tl_laasse10_assessment_result_2; ALTER TABLE tl_laasse10_assessment_result ADD CONSTRAINT FK_tl_laasse10_assessment_result_2 FOREIGN KEY (`user_uid`) REFERENCES `tl_laasse10_user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laasse10_assessment_result DROP FOREIGN KEY FK_tl_laasse10_assessment_result_3; +ALTER TABLE tl_laasse10_assessment_result DROP FOREIGN KEY FK_tl_laasse10_assessment_result_3; ALTER TABLE tl_laasse10_assessment_result ADD CONSTRAINT FK_tl_laasse10_assessment_result_3 FOREIGN KEY (`assessment_uid`) REFERENCES `tl_laasse10_assessment` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laasse10_assessment_unit DROP FOREIGN KEY FK_tl_laasse10_assessment_unit_1; +ALTER TABLE tl_laasse10_assessment_unit DROP FOREIGN KEY FK_tl_laasse10_assessment_unit_1; ALTER TABLE tl_laasse10_assessment_unit ADD CONSTRAINT FK_tl_laasse10_assessment_unit_1 FOREIGN KEY (`question_uid`) REFERENCES `tl_laasse10_assessment_question` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laasse10_question_option DROP FOREIGN KEY FK_tl_laasse10_question_option_1; +ALTER TABLE tl_laasse10_question_option DROP FOREIGN KEY FK_tl_laasse10_question_option_1; ALTER TABLE tl_laasse10_question_option ADD CONSTRAINT FK_tl_laasse10_question_option_1 FOREIGN KEY (`question_uid`) REFERENCES `tl_laasse10_assessment_question` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laasse10_question_result DROP FOREIGN KEY FK_tl_laasse10_question_result_1; +ALTER TABLE tl_laasse10_question_result DROP FOREIGN KEY FK_tl_laasse10_question_result_1; ALTER TABLE tl_laasse10_question_result ADD CONSTRAINT FK_tl_laasse10_question_result_1 FOREIGN KEY (`result_uid`) REFERENCES `tl_laasse10_assessment_result` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laasse10_question_result DROP FOREIGN KEY FK_NEW_1720029621_693580A438BF8DFE; +ALTER TABLE tl_laasse10_question_result DROP FOREIGN KEY FK_NEW_1720029621_693580A438BF8DFE; ALTER TABLE tl_laasse10_question_result ADD CONSTRAINT FK_NEW_1720029621_693580A438BF8DFE FOREIGN KEY (`assessment_question_uid`) REFERENCES `tl_laasse10_assessment_question` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laasse10_option_answer DROP FOREIGN KEY FK_tl_laasse10_option_answer_1; +ALTER TABLE tl_laasse10_option_answer DROP FOREIGN KEY FK_tl_laasse10_option_answer_1; ALTER TABLE tl_laasse10_option_answer ADD CONSTRAINT FK_tl_laasse10_option_answer_1 FOREIGN KEY (`question_result_uid`) REFERENCES `tl_laasse10_question_result` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laasse10_question_reference DROP FOREIGN KEY FK_tl_laasse10_question_reference_1; +ALTER TABLE tl_laasse10_question_reference DROP FOREIGN KEY FK_tl_laasse10_question_reference_1; ALTER TABLE tl_laasse10_question_reference ADD CONSTRAINT FK_tl_laasse10_question_reference_1 FOREIGN KEY (`question_uid`) REFERENCES `tl_laasse10_assessment_question` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laasse10_question_reference DROP FOREIGN KEY FK_tl_laasse10_question_reference_2; +ALTER TABLE tl_laasse10_question_reference DROP FOREIGN KEY FK_tl_laasse10_question_reference_2; ALTER TABLE tl_laasse10_question_reference ADD CONSTRAINT FK_tl_laasse10_question_reference_2 FOREIGN KEY (`assessment_uid`) REFERENCES `tl_laasse10_assessment` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laasse10_user DROP FOREIGN KEY FK_NEW_1720029621_30113BFC309ED320; +ALTER TABLE tl_laasse10_user DROP FOREIGN KEY FK_NEW_1720029621_30113BFC309ED320; ALTER TABLE tl_laasse10_user ADD CONSTRAINT FK_NEW_1720029621_30113BFC309ED320 FOREIGN KEY (`assessment_uid`) REFERENCES `tl_laasse10_assessment` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laasse10_user DROP FOREIGN KEY FK_NEW_1720029621_30113BFCEC0D3147; +ALTER TABLE tl_laasse10_user DROP FOREIGN KEY FK_NEW_1720029621_30113BFCEC0D3147; ALTER TABLE tl_laasse10_user ADD CONSTRAINT FK_NEW_1720029621_30113BFCEC0D3147 FOREIGN KEY (`session_uid`) REFERENCES `tl_laasse10_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laasse10_session DROP FOREIGN KEY FK_NEW_1720029621_24AA78C530E79035; +ALTER TABLE tl_laasse10_session DROP FOREIGN KEY FK_NEW_1720029621_24AA78C530E79035; ALTER TABLE tl_laasse10_session ADD CONSTRAINT FK_NEW_1720029621_24AA78C530E79035 FOREIGN KEY (`assessment_uid`) REFERENCES `tl_laasse10_assessment` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_laasse10_assessment DROP FOREIGN KEY FK_NEW_1720029621_89093BF758092FB; +ALTER TABLE tl_laasse10_assessment DROP FOREIGN KEY FK_NEW_1720029621_89093BF758092FB; ALTER TABLE tl_laasse10_assessment ADD CONSTRAINT FK_NEW_1720029621_89093BF758092FB FOREIGN KEY (`create_by`) REFERENCES `tl_laasse10_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; Index: lams_tool_bbb/src/java/org/lamsfoundation/lams/tool/bbb/dbupdates/patch20150930.sql =================================================================== diff -u -r4f769a0d4e83bc53d204333b902f25f40ecdbcf4 -raea8f2cfafb5aa6839e979a9128a20727af6b65e --- lams_tool_bbb/src/java/org/lamsfoundation/lams/tool/bbb/dbupdates/patch20150930.sql (.../patch20150930.sql) (revision 4f769a0d4e83bc53d204333b902f25f40ecdbcf4) +++ lams_tool_bbb/src/java/org/lamsfoundation/lams/tool/bbb/dbupdates/patch20150930.sql (.../patch20150930.sql) (revision aea8f2cfafb5aa6839e979a9128a20727af6b65e) @@ -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_labbb10_session ADD UNIQUE (session_id); +ALTER TABLE tl_labbb10_session ADD UNIQUE (session_id); ----------------------Put all sql statements above here------------------------- Index: lams_tool_bbb/src/java/org/lamsfoundation/lams/tool/bbb/dbupdates/patch20151217.sql =================================================================== diff -u -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed -raea8f2cfafb5aa6839e979a9128a20727af6b65e --- lams_tool_bbb/src/java/org/lamsfoundation/lams/tool/bbb/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) +++ lams_tool_bbb/src/java/org/lamsfoundation/lams/tool/bbb/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision aea8f2cfafb5aa6839e979a9128a20727af6b65e) @@ -5,12 +5,12 @@ -- LDEV-3640 Add necessary cascades -ALTER IGNORE TABLE tl_labbb10_session DROP FOREIGN KEY fk_labbb10_bbb_session_to_bbb; +ALTER TABLE tl_labbb10_session DROP FOREIGN KEY fk_labbb10_bbb_session_to_bbb; ALTER TABLE tl_labbb10_session ADD CONSTRAINT fk_labbb10_bbb_session_to_bbb FOREIGN KEY (`bbb_uid`) REFERENCES `tl_labbb10_bbb` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_labbb10_user DROP FOREIGN KEY fk_labbb10_bbb_user_to_bbb_session; +ALTER TABLE tl_labbb10_user DROP FOREIGN KEY fk_labbb10_bbb_user_to_bbb_session; ALTER TABLE tl_labbb10_user ADD CONSTRAINT fk_labbb10_bbb_user_to_bbb_session FOREIGN KEY (`bbb_session_uid`) REFERENCES `tl_labbb10_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20150930.sql =================================================================== diff -u -r4f769a0d4e83bc53d204333b902f25f40ecdbcf4 -raea8f2cfafb5aa6839e979a9128a20727af6b65e --- lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20150930.sql (.../patch20150930.sql) (revision 4f769a0d4e83bc53d204333b902f25f40ecdbcf4) +++ lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20150930.sql (.../patch20150930.sql) (revision aea8f2cfafb5aa6839e979a9128a20727af6b65e) @@ -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_lachat11_session ADD UNIQUE (session_id); +ALTER TABLE tl_lachat11_session ADD UNIQUE (session_id); ----------------------Put all sql statements above here------------------------- Index: lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20151217.sql =================================================================== diff -u -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed -raea8f2cfafb5aa6839e979a9128a20727af6b65e --- lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) +++ lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision aea8f2cfafb5aa6839e979a9128a20727af6b65e) @@ -5,25 +5,25 @@ -- LDEV-3640 Add necessary cascades -ALTER IGNORE TABLE tl_lachat11_message DROP FOREIGN KEY FKCC08C1DC2AF61E05; +ALTER TABLE tl_lachat11_message DROP FOREIGN KEY FKCC08C1DC2AF61E05; ALTER TABLE tl_lachat11_message ADD CONSTRAINT FKCC08C1DC2AF61E05 FOREIGN KEY (`to_user_uid`) REFERENCES `tl_lachat11_user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_lachat11_message DROP FOREIGN KEY FKCC08C1DC9C8469FC; +ALTER TABLE tl_lachat11_message DROP FOREIGN KEY FKCC08C1DC9C8469FC; ALTER TABLE tl_lachat11_message ADD CONSTRAINT FKCC08C1DC9C8469FC FOREIGN KEY (`chat_session_uid`) REFERENCES `tl_lachat11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_lachat11_message DROP FOREIGN KEY FKCC08C1DCCF3BF9B6; +ALTER TABLE tl_lachat11_message DROP FOREIGN KEY FKCC08C1DCCF3BF9B6; ALTER TABLE tl_lachat11_message ADD CONSTRAINT FKCC08C1DCCF3BF9B6 FOREIGN KEY (`from_user_uid`) REFERENCES `tl_lachat11_user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_lachat11_session DROP FOREIGN KEY FK96E446B1A3926E3; +ALTER TABLE tl_lachat11_session DROP FOREIGN KEY FK96E446B1A3926E3; ALTER TABLE tl_lachat11_session ADD CONSTRAINT FK96E446B1A3926E3 FOREIGN KEY (`chat_uid`) REFERENCES `tl_lachat11_chat` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_lachat11_user DROP FOREIGN KEY FK4EB82169C8469FC; +ALTER TABLE tl_lachat11_user DROP FOREIGN KEY FK4EB82169C8469FC; ALTER TABLE tl_lachat11_user ADD CONSTRAINT FK4EB82169C8469FC FOREIGN KEY (`chat_session_uid`) REFERENCES `tl_lachat11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20151217.sql =================================================================== diff -u -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed -raea8f2cfafb5aa6839e979a9128a20727af6b65e --- lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) +++ lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision aea8f2cfafb5aa6839e979a9128a20727af6b65e) @@ -5,44 +5,44 @@ -- LDEV-3640 Add necessary cascades -ALTER IGNORE TABLE tl_ladaco10_answer_options DROP FOREIGN KEY tl_ladaco10_answer_options_ibfk_1; +ALTER TABLE tl_ladaco10_answer_options DROP FOREIGN KEY tl_ladaco10_answer_options_ibfk_1; ALTER TABLE tl_ladaco10_answer_options ADD CONSTRAINT tl_ladaco10_answer_options_ibfk_1 FOREIGN KEY (`question_uid`) REFERENCES `tl_ladaco10_questions` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_ladaco10_contents DROP FOREIGN KEY DacoToUser; +ALTER TABLE tl_ladaco10_contents DROP FOREIGN KEY DacoToUser; ALTER TABLE tl_ladaco10_contents ADD CONSTRAINT DacoToUser FOREIGN KEY (`create_by`) REFERENCES `tl_ladaco10_users` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_ladaco10_questions DROP FOREIGN KEY QuestionToDaco; +ALTER TABLE tl_ladaco10_questions DROP FOREIGN KEY QuestionToDaco; ALTER TABLE tl_ladaco10_questions ADD CONSTRAINT QuestionToDaco FOREIGN KEY (`content_uid`) REFERENCES `tl_ladaco10_contents` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_ladaco10_questions DROP FOREIGN KEY QuestionToUser; +ALTER TABLE tl_ladaco10_questions DROP FOREIGN KEY QuestionToUser; ALTER TABLE tl_ladaco10_questions ADD CONSTRAINT QuestionToUser FOREIGN KEY (`create_by`) REFERENCES `tl_ladaco10_users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_ladaco10_questions DROP FOREIGN KEY tl_ladaco10_questions_ibfk_1; +ALTER TABLE tl_ladaco10_questions DROP FOREIGN KEY tl_ladaco10_questions_ibfk_1; ALTER TABLE tl_ladaco10_questions ADD CONSTRAINT tl_ladaco10_questions_ibfk_1 FOREIGN KEY (`session_uid`) REFERENCES `tl_ladaco10_sessions` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_ladaco10_sessions DROP FOREIGN KEY SessionToDaco; +ALTER TABLE tl_ladaco10_sessions DROP FOREIGN KEY SessionToDaco; ALTER TABLE tl_ladaco10_sessions ADD CONSTRAINT SessionToDaco FOREIGN KEY (`content_uid`) REFERENCES `tl_ladaco10_contents` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_ladaco10_users DROP FOREIGN KEY UserToSession; +ALTER TABLE tl_ladaco10_users DROP FOREIGN KEY UserToSession; ALTER TABLE tl_ladaco10_users ADD CONSTRAINT UserToSession FOREIGN KEY (`session_uid`) REFERENCES `tl_ladaco10_sessions` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_ladaco10_answers DROP FOREIGN KEY AnswerToUser; +ALTER TABLE tl_ladaco10_answers DROP FOREIGN KEY AnswerToUser; ALTER TABLE tl_ladaco10_answers ADD CONSTRAINT AnswerToUser FOREIGN KEY (`user_uid`) REFERENCES `tl_ladaco10_users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER IGNORE TABLE tl_ladaco10_answers DROP FOREIGN KEY AnswerToQuestion; +ALTER TABLE tl_ladaco10_answers DROP FOREIGN KEY AnswerToQuestion; ALTER TABLE tl_ladaco10_answers ADD CONSTRAINT AnswerToQuestion FOREIGN KEY (`question_uid`) REFERENCES `tl_ladaco10_questions` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE;