Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,81 +5,81 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_laasse10_assessment_overall_feedback DROP FOREIGN KEY FK_tl_laasse10_assessment_overall_feedback_1; +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 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 TABLE tl_laasse10_assessment_question DROP FOREIGN KEY FK_NEW_1720029621_F52D1F9330E79035; +ALTER IGNORE 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 TABLE tl_laasse10_assessment_question DROP FOREIGN KEY FK_NEW_1720029621_F52D1F93758092FB; +ALTER IGNORE 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 TABLE tl_laasse10_assessment_question DROP FOREIGN KEY FK_NEW_1720029621_F52D1F93EC0D3147; +ALTER IGNORE 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 TABLE tl_laasse10_assessment_result DROP FOREIGN KEY FK_tl_laasse10_assessment_result_2; +ALTER IGNORE 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 TABLE tl_laasse10_assessment_result DROP FOREIGN KEY FK_tl_laasse10_assessment_result_3; +ALTER IGNORE 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 TABLE tl_laasse10_assessment_unit DROP FOREIGN KEY FK_tl_laasse10_assessment_unit_1; +ALTER IGNORE 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 TABLE tl_laasse10_question_option DROP FOREIGN KEY FK_tl_laasse10_question_option_1; +ALTER IGNORE 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 TABLE tl_laasse10_question_result DROP FOREIGN KEY FK_tl_laasse10_question_result_1; +ALTER IGNORE 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 TABLE tl_laasse10_question_result DROP FOREIGN KEY FK_NEW_1720029621_693580A438BF8DFE; +ALTER IGNORE 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 TABLE tl_laasse10_option_answer DROP FOREIGN KEY FK_tl_laasse10_option_answer_1; +ALTER IGNORE 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 TABLE tl_laasse10_question_reference DROP FOREIGN KEY FK_tl_laasse10_question_reference_1; +ALTER IGNORE 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 TABLE tl_laasse10_question_reference DROP FOREIGN KEY FK_tl_laasse10_question_reference_2; +ALTER IGNORE 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 TABLE tl_laasse10_user DROP FOREIGN KEY FK_NEW_1720029621_30113BFC309ED320; +ALTER IGNORE 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 TABLE tl_laasse10_user DROP FOREIGN KEY FK_NEW_1720029621_30113BFCEC0D3147; +ALTER IGNORE 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 TABLE tl_laasse10_session DROP FOREIGN KEY FK_NEW_1720029621_24AA78C530E79035; +ALTER IGNORE 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 TABLE tl_laasse10_assessment DROP FOREIGN KEY FK_NEW_1720029621_89093BF758092FB; +ALTER IGNORE 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/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_bbb/src/java/org/lamsfoundation/lams/tool/bbb/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_bbb/src/java/org/lamsfoundation/lams/tool/bbb/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,12 +5,12 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_labbb10_session DROP FOREIGN KEY fk_labbb10_bbb_session_to_bbb; +ALTER IGNORE 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 TABLE tl_labbb10_user DROP FOREIGN KEY fk_labbb10_bbb_user_to_bbb_session; +ALTER IGNORE 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/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_chat/src/java/org/lamsfoundation/lams/tool/chat/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,25 +5,25 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lachat11_message DROP FOREIGN KEY FKCC08C1DC2AF61E05; +ALTER IGNORE 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 TABLE tl_lachat11_message DROP FOREIGN KEY FKCC08C1DC9C8469FC; +ALTER IGNORE 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 TABLE tl_lachat11_message DROP FOREIGN KEY FKCC08C1DCCF3BF9B6; +ALTER IGNORE 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 TABLE tl_lachat11_session DROP FOREIGN KEY FK96E446B1A3926E3; +ALTER IGNORE 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 TABLE tl_lachat11_user DROP FOREIGN KEY FK4EB82169C8469FC; +ALTER IGNORE 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 -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_daco/src/java/org/lamsfoundation/lams/tool/daco/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,44 +5,44 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_ladaco10_answer_options DROP FOREIGN KEY tl_ladaco10_answer_options_ibfk_1; +ALTER IGNORE 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 TABLE tl_ladaco10_contents DROP FOREIGN KEY DacoToUser; +ALTER IGNORE 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 TABLE tl_ladaco10_questions DROP FOREIGN KEY QuestionToDaco; +ALTER IGNORE 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 TABLE tl_ladaco10_questions DROP FOREIGN KEY QuestionToUser; +ALTER IGNORE 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 TABLE tl_ladaco10_questions DROP FOREIGN KEY tl_ladaco10_questions_ibfk_1; +ALTER IGNORE 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 TABLE tl_ladaco10_sessions DROP FOREIGN KEY SessionToDaco; +ALTER IGNORE 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 TABLE tl_ladaco10_users DROP FOREIGN KEY UserToSession; +ALTER IGNORE 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 TABLE tl_ladaco10_answers DROP FOREIGN KEY AnswerToUser; +ALTER IGNORE 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 TABLE tl_ladaco10_answers DROP FOREIGN KEY AnswerToQuestion; +ALTER IGNORE 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; Index: lams_tool_eadventure/src/java/org/eucm/lams/tool/eadventure/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_eadventure/src/java/org/eucm/lams/tool/eadventure/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_eadventure/src/java/org/eucm/lams/tool/eadventure/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -4,58 +4,58 @@ ----------------------Put all sql statements below here------------------------- -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_eueadv10_condition DROP FOREIGN KEY FK_NEW_1226715514_5656683026352999; +ALTER IGNORE TABLE tl_eueadv10_condition DROP FOREIGN KEY FK_NEW_1226715514_5656683026352999; ALTER TABLE tl_eueadv10_condition ADD CONSTRAINT FK_NEW_1226715514_5656683026352999 FOREIGN KEY (`eadventure_uid`) REFERENCES `tl_eueadv10_eadventure` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_eueadv10_condition_expression DROP FOREIGN KEY FK_NEW_1226715514_5656683026352390; +ALTER IGNORE TABLE tl_eueadv10_condition_expression DROP FOREIGN KEY FK_NEW_1226715514_5656683026352390; ALTER TABLE tl_eueadv10_condition_expression ADD CONSTRAINT FK_NEW_1226715514_5656683026352390 FOREIGN KEY (`condition_uid`) REFERENCES `tl_eueadv10_condition` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_eueadv10_condition_expression DROP FOREIGN KEY FK_NEW_1226715514_5656683026352EEE; +ALTER IGNORE TABLE tl_eueadv10_condition_expression DROP FOREIGN KEY FK_NEW_1226715514_5656683026352EEE; ALTER TABLE tl_eueadv10_condition_expression ADD CONSTRAINT FK_NEW_1226715514_5656683026352EEE FOREIGN KEY (`first_op`) REFERENCES `tl_eueadv10_param` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_eueadv10_condition_expression DROP FOREIGN KEY FK_NEW_1226715514_5656683026352FFF; +ALTER IGNORE TABLE tl_eueadv10_condition_expression DROP FOREIGN KEY FK_NEW_1226715514_5656683026352FFF; ALTER TABLE tl_eueadv10_condition_expression ADD CONSTRAINT FK_NEW_1226715514_5656683026352FFF FOREIGN KEY (`var_introduced`) REFERENCES `tl_eueadv10_param` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_eueadv10_eadventure DROP FOREIGN KEY FK_NEW_1226715514_89093BF758092FB; +ALTER IGNORE TABLE tl_eueadv10_eadventure DROP FOREIGN KEY FK_NEW_1226715514_89093BF758092FB; ALTER TABLE tl_eueadv10_eadventure ADD CONSTRAINT FK_NEW_1226715514_89093BF758092FB FOREIGN KEY (`create_by`) REFERENCES `tl_eueadv10_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_eueadv10_item_log DROP FOREIGN KEY FK_NEW_1226715514_693580A438BF8DFE; +ALTER IGNORE TABLE tl_eueadv10_item_log DROP FOREIGN KEY FK_NEW_1226715514_693580A438BF8DFE; ALTER TABLE tl_eueadv10_item_log ADD CONSTRAINT FK_NEW_1226715514_693580A438BF8DFE FOREIGN KEY (`eadventure_item_uid`) REFERENCES `tl_eueadv10_eadventure` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_eueadv10_item_log DROP FOREIGN KEY FK_NEW_1226715514_693580A441F9365D; +ALTER IGNORE TABLE tl_eueadv10_item_log DROP FOREIGN KEY FK_NEW_1226715514_693580A441F9365D; ALTER TABLE tl_eueadv10_item_log ADD CONSTRAINT FK_NEW_1226715514_693580A441F9365D FOREIGN KEY (`user_uid`) REFERENCES `tl_eueadv10_user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_eueadv10_param DROP FOREIGN KEY FK_NEW_1226715514_56566830263527E3; +ALTER IGNORE TABLE tl_eueadv10_param DROP FOREIGN KEY FK_NEW_1226715514_56566830263527E3; ALTER TABLE tl_eueadv10_param ADD CONSTRAINT FK_NEW_1226715514_56566830263527E3 FOREIGN KEY (`eadventure_uid`) REFERENCES `tl_eueadv10_eadventure` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_eueadv10_session DROP FOREIGN KEY FK_NEW_1226715514_24AA78C530E79035; +ALTER IGNORE TABLE tl_eueadv10_session DROP FOREIGN KEY FK_NEW_1226715514_24AA78C530E79035; ALTER TABLE tl_eueadv10_session ADD CONSTRAINT FK_NEW_1226715514_24AA78C530E79035 FOREIGN KEY (`eadventure_uid`) REFERENCES `tl_eueadv10_eadventure` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_eueadv10_user DROP FOREIGN KEY FK_NEW_1226715514_30113BFC309ED320; +ALTER IGNORE TABLE tl_eueadv10_user DROP FOREIGN KEY FK_NEW_1226715514_30113BFC309ED320; ALTER TABLE tl_eueadv10_user ADD CONSTRAINT FK_NEW_1226715514_30113BFC309ED320 FOREIGN KEY (`eadventure_uid`) REFERENCES `tl_eueadv10_eadventure` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_eueadv10_user DROP FOREIGN KEY FK_NEW_1226715514_30113BFCEC0D3147; +ALTER IGNORE TABLE tl_eueadv10_user DROP FOREIGN KEY FK_NEW_1226715514_30113BFCEC0D3147; ALTER TABLE tl_eueadv10_user ADD CONSTRAINT FK_NEW_1226715514_30113BFCEC0D3147 FOREIGN KEY (`session_uid`) REFERENCES `tl_eueadv10_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_eueadv10_var DROP FOREIGN KEY FK_NEW_1226715514_42637763767637E6; +ALTER IGNORE TABLE tl_eueadv10_var DROP FOREIGN KEY FK_NEW_1226715514_42637763767637E6; ALTER TABLE tl_eueadv10_var ADD CONSTRAINT FK_NEW_1226715514_42637763767637E6 FOREIGN KEY (`visit_log_uid`) REFERENCES `tl_eueadv10_item_log` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,78 +5,78 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lafrum11_attachment DROP FOREIGN KEY FK389AD9A2131CE31E; +ALTER IGNORE TABLE tl_lafrum11_attachment DROP FOREIGN KEY FK389AD9A2131CE31E; ALTER TABLE tl_lafrum11_attachment ADD CONSTRAINT FK389AD9A2131CE31E FOREIGN KEY (`forum_uid`) REFERENCES `tl_lafrum11_forum` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lafrum11_attachment DROP FOREIGN KEY FK389AD9A2FE939F2A; +ALTER IGNORE TABLE tl_lafrum11_attachment DROP FOREIGN KEY FK389AD9A2FE939F2A; ALTER TABLE tl_lafrum11_attachment ADD CONSTRAINT FK389AD9A2FE939F2A FOREIGN KEY (`message_uid`) REFERENCES `tl_lafrum11_message` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lafrum11_forum DROP FOREIGN KEY FK87917942E42F4351; +ALTER IGNORE TABLE tl_lafrum11_forum DROP FOREIGN KEY FK87917942E42F4351; ALTER TABLE tl_lafrum11_forum ADD CONSTRAINT FK87917942E42F4351 FOREIGN KEY (`create_by`) REFERENCES `tl_lafrum11_forum_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lafrum11_message_rating DROP FOREIGN KEY FK_tl_lafrum11_message_rating_1; +ALTER IGNORE TABLE tl_lafrum11_message_rating DROP FOREIGN KEY FK_tl_lafrum11_message_rating_1; ALTER TABLE tl_lafrum11_message_rating ADD CONSTRAINT FK_tl_lafrum11_message_rating_1 FOREIGN KEY (`user_id`) REFERENCES `tl_lafrum11_forum_user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lafrum11_message_rating DROP FOREIGN KEY FK_tl_lafrum11_message_rating_2; +ALTER IGNORE TABLE tl_lafrum11_message_rating DROP FOREIGN KEY FK_tl_lafrum11_message_rating_2; ALTER TABLE tl_lafrum11_message_rating ADD CONSTRAINT FK_tl_lafrum11_message_rating_2 FOREIGN KEY (`message_id`) REFERENCES `tl_lafrum11_message` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lafrum11_message_seq DROP FOREIGN KEY FKD2C71F8845213B4D; +ALTER IGNORE TABLE tl_lafrum11_message_seq DROP FOREIGN KEY FKD2C71F8845213B4D; ALTER TABLE tl_lafrum11_message_seq ADD CONSTRAINT FKD2C71F8845213B4D FOREIGN KEY (`root_message_uid`) REFERENCES `tl_lafrum11_message` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lafrum11_message_seq DROP FOREIGN KEY FKD2C71F88FE939F2A; +ALTER IGNORE TABLE tl_lafrum11_message_seq DROP FOREIGN KEY FKD2C71F88FE939F2A; ALTER TABLE tl_lafrum11_message_seq ADD CONSTRAINT FKD2C71F88FE939F2A FOREIGN KEY (`message_uid`) REFERENCES `tl_lafrum11_message` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lafrum11_message_seq DROP FOREIGN KEY fkfrum11mseqthread; +ALTER IGNORE TABLE tl_lafrum11_message_seq DROP FOREIGN KEY fkfrum11mseqthread; ALTER TABLE tl_lafrum11_message_seq ADD CONSTRAINT fkfrum11mseqthread FOREIGN KEY (`thread_message_uid`) REFERENCES `tl_lafrum11_message` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lafrum11_message DROP FOREIGN KEY FK4A6067E8647A7264; +ALTER IGNORE TABLE tl_lafrum11_message DROP FOREIGN KEY FK4A6067E8647A7264; ALTER TABLE tl_lafrum11_message ADD CONSTRAINT FK4A6067E8647A7264 FOREIGN KEY (`modified_by`) REFERENCES `tl_lafrum11_forum_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lafrum11_message DROP FOREIGN KEY FK4A6067E8E42F4351; +ALTER IGNORE TABLE tl_lafrum11_message DROP FOREIGN KEY FK4A6067E8E42F4351; ALTER TABLE tl_lafrum11_message ADD CONSTRAINT FK4A6067E8E42F4351 FOREIGN KEY (`create_by`) REFERENCES `tl_lafrum11_forum_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lafrum11_message DROP FOREIGN KEY FK4A6067E824089E4D; +ALTER IGNORE TABLE tl_lafrum11_message DROP FOREIGN KEY FK4A6067E824089E4D; ALTER TABLE tl_lafrum11_message ADD CONSTRAINT FK4A6067E824089E4D FOREIGN KEY (`parent_uid`) REFERENCES `tl_lafrum11_message` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lafrum11_message DROP FOREIGN KEY FK4A6067E8131CE31E; +ALTER IGNORE TABLE tl_lafrum11_message DROP FOREIGN KEY FK4A6067E8131CE31E; ALTER TABLE tl_lafrum11_message ADD CONSTRAINT FK4A6067E8131CE31E FOREIGN KEY (`forum_uid`) REFERENCES `tl_lafrum11_forum` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lafrum11_message DROP FOREIGN KEY FK4A6067E89357B45B; +ALTER IGNORE TABLE tl_lafrum11_message DROP FOREIGN KEY FK4A6067E89357B45B; ALTER TABLE tl_lafrum11_message ADD CONSTRAINT FK4A6067E89357B45B FOREIGN KEY (`forum_session_uid`) REFERENCES `tl_lafrum11_tool_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lafrum11_tool_session DROP FOREIGN KEY FK5A04D7AE131CE31E; +ALTER IGNORE TABLE tl_lafrum11_tool_session DROP FOREIGN KEY FK5A04D7AE131CE31E; ALTER TABLE tl_lafrum11_tool_session ADD CONSTRAINT FK5A04D7AE131CE31E FOREIGN KEY (`forum_uid`) REFERENCES `tl_lafrum11_forum` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lafrum11_timestamp DROP FOREIGN KEY ForumUserFK; +ALTER IGNORE TABLE tl_lafrum11_timestamp DROP FOREIGN KEY ForumUserFK; ALTER TABLE tl_lafrum11_timestamp ADD CONSTRAINT ForumUserFK FOREIGN KEY (`forum_user_uid`) REFERENCES `tl_lafrum11_forum_user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lafrum11_timestamp DROP FOREIGN KEY MessageFK; +ALTER IGNORE TABLE tl_lafrum11_timestamp DROP FOREIGN KEY MessageFK; ALTER TABLE tl_lafrum11_timestamp ADD CONSTRAINT MessageFK FOREIGN KEY (`message_uid`) REFERENCES `tl_lafrum11_message` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lafrum11_forum_user DROP FOREIGN KEY FK7B83A4A85F0116B6; +ALTER IGNORE TABLE tl_lafrum11_forum_user DROP FOREIGN KEY FK7B83A4A85F0116B6; ALTER TABLE tl_lafrum11_forum_user ADD CONSTRAINT FK7B83A4A85F0116B6 FOREIGN KEY (`session_id`) REFERENCES `tl_lafrum11_tool_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_gmap/src/java/org/lamsfoundation/lams/tool/gmap/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_gmap/src/java/org/lamsfoundation/lams/tool/gmap/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_gmap/src/java/org/lamsfoundation/lams/tool/gmap/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,29 +5,29 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lagmap10_marker DROP FOREIGN KEY FK10F22749529F7FD3; +ALTER IGNORE TABLE tl_lagmap10_marker DROP FOREIGN KEY FK10F22749529F7FD3; ALTER TABLE tl_lagmap10_marker ADD CONSTRAINT FK10F22749529F7FD3 FOREIGN KEY (`created_by`) REFERENCES `tl_lagmap10_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lagmap10_marker DROP FOREIGN KEY FK10F2274974028C80; +ALTER IGNORE TABLE tl_lagmap10_marker DROP FOREIGN KEY FK10F2274974028C80; ALTER TABLE tl_lagmap10_marker ADD CONSTRAINT FK10F2274974028C80 FOREIGN KEY (`gmap_uid`) REFERENCES `tl_lagmap10_gmap` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lagmap10_marker DROP FOREIGN KEY FK10F22749C5F056D9; +ALTER IGNORE TABLE tl_lagmap10_marker DROP FOREIGN KEY FK10F22749C5F056D9; ALTER TABLE tl_lagmap10_marker ADD CONSTRAINT FK10F22749C5F056D9 FOREIGN KEY (`gmap_session_uid`) REFERENCES `tl_lagmap10_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lagmap10_marker DROP FOREIGN KEY FK10F22749EF5F6920; +ALTER IGNORE TABLE tl_lagmap10_marker DROP FOREIGN KEY FK10F22749EF5F6920; ALTER TABLE tl_lagmap10_marker ADD CONSTRAINT FK10F22749EF5F6920 FOREIGN KEY (`updated_by`) REFERENCES `tl_lagmap10_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lagmap10_session DROP FOREIGN KEY FK519D516774028C80; +ALTER IGNORE TABLE tl_lagmap10_session DROP FOREIGN KEY FK519D516774028C80; ALTER TABLE tl_lagmap10_session ADD CONSTRAINT FK519D516774028C80 FOREIGN KEY (`gmap_uid`) REFERENCES `tl_lagmap10_gmap` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lagmap10_user DROP FOREIGN KEY FK7CB3F69AC5F056D9; +ALTER IGNORE TABLE tl_lagmap10_user DROP FOREIGN KEY FK7CB3F69AC5F056D9; ALTER TABLE tl_lagmap10_user ADD CONSTRAINT FK7CB3F69AC5F056D9 FOREIGN KEY (`gmap_session_uid`) REFERENCES `tl_lagmap10_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_images/src/java/org/lamsfoundation/lams/tool/imageGallery/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,48 +5,48 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_laimag10_image_vote DROP FOREIGN KEY FK_tl_laimag10_image_vote_2; +ALTER IGNORE TABLE tl_laimag10_image_vote DROP FOREIGN KEY FK_tl_laimag10_image_vote_2; ALTER TABLE tl_laimag10_image_vote ADD CONSTRAINT FK_tl_laimag10_image_vote_2 FOREIGN KEY (`create_by`) REFERENCES `tl_laimag10_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_laimag10_image_vote DROP FOREIGN KEY FK_tl_laimag10_image_vote_3; +ALTER IGNORE TABLE tl_laimag10_image_vote DROP FOREIGN KEY FK_tl_laimag10_image_vote_3; ALTER TABLE tl_laimag10_image_vote ADD CONSTRAINT FK_tl_laimag10_image_vote_3 FOREIGN KEY (`imageGallery_item_uid`) REFERENCES `tl_laimag10_imagegallery_item` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laimag10_imagegallery_item DROP FOREIGN KEY FK_NEW_1821149711_F52D1F9330E79035; +ALTER IGNORE TABLE tl_laimag10_imagegallery_item DROP FOREIGN KEY FK_NEW_1821149711_F52D1F9330E79035; ALTER TABLE tl_laimag10_imagegallery_item ADD CONSTRAINT FK_NEW_1821149711_F52D1F9330E79035 FOREIGN KEY (`imageGallery_uid`) REFERENCES `tl_laimag10_imagegallery` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laimag10_imagegallery_item DROP FOREIGN KEY FK_NEW_1821149711_F52D1F93758092FB; +ALTER IGNORE TABLE tl_laimag10_imagegallery_item DROP FOREIGN KEY FK_NEW_1821149711_F52D1F93758092FB; ALTER TABLE tl_laimag10_imagegallery_item ADD CONSTRAINT FK_NEW_1821149711_F52D1F93758092FB FOREIGN KEY (`create_by`) REFERENCES `tl_laimag10_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_laimag10_item_log DROP FOREIGN KEY FK_NEW_1821149711_693580A438BF8DFE; +ALTER IGNORE TABLE tl_laimag10_item_log DROP FOREIGN KEY FK_NEW_1821149711_693580A438BF8DFE; ALTER TABLE tl_laimag10_item_log ADD CONSTRAINT FK_NEW_1821149711_693580A438BF8DFE FOREIGN KEY (`imageGallery_item_uid`) REFERENCES `tl_laimag10_imagegallery_item` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laimag10_item_log DROP FOREIGN KEY FK_NEW_1821149711_693580A441F9365D; +ALTER IGNORE TABLE tl_laimag10_item_log DROP FOREIGN KEY FK_NEW_1821149711_693580A441F9365D; ALTER TABLE tl_laimag10_item_log ADD CONSTRAINT FK_NEW_1821149711_693580A441F9365D FOREIGN KEY (`user_uid`) REFERENCES `tl_laimag10_user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laimag10_session DROP FOREIGN KEY FK_NEW_1821149711_24AA78C530E79035; +ALTER IGNORE TABLE tl_laimag10_session DROP FOREIGN KEY FK_NEW_1821149711_24AA78C530E79035; ALTER TABLE tl_laimag10_session ADD CONSTRAINT FK_NEW_1821149711_24AA78C530E79035 FOREIGN KEY (`imageGallery_uid`) REFERENCES `tl_laimag10_imagegallery` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laimag10_user DROP FOREIGN KEY FK_NEW_1821149711_30113BFCEC0D3147; +ALTER IGNORE TABLE tl_laimag10_user DROP FOREIGN KEY FK_NEW_1821149711_30113BFCEC0D3147; ALTER TABLE tl_laimag10_user ADD CONSTRAINT FK_NEW_1821149711_30113BFCEC0D3147 FOREIGN KEY (`session_uid`) REFERENCES `tl_laimag10_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laimag10_user DROP FOREIGN KEY FK_NEW_1821149711_30113BFC309ED320; +ALTER IGNORE TABLE tl_laimag10_user DROP FOREIGN KEY FK_NEW_1821149711_30113BFC309ED320; ALTER TABLE tl_laimag10_user ADD CONSTRAINT FK_NEW_1821149711_30113BFC309ED320 FOREIGN KEY (`imageGallery_uid`) REFERENCES `tl_laimag10_imagegallery` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laimag10_imagegallery DROP FOREIGN KEY FK_NEW_1821149711_89093BF758092FB; +ALTER IGNORE TABLE tl_laimag10_imagegallery DROP FOREIGN KEY FK_NEW_1821149711_89093BF758092FB; ALTER TABLE tl_laimag10_imagegallery ADD CONSTRAINT FK_NEW_1821149711_89093BF758092FB FOREIGN KEY (`create_by`) REFERENCES `tl_laimag10_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; Index: lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_imscc/src/java/org/lamsfoundation/lams/tool/commonCartridge/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,48 +5,48 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_laimsc11_commoncartridge DROP FOREIGN KEY FK_NEW_1279208528_89093BF758092FB; +ALTER IGNORE TABLE tl_laimsc11_commoncartridge DROP FOREIGN KEY FK_NEW_1279208528_89093BF758092FB; ALTER TABLE tl_laimsc11_commoncartridge ADD CONSTRAINT FK_NEW_1279208528_89093BF758092FB FOREIGN KEY (`create_by`) REFERENCES `tl_laimsc11_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_laimsc11_commoncartridge_item DROP FOREIGN KEY FK_NEW_1279208528_F52D1F9330E79035; +ALTER IGNORE TABLE tl_laimsc11_commoncartridge_item DROP FOREIGN KEY FK_NEW_1279208528_F52D1F9330E79035; ALTER TABLE tl_laimsc11_commoncartridge_item ADD CONSTRAINT FK_NEW_1279208528_F52D1F9330E79035 FOREIGN KEY (`commonCartridge_uid`) REFERENCES `tl_laimsc11_commoncartridge` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laimsc11_commoncartridge_item DROP FOREIGN KEY FK_NEW_1279208528_F52D1F93758092FB; +ALTER IGNORE TABLE tl_laimsc11_commoncartridge_item DROP FOREIGN KEY FK_NEW_1279208528_F52D1F93758092FB; ALTER TABLE tl_laimsc11_commoncartridge_item ADD CONSTRAINT FK_NEW_1279208528_F52D1F93758092FB FOREIGN KEY (`create_by`) REFERENCES `tl_laimsc11_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_laimsc11_commoncartridge_item DROP FOREIGN KEY FK_NEW_1279208528_F52D1F93EC0D3147; +ALTER IGNORE TABLE tl_laimsc11_commoncartridge_item DROP FOREIGN KEY FK_NEW_1279208528_F52D1F93EC0D3147; ALTER TABLE tl_laimsc11_commoncartridge_item ADD CONSTRAINT FK_NEW_1279208528_F52D1F93EC0D3147 FOREIGN KEY (`session_uid`) REFERENCES `tl_laimsc11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laimsc11_item_instruction DROP FOREIGN KEY FK_NEW_1279208528_A5665013980570ED; +ALTER IGNORE TABLE tl_laimsc11_item_instruction DROP FOREIGN KEY FK_NEW_1279208528_A5665013980570ED; ALTER TABLE tl_laimsc11_item_instruction ADD CONSTRAINT FK_NEW_1279208528_A5665013980570ED FOREIGN KEY (`item_uid`) REFERENCES `tl_laimsc11_commoncartridge_item` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laimsc11_item_log DROP FOREIGN KEY FK_NEW_1279208528_693580A438BF8DFE; +ALTER IGNORE TABLE tl_laimsc11_item_log DROP FOREIGN KEY FK_NEW_1279208528_693580A438BF8DFE; ALTER TABLE tl_laimsc11_item_log ADD CONSTRAINT FK_NEW_1279208528_693580A438BF8DFE FOREIGN KEY (`commonCartridge_item_uid`) REFERENCES `tl_laimsc11_commoncartridge_item` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laimsc11_item_log DROP FOREIGN KEY FK_NEW_1279208528_693580A441F9365D; +ALTER IGNORE TABLE tl_laimsc11_item_log DROP FOREIGN KEY FK_NEW_1279208528_693580A441F9365D; ALTER TABLE tl_laimsc11_item_log ADD CONSTRAINT FK_NEW_1279208528_693580A441F9365D FOREIGN KEY (`user_uid`) REFERENCES `tl_laimsc11_user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laimsc11_session DROP FOREIGN KEY FK_NEW_1279208528_24AA78C530E79035; +ALTER IGNORE TABLE tl_laimsc11_session DROP FOREIGN KEY FK_NEW_1279208528_24AA78C530E79035; ALTER TABLE tl_laimsc11_session ADD CONSTRAINT FK_NEW_1279208528_24AA78C530E79035 FOREIGN KEY (`commonCartridge_uid`) REFERENCES `tl_laimsc11_commoncartridge` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laimsc11_user DROP FOREIGN KEY FK_NEW_1279208528_30113BFCEC0D3147; +ALTER IGNORE TABLE tl_laimsc11_user DROP FOREIGN KEY FK_NEW_1279208528_30113BFCEC0D3147; ALTER TABLE tl_laimsc11_user ADD CONSTRAINT FK_NEW_1279208528_30113BFCEC0D3147 FOREIGN KEY (`session_uid`) REFERENCES `tl_laimsc11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laimsc11_user DROP FOREIGN KEY FK_NEW_1279208528_30113BFC309ED320; +ALTER IGNORE TABLE tl_laimsc11_user DROP FOREIGN KEY FK_NEW_1279208528_30113BFC309ED320; ALTER TABLE tl_laimsc11_user ADD CONSTRAINT FK_NEW_1279208528_30113BFC309ED320 FOREIGN KEY (`commonCartridge_uid`) REFERENCES `tl_laimsc11_commoncartridge` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_kaltura/src/java/org/lamsfoundation/lams/tool/kaltura/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,58 +5,58 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lakalt11_comment DROP FOREIGN KEY FK_tl_lakalt11_comment_2; +ALTER IGNORE TABLE tl_lakalt11_comment DROP FOREIGN KEY FK_tl_lakalt11_comment_2; ALTER TABLE tl_lakalt11_comment ADD CONSTRAINT FK_tl_lakalt11_comment_2 FOREIGN KEY (`create_by`) REFERENCES `tl_lakalt11_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lakalt11_comment DROP FOREIGN KEY FK_tl_lakalt11_comment_3; +ALTER IGNORE TABLE tl_lakalt11_comment DROP FOREIGN KEY FK_tl_lakalt11_comment_3; ALTER TABLE tl_lakalt11_comment ADD CONSTRAINT FK_tl_lakalt11_comment_3 FOREIGN KEY (`kaltura_item_uid`) REFERENCES `tl_lakalt11_kaltura_item` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lakalt11_item_log DROP FOREIGN KEY FK_tl_lakalt11_item_log_1; +ALTER IGNORE TABLE tl_lakalt11_item_log DROP FOREIGN KEY FK_tl_lakalt11_item_log_1; ALTER TABLE tl_lakalt11_item_log ADD CONSTRAINT FK_tl_lakalt11_item_log_1 FOREIGN KEY (`kaltura_item_uid`) REFERENCES `tl_lakalt11_kaltura_item` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lakalt11_item_log DROP FOREIGN KEY FK_tl_lakalt11_item_log_2; +ALTER IGNORE TABLE tl_lakalt11_item_log DROP FOREIGN KEY FK_tl_lakalt11_item_log_2; ALTER TABLE tl_lakalt11_item_log ADD CONSTRAINT FK_tl_lakalt11_item_log_2 FOREIGN KEY (`user_uid`) REFERENCES `tl_lakalt11_user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lakalt11_kaltura DROP FOREIGN KEY FK_NEW_174079131_89093BF758092FB; +ALTER IGNORE TABLE tl_lakalt11_kaltura DROP FOREIGN KEY FK_NEW_174079131_89093BF758092FB; ALTER TABLE tl_lakalt11_kaltura ADD CONSTRAINT FK_NEW_174079131_89093BF758092FB FOREIGN KEY (`create_by`) REFERENCES `tl_lakalt11_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lakalt11_kaltura_item DROP FOREIGN KEY FK_tl_lakalt11_item_1; +ALTER IGNORE TABLE tl_lakalt11_kaltura_item DROP FOREIGN KEY FK_tl_lakalt11_item_1; ALTER TABLE tl_lakalt11_kaltura_item ADD CONSTRAINT FK_tl_lakalt11_item_1 FOREIGN KEY (`create_by`) REFERENCES `tl_lakalt11_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lakalt11_kaltura_item DROP FOREIGN KEY FK_tl_lakalt11_item_2; +ALTER IGNORE TABLE tl_lakalt11_kaltura_item DROP FOREIGN KEY FK_tl_lakalt11_item_2; ALTER TABLE tl_lakalt11_kaltura_item ADD CONSTRAINT FK_tl_lakalt11_item_2 FOREIGN KEY (`kaltura_uid`) REFERENCES `tl_lakalt11_kaltura` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lakalt11_rating DROP FOREIGN KEY FK_tl_lakalt11_rating_2; +ALTER IGNORE TABLE tl_lakalt11_rating DROP FOREIGN KEY FK_tl_lakalt11_rating_2; ALTER TABLE tl_lakalt11_rating ADD CONSTRAINT FK_tl_lakalt11_rating_2 FOREIGN KEY (`create_by`) REFERENCES `tl_lakalt11_user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lakalt11_rating DROP FOREIGN KEY FK_tl_lakalt11_rating_3; +ALTER IGNORE TABLE tl_lakalt11_rating DROP FOREIGN KEY FK_tl_lakalt11_rating_3; ALTER TABLE tl_lakalt11_rating ADD CONSTRAINT FK_tl_lakalt11_rating_3 FOREIGN KEY (`kaltura_item_uid`) REFERENCES `tl_lakalt11_kaltura_item` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lakalt11_session DROP FOREIGN KEY FK_NEW_1533935501_B7C198E2FC940906; +ALTER IGNORE TABLE tl_lakalt11_session DROP FOREIGN KEY FK_NEW_1533935501_B7C198E2FC940906; ALTER TABLE tl_lakalt11_session ADD CONSTRAINT FK_NEW_1533935501_B7C198E2FC940906 FOREIGN KEY (`kaltura_uid`) REFERENCES `tl_lakalt11_kaltura` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lakalt11_user DROP FOREIGN KEY FK_tl_lakalt11_user_1; +ALTER IGNORE TABLE tl_lakalt11_user DROP FOREIGN KEY FK_tl_lakalt11_user_1; ALTER TABLE tl_lakalt11_user ADD CONSTRAINT FK_tl_lakalt11_user_1 FOREIGN KEY (`kaltura_session_uid`) REFERENCES `tl_lakalt11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lakalt11_user DROP FOREIGN KEY FK_tl_lakalt11_user_2; +ALTER IGNORE TABLE tl_lakalt11_user DROP FOREIGN KEY FK_tl_lakalt11_user_2; ALTER TABLE tl_lakalt11_user ADD CONSTRAINT FK_tl_lakalt11_user_2 FOREIGN KEY (`kaltura_uid`) REFERENCES `tl_lakalt11_kaltura` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,39 +5,39 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lamc11_options_content DROP FOREIGN KEY FK_tl_lamc11_options_content_1; +ALTER IGNORE TABLE tl_lamc11_options_content DROP FOREIGN KEY FK_tl_lamc11_options_content_1; ALTER TABLE tl_lamc11_options_content ADD CONSTRAINT FK_tl_lamc11_options_content_1 FOREIGN KEY (`mc_que_content_id`) REFERENCES `tl_lamc11_que_content` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lamc11_que_content DROP FOREIGN KEY FK_tl_lamc11_que_content_1; +ALTER IGNORE TABLE tl_lamc11_que_content DROP FOREIGN KEY FK_tl_lamc11_que_content_1; ALTER TABLE tl_lamc11_que_content ADD CONSTRAINT FK_tl_lamc11_que_content_1 FOREIGN KEY (`mc_content_id`) REFERENCES `tl_lamc11_content` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lamc11_que_usr DROP FOREIGN KEY FK_tl_lamc11_que_usr_1; +ALTER IGNORE TABLE tl_lamc11_que_usr DROP FOREIGN KEY FK_tl_lamc11_que_usr_1; ALTER TABLE tl_lamc11_que_usr ADD CONSTRAINT FK_tl_lamc11_que_usr_1 FOREIGN KEY (`mc_session_id`) REFERENCES `tl_lamc11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lamc11_session DROP FOREIGN KEY FK_lamc11_session1; +ALTER IGNORE TABLE tl_lamc11_session DROP FOREIGN KEY FK_lamc11_session1; ALTER TABLE tl_lamc11_session ADD CONSTRAINT FK_lamc11_session1 FOREIGN KEY (`mc_group_leader_uid`) REFERENCES `tl_lamc11_que_usr` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lamc11_session DROP FOREIGN KEY FK_tl_lamc_session_1; +ALTER IGNORE TABLE tl_lamc11_session DROP FOREIGN KEY FK_tl_lamc_session_1; ALTER TABLE tl_lamc11_session ADD CONSTRAINT FK_tl_lamc_session_1 FOREIGN KEY (`mc_content_id`) REFERENCES `tl_lamc11_content` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lamc11_usr_attempt DROP FOREIGN KEY FK_tl_lamc11_usr_attempt_2; +ALTER IGNORE TABLE tl_lamc11_usr_attempt DROP FOREIGN KEY FK_tl_lamc11_usr_attempt_2; ALTER TABLE tl_lamc11_usr_attempt ADD CONSTRAINT FK_tl_lamc11_usr_attempt_2 FOREIGN KEY (`mc_que_content_id`) REFERENCES `tl_lamc11_que_content` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lamc11_usr_attempt DROP FOREIGN KEY FK_tl_lamc11_usr_attempt_3; +ALTER IGNORE TABLE tl_lamc11_usr_attempt DROP FOREIGN KEY FK_tl_lamc11_usr_attempt_3; ALTER TABLE tl_lamc11_usr_attempt ADD CONSTRAINT FK_tl_lamc11_usr_attempt_3 FOREIGN KEY (`mc_que_option_id`) REFERENCES `tl_lamc11_options_content` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lamc11_usr_attempt DROP FOREIGN KEY FK_tl_lamc11_usr_attempt_4; +ALTER IGNORE TABLE tl_lamc11_usr_attempt DROP FOREIGN KEY FK_tl_lamc11_usr_attempt_4; ALTER TABLE tl_lamc11_usr_attempt ADD CONSTRAINT FK_tl_lamc11_usr_attempt_4 FOREIGN KEY (`que_usr_id`) REFERENCES `tl_lamc11_que_usr` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20151217.sql =================================================================== diff -u -red8ffee68dc14ae6edd9454b98c575d84b495993 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision ed8ffee68dc14ae6edd9454b98c575d84b495993) +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,41 +5,41 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_laqa11_que_content DROP FOREIGN KEY FK_tl_laqa11_que_content_1; +ALTER IGNORE TABLE tl_laqa11_que_content DROP FOREIGN KEY FK_tl_laqa11_que_content_1; ALTER TABLE tl_laqa11_que_content ADD CONSTRAINT FK_tl_laqa11_que_content_1 FOREIGN KEY (`qa_content_id`) REFERENCES `tl_laqa11_content` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laqa11_que_usr DROP FOREIGN KEY FK_tl_laqa11_que_usr_1; +ALTER IGNORE TABLE tl_laqa11_que_usr DROP FOREIGN KEY FK_tl_laqa11_que_usr_1; ALTER TABLE tl_laqa11_que_usr ADD CONSTRAINT FK_tl_laqa11_que_usr_1 FOREIGN KEY (`qa_session_id`) REFERENCES `tl_laqa11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laqa11_session DROP FOREIGN KEY FK_laqa11_session1; +ALTER IGNORE TABLE tl_laqa11_session DROP FOREIGN KEY FK_laqa11_session1; ALTER TABLE tl_laqa11_session ADD CONSTRAINT FK_laqa11_session1 FOREIGN KEY (`qa_group_leader_uid`) REFERENCES `tl_laqa11_que_usr` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_laqa11_session DROP FOREIGN KEY FK_tl_laqa11_session_1; +ALTER IGNORE TABLE tl_laqa11_session DROP FOREIGN KEY FK_tl_laqa11_session_1; ALTER TABLE tl_laqa11_session ADD CONSTRAINT FK_tl_laqa11_session_1 FOREIGN KEY (`qa_content_id`) REFERENCES `tl_laqa11_content` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE tl_laqa11_usr_resp MODIFY COLUMN qa_que_content_id BIGINT(20) DEFAULT NULL; -ALTER TABLE tl_laqa11_usr_resp DROP FOREIGN KEY FK_tl_laqa11_usr_resp_2; +ALTER IGNORE TABLE tl_laqa11_usr_resp DROP FOREIGN KEY FK_tl_laqa11_usr_resp_2; ALTER TABLE tl_laqa11_usr_resp ADD CONSTRAINT FK_tl_laqa11_usr_resp_2 FOREIGN KEY (`qa_que_content_id`) REFERENCES `tl_laqa11_que_content` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laqa11_usr_resp DROP FOREIGN KEY FK_tl_laqa11_usr_resp_3; +ALTER IGNORE TABLE tl_laqa11_usr_resp DROP FOREIGN KEY FK_tl_laqa11_usr_resp_3; ALTER TABLE tl_laqa11_usr_resp ADD CONSTRAINT FK_tl_laqa11_usr_resp_3 FOREIGN KEY (`que_usr_id`) REFERENCES `tl_laqa11_que_usr` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laqa11_wizard_cognitive_skill DROP FOREIGN KEY FK3BA4132BCBB0DC8D; +ALTER IGNORE TABLE tl_laqa11_wizard_cognitive_skill DROP FOREIGN KEY FK3BA4132BCBB0DC8D; ALTER TABLE tl_laqa11_wizard_cognitive_skill ADD CONSTRAINT FK3BA4132BCBB0DC8D FOREIGN KEY (`category_uid`) REFERENCES `tl_laqa11_wizard_category` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_laqa11_wizard_question DROP FOREIGN KEY FKAF08A0C7EFF77FD4; +ALTER IGNORE TABLE tl_laqa11_wizard_question DROP FOREIGN KEY FKAF08A0C7EFF77FD4; ALTER TABLE tl_laqa11_wizard_question ADD CONSTRAINT FKAF08A0C7EFF77FD4 FOREIGN KEY (`cognitive_skill_uid`) REFERENCES `tl_laqa11_wizard_cognitive_skill` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,48 +5,48 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_larsrc11_item_instruction DROP FOREIGN KEY FKA5665013980570ED; +ALTER IGNORE TABLE tl_larsrc11_item_instruction DROP FOREIGN KEY FKA5665013980570ED; ALTER TABLE tl_larsrc11_item_instruction ADD CONSTRAINT FKA5665013980570ED FOREIGN KEY (`item_uid`) REFERENCES `tl_larsrc11_resource_item` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_larsrc11_item_log DROP FOREIGN KEY FK693580A438BF8DFE; +ALTER IGNORE TABLE tl_larsrc11_item_log DROP FOREIGN KEY FK693580A438BF8DFE; ALTER TABLE tl_larsrc11_item_log ADD CONSTRAINT FK693580A438BF8DFE FOREIGN KEY (`resource_item_uid`) REFERENCES `tl_larsrc11_resource_item` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_larsrc11_item_log DROP FOREIGN KEY FK693580A441F9365D; +ALTER IGNORE TABLE tl_larsrc11_item_log DROP FOREIGN KEY FK693580A441F9365D; ALTER TABLE tl_larsrc11_item_log ADD CONSTRAINT FK693580A441F9365D FOREIGN KEY (`user_uid`) REFERENCES `tl_larsrc11_user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_larsrc11_resource DROP FOREIGN KEY FK89093BF758092FB; +ALTER IGNORE TABLE tl_larsrc11_resource DROP FOREIGN KEY FK89093BF758092FB; ALTER TABLE tl_larsrc11_resource ADD CONSTRAINT FK89093BF758092FB FOREIGN KEY (`create_by`) REFERENCES `tl_larsrc11_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_larsrc11_resource_item DROP FOREIGN KEY FKF52D1F9330E79035; +ALTER IGNORE TABLE tl_larsrc11_resource_item DROP FOREIGN KEY FKF52D1F9330E79035; ALTER TABLE tl_larsrc11_resource_item ADD CONSTRAINT FKF52D1F9330E79035 FOREIGN KEY (`resource_uid`) REFERENCES `tl_larsrc11_resource` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_larsrc11_resource_item DROP FOREIGN KEY FKF52D1F93758092FB; +ALTER IGNORE TABLE tl_larsrc11_resource_item DROP FOREIGN KEY FKF52D1F93758092FB; ALTER TABLE tl_larsrc11_resource_item ADD CONSTRAINT FKF52D1F93758092FB FOREIGN KEY (`create_by`) REFERENCES `tl_larsrc11_user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_larsrc11_resource_item DROP FOREIGN KEY FKF52D1F93EC0D3147; +ALTER IGNORE TABLE tl_larsrc11_resource_item DROP FOREIGN KEY FKF52D1F93EC0D3147; ALTER TABLE tl_larsrc11_resource_item ADD CONSTRAINT FKF52D1F93EC0D3147 FOREIGN KEY (`session_uid`) REFERENCES `tl_larsrc11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_larsrc11_session DROP FOREIGN KEY FK24AA78C530E79035; +ALTER IGNORE TABLE tl_larsrc11_session DROP FOREIGN KEY FK24AA78C530E79035; ALTER TABLE tl_larsrc11_session ADD CONSTRAINT FK24AA78C530E79035 FOREIGN KEY (`resource_uid`) REFERENCES `tl_larsrc11_resource` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_larsrc11_user DROP FOREIGN KEY FK30113BFCEC0D3147; +ALTER IGNORE TABLE tl_larsrc11_user DROP FOREIGN KEY FK30113BFCEC0D3147; ALTER TABLE tl_larsrc11_user ADD CONSTRAINT FK30113BFCEC0D3147 FOREIGN KEY (`session_uid`) REFERENCES `tl_larsrc11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_larsrc11_user DROP FOREIGN KEY FK30113BFC309ED320; +ALTER IGNORE TABLE tl_larsrc11_user DROP FOREIGN KEY FK30113BFC309ED320; ALTER TABLE tl_larsrc11_user ADD CONSTRAINT FK30113BFC309ED320 FOREIGN KEY (`resource_uid`) REFERENCES `tl_larsrc11_resource` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; Index: lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_leader/src/java/org/lamsfoundation/lams/tool/leaderselection/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,16 +5,16 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lalead11_session DROP FOREIGN KEY FK_lalead11_1; +ALTER IGNORE TABLE tl_lalead11_session DROP FOREIGN KEY FK_lalead11_1; ALTER TABLE tl_lalead11_session ADD CONSTRAINT FK_lalead11_1 FOREIGN KEY (`group_leader_uid`) REFERENCES `tl_lalead11_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lalead11_session DROP FOREIGN KEY FK_NEW_1316293302_B7C198E2FC940906; +ALTER IGNORE TABLE tl_lalead11_session DROP FOREIGN KEY FK_NEW_1316293302_B7C198E2FC940906; ALTER TABLE tl_lalead11_session ADD CONSTRAINT FK_NEW_1316293302_B7C198E2FC940906 FOREIGN KEY (`leaderselection_uid`) REFERENCES `tl_lalead11_leaderselection` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lalead11_user DROP FOREIGN KEY FK_NEW_1316293302_CB8A58FFA3B0FADF; +ALTER IGNORE TABLE tl_lalead11_user DROP FOREIGN KEY FK_NEW_1316293302_CB8A58FFA3B0FADF; ALTER TABLE tl_lalead11_user ADD CONSTRAINT FK_NEW_1316293302_CB8A58FFA3B0FADF FOREIGN KEY (`leaderselection_session_uid`) REFERENCES `tl_lalead11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_mindmap/src/java/org/lamsfoundation/lams/tool/mindmap/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,34 +5,34 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lamind10_node DROP FOREIGN KEY MindmapNode_Mindmap_FK; +ALTER IGNORE TABLE tl_lamind10_node DROP FOREIGN KEY MindmapNode_Mindmap_FK; ALTER TABLE tl_lamind10_node ADD CONSTRAINT MindmapNode_Mindmap_FK FOREIGN KEY (`mindmap_id`) REFERENCES `tl_lamind10_mindmap` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lamind10_node DROP FOREIGN KEY MindmapNode_Parent_FK; +ALTER IGNORE TABLE tl_lamind10_node DROP FOREIGN KEY MindmapNode_Parent_FK; ALTER TABLE tl_lamind10_node ADD CONSTRAINT MindmapNode_Parent_FK FOREIGN KEY (`parent_id`) REFERENCES `tl_lamind10_node` (`node_id`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lamind10_node DROP FOREIGN KEY MindmapNode_User_FK; +ALTER IGNORE TABLE tl_lamind10_node DROP FOREIGN KEY MindmapNode_User_FK; ALTER TABLE tl_lamind10_node ADD CONSTRAINT MindmapNode_User_FK FOREIGN KEY (`user_id`) REFERENCES `tl_lamind10_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lamind10_request DROP FOREIGN KEY tl_lamind10_request_fk; +ALTER IGNORE TABLE tl_lamind10_request DROP FOREIGN KEY tl_lamind10_request_fk; ALTER TABLE tl_lamind10_request ADD CONSTRAINT tl_lamind10_request_fk FOREIGN KEY (`mindmap_id`) REFERENCES `tl_lamind10_mindmap` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lamind10_request DROP FOREIGN KEY tl_lamind10_request_fk1; +ALTER IGNORE TABLE tl_lamind10_request DROP FOREIGN KEY tl_lamind10_request_fk1; ALTER TABLE tl_lamind10_request ADD CONSTRAINT tl_lamind10_request_fk1 FOREIGN KEY (`user_id`) REFERENCES `tl_lamind10_user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lamind10_session DROP FOREIGN KEY FK_NEW_972920762_B7C198E2FC940906; +ALTER IGNORE TABLE tl_lamind10_session DROP FOREIGN KEY FK_NEW_972920762_B7C198E2FC940906; ALTER TABLE tl_lamind10_session ADD CONSTRAINT FK_NEW_972920762_B7C198E2FC940906 FOREIGN KEY (`mindmap_uid`) REFERENCES `tl_lamind10_mindmap` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lamind10_user DROP FOREIGN KEY FK_NEW_972920762_CB8A58FFA3B0FADF; +ALTER IGNORE TABLE tl_lamind10_user DROP FOREIGN KEY FK_NEW_972920762_CB8A58FFA3B0FADF; ALTER TABLE tl_lamind10_user ADD CONSTRAINT FK_NEW_972920762_CB8A58FFA3B0FADF FOREIGN KEY (`mindmap_session_uid`) REFERENCES `tl_lamind10_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_nb/src/java/org/lamsfoundation/lams/tool/noticeboard/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,11 +5,11 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lanb11_session DROP FOREIGN KEY FK_tl_lanb11_session_1; +ALTER IGNORE TABLE tl_lanb11_session DROP FOREIGN KEY FK_tl_lanb11_session_1; ALTER TABLE tl_lanb11_session ADD CONSTRAINT FK_tl_lanb11_session_1 FOREIGN KEY (`nb_content_uid`) REFERENCES `tl_lanb11_content` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lanb11_user DROP FOREIGN KEY FK_tl_lanb11_user_1; +ALTER IGNORE TABLE tl_lanb11_user DROP FOREIGN KEY FK_tl_lanb11_user_1; ALTER TABLE tl_lanb11_user ADD CONSTRAINT FK_tl_lanb11_user_1 FOREIGN KEY (`nb_session_uid`) REFERENCES `tl_lanb11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_notebook/src/java/org/lamsfoundation/lams/tool/notebook/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -6,11 +6,11 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lantbk11_session DROP FOREIGN KEY FKB7C198E2FC940906; +ALTER IGNORE TABLE tl_lantbk11_session DROP FOREIGN KEY FKB7C198E2FC940906; ALTER TABLE tl_lantbk11_session ADD CONSTRAINT FKB7C198E2FC940906 FOREIGN KEY (`notebook_uid`) REFERENCES `tl_lantbk11_notebook` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lantbk11_user DROP FOREIGN KEY FKCB8A58FFA3B0FADF; +ALTER IGNORE TABLE tl_lantbk11_user DROP FOREIGN KEY FKCB8A58FFA3B0FADF; ALTER TABLE tl_lantbk11_user ADD CONSTRAINT FKCB8A58FFA3B0FADF FOREIGN KEY (`notebook_session_uid`) REFERENCES `tl_lantbk11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_pixlr/src/java/org/lamsfoundation/lams/tool/pixlr/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,11 +5,11 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lapixl10_session DROP FOREIGN KEY FKE5C05E7FCB8ADA74; +ALTER IGNORE TABLE tl_lapixl10_session DROP FOREIGN KEY FKE5C05E7FCB8ADA74; ALTER TABLE tl_lapixl10_session ADD CONSTRAINT FKE5C05E7FCB8ADA74 FOREIGN KEY (`pixlr_uid`) REFERENCES `tl_lapixl10_pixlr` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lapixl10_user DROP FOREIGN KEY FK9A39C08236E23005; +ALTER IGNORE TABLE tl_lapixl10_user DROP FOREIGN KEY FK9A39C08236E23005; ALTER TABLE tl_lapixl10_user ADD CONSTRAINT FK9A39C08236E23005 FOREIGN KEY (`pixlr_session_uid`) REFERENCES `tl_lapixl10_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20151217.sql =================================================================== diff -u -r3d5a47c13b9fcea6ca5e9f41d98af144bfa7f458 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 3d5a47c13b9fcea6ca5e9f41d98af144bfa7f458) +++ lams_tool_preview/src/java/org/lamsfoundation/lams/tool/peerreview/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,21 +5,21 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_laprev11_peerreview DROP FOREIGN KEY FK_NEW_1661738138_89093BF758092FB; +ALTER IGNORE 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 TABLE tl_laprev11_session DROP FOREIGN KEY FK_NEW_1661738138_24AA78C530E79035; +ALTER IGNORE 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 TABLE tl_laprev11_user DROP FOREIGN KEY FK_NEW_1661738138_30113BFC309ED320; +ALTER IGNORE 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 TABLE tl_laprev11_user DROP FOREIGN KEY FK_NEW_1661738138_30113BFCEC0D3147; +ALTER IGNORE 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; Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,21 +5,21 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lasbmt11_content DROP FOREIGN KEY FKAEF329AC172BC670; +ALTER IGNORE TABLE tl_lasbmt11_content DROP FOREIGN KEY FKAEF329AC172BC670; ALTER TABLE tl_lasbmt11_content ADD CONSTRAINT FKAEF329AC172BC670 FOREIGN KEY (`created_by`) REFERENCES `tl_lasbmt11_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lasbmt11_session DROP FOREIGN KEY FKEC8C77C9785A173A; +ALTER IGNORE TABLE tl_lasbmt11_session DROP FOREIGN KEY FKEC8C77C9785A173A; ALTER TABLE tl_lasbmt11_session ADD CONSTRAINT FKEC8C77C9785A173A FOREIGN KEY (`content_id`) REFERENCES `tl_lasbmt11_content` (`content_id`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lasbmt11_submission_details DROP FOREIGN KEY FK1411A53C93C861A; +ALTER IGNORE TABLE tl_lasbmt11_submission_details DROP FOREIGN KEY FK1411A53C93C861A; ALTER TABLE tl_lasbmt11_submission_details ADD CONSTRAINT FK1411A53C93C861A FOREIGN KEY (`session_id`) REFERENCES `tl_lasbmt11_session` (`session_id`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lasbmt11_submission_details DROP FOREIGN KEY FK1411A53CFFD5A38B; +ALTER IGNORE TABLE tl_lasbmt11_submission_details DROP FOREIGN KEY FK1411A53CFFD5A38B; ALTER TABLE tl_lasbmt11_submission_details ADD CONSTRAINT FK1411A53CFFD5A38B FOREIGN KEY (`learner_id`) REFERENCES `tl_lasbmt11_user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,48 +5,48 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lascrt11_scratchie_answer DROP FOREIGN KEY FK_scratchie_answer_1; +ALTER IGNORE TABLE tl_lascrt11_scratchie_answer DROP FOREIGN KEY FK_scratchie_answer_1; ALTER TABLE tl_lascrt11_scratchie_answer ADD CONSTRAINT FK_scratchie_answer_1 FOREIGN KEY (`scratchie_item_uid`) REFERENCES `tl_lascrt11_scratchie_item` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lascrt11_scratchie_item DROP FOREIGN KEY FK_NEW_610529188_F52D1F9330E79035; +ALTER IGNORE TABLE tl_lascrt11_scratchie_item DROP FOREIGN KEY FK_NEW_610529188_F52D1F9330E79035; ALTER TABLE tl_lascrt11_scratchie_item ADD CONSTRAINT FK_NEW_610529188_F52D1F9330E79035 FOREIGN KEY (`scratchie_uid`) REFERENCES `tl_lascrt11_scratchie` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lascrt11_scratchie_item DROP FOREIGN KEY FK_NEW_610529188_F52D1F93EC0D3147; +ALTER IGNORE TABLE tl_lascrt11_scratchie_item DROP FOREIGN KEY FK_NEW_610529188_F52D1F93EC0D3147; ALTER TABLE tl_lascrt11_scratchie_item ADD CONSTRAINT FK_NEW_610529188_F52D1F93EC0D3147 FOREIGN KEY (`session_uid`) REFERENCES `tl_lascrt11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lascrt11_session DROP FOREIGN KEY FK_lalead11_session1; +ALTER IGNORE TABLE tl_lascrt11_session DROP FOREIGN KEY FK_lalead11_session1; ALTER TABLE tl_lascrt11_session ADD CONSTRAINT FK_lalead11_session1 FOREIGN KEY (`group_leader_uid`) REFERENCES `tl_lascrt11_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lascrt11_session DROP FOREIGN KEY FK_NEW_610529188_24AA78C530E79035; +ALTER IGNORE TABLE tl_lascrt11_session DROP FOREIGN KEY FK_NEW_610529188_24AA78C530E79035; ALTER TABLE tl_lascrt11_session ADD CONSTRAINT FK_NEW_610529188_24AA78C530E79035 FOREIGN KEY (`scratchie_uid`) REFERENCES `tl_lascrt11_scratchie` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lascrt11_user DROP FOREIGN KEY FK_NEW_610529188_30113BFCEC0D3147; +ALTER IGNORE TABLE tl_lascrt11_user DROP FOREIGN KEY FK_NEW_610529188_30113BFCEC0D3147; 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_answer_log DROP FOREIGN KEY sessionIdIndex; +ALTER IGNORE TABLE tl_lascrt11_answer_log DROP FOREIGN KEY sessionIdIndex; ALTER TABLE tl_lascrt11_answer_log ADD CONSTRAINT sessionIdIndex FOREIGN KEY (`session_id`) REFERENCES `tl_lascrt11_session` (`session_id`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lascrt11_answer_log DROP FOREIGN KEY FK_NEW_610529188_693580A438BF8DFE; +ALTER IGNORE TABLE tl_lascrt11_answer_log DROP FOREIGN KEY FK_NEW_610529188_693580A438BF8DFE; ALTER TABLE tl_lascrt11_answer_log ADD CONSTRAINT FK_NEW_610529188_693580A438BF8DFE FOREIGN KEY (`scratchie_answer_uid`) REFERENCES `tl_lascrt11_scratchie_answer` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lascrt11_burning_question DROP FOREIGN KEY sessionIdIndex2; +ALTER IGNORE TABLE tl_lascrt11_burning_question DROP FOREIGN KEY sessionIdIndex2; ALTER TABLE tl_lascrt11_burning_question ADD CONSTRAINT sessionIdIndex2 FOREIGN KEY (`session_id`) REFERENCES `tl_lascrt11_session` (`session_id`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lascrt11_burning_question DROP FOREIGN KEY FK_NEW_610529188_693580A438BF8DF2; +ALTER IGNORE TABLE tl_lascrt11_burning_question DROP FOREIGN KEY FK_NEW_610529188_693580A438BF8DF2; ALTER TABLE tl_lascrt11_burning_question ADD CONSTRAINT FK_NEW_610529188_693580A438BF8DF2 FOREIGN KEY (`scratchie_item_uid`) REFERENCES `tl_lascrt11_scratchie_item` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_scribe/src/java/org/lamsfoundation/lams/tool/scribe/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,30 +5,30 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lascrb11_heading DROP FOREIGN KEY FK428A22FFB3FA1495; +ALTER IGNORE TABLE tl_lascrb11_heading DROP FOREIGN KEY FK428A22FFB3FA1495; ALTER TABLE tl_lascrb11_heading ADD CONSTRAINT FK428A22FFB3FA1495 FOREIGN KEY (`scribe_uid`) REFERENCES `tl_lascrb11_scribe` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lascrb11_report_entry DROP FOREIGN KEY FK5439FACA1C266FAE; +ALTER IGNORE TABLE tl_lascrb11_report_entry DROP FOREIGN KEY FK5439FACA1C266FAE; ALTER TABLE tl_lascrb11_report_entry ADD CONSTRAINT FK5439FACA1C266FAE FOREIGN KEY (`scribe_session_uid`) REFERENCES `tl_lascrb11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lascrb11_report_entry DROP FOREIGN KEY FK5439FACAEA50D086; +ALTER IGNORE TABLE tl_lascrb11_report_entry DROP FOREIGN KEY FK5439FACAEA50D086; ALTER TABLE tl_lascrb11_report_entry ADD CONSTRAINT FK5439FACAEA50D086 FOREIGN KEY (`scribe_heading_uid`) REFERENCES `tl_lascrb11_heading` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lascrb11_session DROP FOREIGN KEY FK89732793B3FA1495; +ALTER IGNORE TABLE tl_lascrb11_session DROP FOREIGN KEY FK89732793B3FA1495; ALTER TABLE tl_lascrb11_session ADD CONSTRAINT FK89732793B3FA1495 FOREIGN KEY (`scribe_uid`) REFERENCES `tl_lascrb11_scribe` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lascrb11_session DROP FOREIGN KEY FK89732793E46919FF; +ALTER IGNORE TABLE tl_lascrb11_session DROP FOREIGN KEY FK89732793E46919FF; ALTER TABLE tl_lascrb11_session ADD CONSTRAINT FK89732793E46919FF FOREIGN KEY (`appointed_scribe_uid`) REFERENCES `tl_lascrb11_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lascrb11_user DROP FOREIGN KEY FK187DAFEE1C266FAE; +ALTER IGNORE TABLE tl_lascrb11_user DROP FOREIGN KEY FK187DAFEE1C266FAE; ALTER TABLE tl_lascrb11_user ADD CONSTRAINT FK187DAFEE1C266FAE FOREIGN KEY (`scribe_session_uid`) REFERENCES `tl_lascrb11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_spreadsheet/src/java/org/lamsfoundation/lams/tool/spreadsheet/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,30 +5,30 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lasprd10_session DROP FOREIGN KEY FK_NEW_2065267438_24AA78C530E79035; +ALTER IGNORE TABLE tl_lasprd10_session DROP FOREIGN KEY FK_NEW_2065267438_24AA78C530E79035; ALTER TABLE tl_lasprd10_session ADD CONSTRAINT FK_NEW_2065267438_24AA78C530E79035 FOREIGN KEY (`spreadsheet_uid`) REFERENCES `tl_lasprd10_spreadsheet` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lasprd10_spreadsheet DROP FOREIGN KEY FK_NEW_2065267438_89093BF758092FB; +ALTER IGNORE TABLE tl_lasprd10_spreadsheet DROP FOREIGN KEY FK_NEW_2065267438_89093BF758092FB; ALTER TABLE tl_lasprd10_spreadsheet ADD CONSTRAINT FK_NEW_2065267438_89093BF758092FB FOREIGN KEY (`create_by`) REFERENCES `tl_lasprd10_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lasprd10_user DROP FOREIGN KEY FK_NEW_2065267438_30113BFC309ED320; +ALTER IGNORE TABLE tl_lasprd10_user DROP FOREIGN KEY FK_NEW_2065267438_30113BFC309ED320; ALTER TABLE tl_lasprd10_user ADD CONSTRAINT FK_NEW_2065267438_30113BFC309ED320 FOREIGN KEY (`spreadsheet_uid`) REFERENCES `tl_lasprd10_spreadsheet` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lasprd10_user DROP FOREIGN KEY FK_NEW_2065267438_30113BFCEC0D3147; +ALTER IGNORE TABLE tl_lasprd10_user DROP FOREIGN KEY FK_NEW_2065267438_30113BFCEC0D3147; ALTER TABLE tl_lasprd10_user ADD CONSTRAINT FK_NEW_2065267438_30113BFCEC0D3147 FOREIGN KEY (`session_uid`) REFERENCES `tl_lasprd10_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lasprd10_user DROP FOREIGN KEY FK_NEW_2065267438_693580A441F9365D; +ALTER IGNORE TABLE tl_lasprd10_user DROP FOREIGN KEY FK_NEW_2065267438_693580A441F9365D; ALTER TABLE tl_lasprd10_user ADD CONSTRAINT FK_NEW_2065267438_693580A441F9365D FOREIGN KEY (`user_modified_spreadsheet_uid`) REFERENCES `tl_lasprd10_user_modified_spreadsheet` (`uid`) ON DELETE SET NULL ON UPDATE NO ACTION; -ALTER TABLE tl_lasprd10_user_modified_spreadsheet DROP FOREIGN KEY FK_tl_lasprd10_user_modified_spreadsheet_1; +ALTER IGNORE TABLE tl_lasprd10_user_modified_spreadsheet DROP FOREIGN KEY FK_tl_lasprd10_user_modified_spreadsheet_1; ALTER TABLE tl_lasprd10_user_modified_spreadsheet ADD CONSTRAINT FK_tl_lasprd10_user_modified_spreadsheet_1 FOREIGN KEY (`mark_id`) REFERENCES `tl_lasprd10_spreadsheet_mark` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; Index: lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,44 +5,44 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lasurv11_option DROP FOREIGN KEY FK85AB46F26966134F; +ALTER IGNORE TABLE tl_lasurv11_option DROP FOREIGN KEY FK85AB46F26966134F; ALTER TABLE tl_lasurv11_option ADD CONSTRAINT FK85AB46F26966134F FOREIGN KEY (`question_uid`) REFERENCES `tl_lasurv11_question` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lasurv11_question DROP FOREIGN KEY FK872D4F23D14146E5; +ALTER IGNORE TABLE tl_lasurv11_question DROP FOREIGN KEY FK872D4F23D14146E5; ALTER TABLE tl_lasurv11_question ADD CONSTRAINT FK872D4F23D14146E5 FOREIGN KEY (`survey_uid`) REFERENCES `tl_lasurv11_survey` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lasurv11_question DROP FOREIGN KEY FK872D4F23E4C99A5F; +ALTER IGNORE TABLE tl_lasurv11_question DROP FOREIGN KEY FK872D4F23E4C99A5F; ALTER TABLE tl_lasurv11_question ADD CONSTRAINT FK872D4F23E4C99A5F FOREIGN KEY (`create_by`) REFERENCES `tl_lasurv11_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lasurv11_session DROP FOREIGN KEY FKF08793B9D14146E5; +ALTER IGNORE TABLE tl_lasurv11_session DROP FOREIGN KEY FKF08793B9D14146E5; ALTER TABLE tl_lasurv11_session ADD CONSTRAINT FKF08793B9D14146E5 FOREIGN KEY (`survey_uid`) REFERENCES `tl_lasurv11_survey` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lasurv11_survey DROP FOREIGN KEY FK8CC465D7E4C99A5F; +ALTER IGNORE TABLE tl_lasurv11_survey DROP FOREIGN KEY FK8CC465D7E4C99A5F; ALTER TABLE tl_lasurv11_survey ADD CONSTRAINT FK8CC465D7E4C99A5F FOREIGN KEY (`create_by`) REFERENCES `tl_lasurv11_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lasurv11_user DROP FOREIGN KEY FK633F25884F803F63; +ALTER IGNORE TABLE tl_lasurv11_user DROP FOREIGN KEY FK633F25884F803F63; ALTER TABLE tl_lasurv11_user ADD CONSTRAINT FK633F25884F803F63 FOREIGN KEY (`session_uid`) REFERENCES `tl_lasurv11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lasurv11_user DROP FOREIGN KEY FK633F2588D14146E5; +ALTER IGNORE TABLE tl_lasurv11_user DROP FOREIGN KEY FK633F2588D14146E5; ALTER TABLE tl_lasurv11_user ADD CONSTRAINT FK633F2588D14146E5 FOREIGN KEY (`survey_uid`) REFERENCES `tl_lasurv11_survey` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lasurv11_answer DROP FOREIGN KEY FK6DAAFE3BB1423DC1; +ALTER IGNORE TABLE tl_lasurv11_answer DROP FOREIGN KEY FK6DAAFE3BB1423DC1; ALTER TABLE tl_lasurv11_answer ADD CONSTRAINT FK6DAAFE3BB1423DC1 FOREIGN KEY (`user_uid`) REFERENCES `tl_lasurv11_user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lasurv11_answer DROP FOREIGN KEY FK6DAAFE3B25F3BB77; +ALTER IGNORE TABLE tl_lasurv11_answer DROP FOREIGN KEY FK6DAAFE3B25F3BB77; ALTER TABLE tl_lasurv11_answer ADD CONSTRAINT FK6DAAFE3B25F3BB77 FOREIGN KEY (`question_uid`) REFERENCES `tl_lasurv11_question` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_task/src/java/org/lamsfoundation/lams/tool/taskList/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,75 +5,75 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_latask10_condition DROP FOREIGN KEY FK_tl_latask10_condition_1; +ALTER IGNORE TABLE tl_latask10_condition DROP FOREIGN KEY FK_tl_latask10_condition_1; ALTER TABLE tl_latask10_condition ADD CONSTRAINT FK_tl_latask10_condition_1 FOREIGN KEY (`taskList_uid`) REFERENCES `tl_latask10_tasklist` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_latask10_condition_tl_item DROP FOREIGN KEY FK_tl_latask10_tasklist_item_condition_1; +ALTER IGNORE TABLE tl_latask10_condition_tl_item DROP FOREIGN KEY FK_tl_latask10_tasklist_item_condition_1; ALTER TABLE tl_latask10_condition_tl_item ADD CONSTRAINT FK_tl_latask10_tasklist_item_condition_1 FOREIGN KEY (`condition_uid`) REFERENCES `tl_latask10_condition` (`condition_uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_latask10_condition_tl_item DROP FOREIGN KEY FK_tl_latask10_tasklist_item_condition_2; +ALTER IGNORE TABLE tl_latask10_condition_tl_item DROP FOREIGN KEY FK_tl_latask10_tasklist_item_condition_2; ALTER TABLE tl_latask10_condition_tl_item ADD CONSTRAINT FK_tl_latask10_tasklist_item_condition_2 FOREIGN KEY (`uid`) REFERENCES `tl_latask10_tasklist_item` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_latask10_item_attachment DROP FOREIGN KEY FK_tl_latask10_item_attachment_1; +ALTER IGNORE TABLE tl_latask10_item_attachment DROP FOREIGN KEY FK_tl_latask10_item_attachment_1; ALTER TABLE tl_latask10_item_attachment ADD CONSTRAINT FK_tl_latask10_item_attachment_1 FOREIGN KEY (`taskList_item_uid`) REFERENCES `tl_latask10_tasklist_item` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_latask10_item_attachment DROP FOREIGN KEY FK_tl_latask10_item_attachment_2; +ALTER IGNORE TABLE tl_latask10_item_attachment DROP FOREIGN KEY FK_tl_latask10_item_attachment_2; ALTER TABLE tl_latask10_item_attachment ADD CONSTRAINT FK_tl_latask10_item_attachment_2 FOREIGN KEY (`create_by`) REFERENCES `tl_latask10_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_latask10_item_comment DROP FOREIGN KEY FK_tl_latask10_item_comment_2; +ALTER IGNORE TABLE tl_latask10_item_comment DROP FOREIGN KEY FK_tl_latask10_item_comment_2; ALTER TABLE tl_latask10_item_comment ADD CONSTRAINT FK_tl_latask10_item_comment_2 FOREIGN KEY (`create_by`) REFERENCES `tl_latask10_user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_latask10_item_comment DROP FOREIGN KEY FK_tl_latask10_item_comment_3; +ALTER IGNORE TABLE tl_latask10_item_comment DROP FOREIGN KEY FK_tl_latask10_item_comment_3; ALTER TABLE tl_latask10_item_comment ADD CONSTRAINT FK_tl_latask10_item_comment_3 FOREIGN KEY (`taskList_item_uid`) REFERENCES `tl_latask10_tasklist_item` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_latask10_session DROP FOREIGN KEY FK_NEW_174079138_24AA78C530E79035; +ALTER IGNORE TABLE tl_latask10_session DROP FOREIGN KEY FK_NEW_174079138_24AA78C530E79035; ALTER TABLE tl_latask10_session ADD CONSTRAINT FK_NEW_174079138_24AA78C530E79035 FOREIGN KEY (`taskList_uid`) REFERENCES `tl_latask10_tasklist` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_latask10_tasklist DROP FOREIGN KEY FK_NEW_174079138_89093BF758092FB; +ALTER IGNORE TABLE tl_latask10_tasklist DROP FOREIGN KEY FK_NEW_174079138_89093BF758092FB; ALTER TABLE tl_latask10_tasklist ADD CONSTRAINT FK_NEW_174079138_89093BF758092FB FOREIGN KEY (`create_by`) REFERENCES `tl_latask10_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_latask10_tasklist_item DROP FOREIGN KEY FK_NEW_174079138_F52D1F9330E79035; +ALTER IGNORE TABLE tl_latask10_tasklist_item DROP FOREIGN KEY FK_NEW_174079138_F52D1F9330E79035; ALTER TABLE tl_latask10_tasklist_item ADD CONSTRAINT FK_NEW_174079138_F52D1F9330E79035 FOREIGN KEY (`taskList_uid`) REFERENCES `tl_latask10_tasklist` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_latask10_tasklist_item DROP FOREIGN KEY FK_NEW_174079138_F52D1F93758092FB; +ALTER IGNORE TABLE tl_latask10_tasklist_item DROP FOREIGN KEY FK_NEW_174079138_F52D1F93758092FB; ALTER TABLE tl_latask10_tasklist_item ADD CONSTRAINT FK_NEW_174079138_F52D1F93758092FB FOREIGN KEY (`create_by`) REFERENCES `tl_latask10_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_latask10_tasklist_item DROP FOREIGN KEY FK_NEW_174079138_F52D1F93EC0D3147; +ALTER IGNORE TABLE tl_latask10_tasklist_item DROP FOREIGN KEY FK_NEW_174079138_F52D1F93EC0D3147; ALTER TABLE tl_latask10_tasklist_item ADD CONSTRAINT FK_NEW_174079138_F52D1F93EC0D3147 FOREIGN KEY (`session_uid`) REFERENCES `tl_latask10_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_latask10_user DROP FOREIGN KEY FK_NEW_174079138_30113BFCEC0D3147; +ALTER IGNORE TABLE tl_latask10_user DROP FOREIGN KEY FK_NEW_174079138_30113BFCEC0D3147; ALTER TABLE tl_latask10_user ADD CONSTRAINT FK_NEW_174079138_30113BFCEC0D3147 FOREIGN KEY (`session_uid`) REFERENCES `tl_latask10_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_latask10_user DROP FOREIGN KEY FK_NEW_174079138_30113BFC309ED320; +ALTER IGNORE TABLE tl_latask10_user DROP FOREIGN KEY FK_NEW_174079138_30113BFC309ED320; ALTER TABLE tl_latask10_user ADD CONSTRAINT FK_NEW_174079138_30113BFC309ED320 FOREIGN KEY (`taskList_uid`) REFERENCES `tl_latask10_tasklist` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_latask10_item_log DROP FOREIGN KEY FK_NEW_174079138_693580A441F9365D; +ALTER IGNORE TABLE tl_latask10_item_log DROP FOREIGN KEY FK_NEW_174079138_693580A441F9365D; ALTER TABLE tl_latask10_item_log ADD CONSTRAINT FK_NEW_174079138_693580A441F9365D FOREIGN KEY (`user_uid`) REFERENCES `tl_latask10_user` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_latask10_item_log DROP FOREIGN KEY FK_NEW_174079138_693580A438BF8DFE; +ALTER IGNORE TABLE tl_latask10_item_log DROP FOREIGN KEY FK_NEW_174079138_693580A438BF8DFE; ALTER TABLE tl_latask10_item_log ADD CONSTRAINT FK_NEW_174079138_693580A438BF8DFE FOREIGN KEY (`taskList_item_uid`) REFERENCES `tl_latask10_tasklist_item` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_videorecorder/src/java/org/lamsfoundation/lams/tool/videoRecorder/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_videorecorder/src/java/org/lamsfoundation/lams/tool/videoRecorder/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_videorecorder/src/java/org/lamsfoundation/lams/tool/videoRecorder/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,11 +5,11 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lavidr10_session DROP FOREIGN KEY FK_NEW_75587508_B7C198E2FC940906; +ALTER IGNORE TABLE tl_lavidr10_session DROP FOREIGN KEY FK_NEW_75587508_B7C198E2FC940906; ALTER TABLE tl_lavidr10_session ADD CONSTRAINT FK_NEW_75587508_B7C198E2FC940906 FOREIGN KEY (`videoRecorder_uid`) REFERENCES `tl_lavidr10_videorecorder` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lavidr10_user DROP FOREIGN KEY FK_NEW_75587508_CB8A58FFA3B0FADF; +ALTER IGNORE TABLE tl_lavidr10_user DROP FOREIGN KEY FK_NEW_75587508_CB8A58FFA3B0FADF; ALTER TABLE tl_lavidr10_user ADD CONSTRAINT FK_NEW_75587508_CB8A58FFA3B0FADF FOREIGN KEY (`videoRecorder_session_uid`) REFERENCES `tl_lavidr10_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; Index: lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_vote/src/java/org/lamsfoundation/lams/tool/vote/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,26 +5,26 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lavote11_nomination_content DROP FOREIGN KEY FK_tl_lavote11_nomination_content_1; +ALTER IGNORE TABLE tl_lavote11_nomination_content DROP FOREIGN KEY FK_tl_lavote11_nomination_content_1; ALTER TABLE tl_lavote11_nomination_content ADD CONSTRAINT FK_tl_lavote11_nomination_content_1 FOREIGN KEY (`vote_content_id`) REFERENCES `tl_lavote11_content` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lavote11_usr DROP FOREIGN KEY FK_tl_lavote11_usr_1; +ALTER IGNORE TABLE tl_lavote11_usr DROP FOREIGN KEY FK_tl_lavote11_usr_1; ALTER TABLE tl_lavote11_usr ADD CONSTRAINT FK_tl_lavote11_usr_1 FOREIGN KEY (`vote_session_id`) REFERENCES `tl_lavote11_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lavote11_session DROP FOREIGN KEY FK_tl_lavote11_session_1; +ALTER IGNORE TABLE tl_lavote11_session DROP FOREIGN KEY FK_tl_lavote11_session_1; ALTER TABLE tl_lavote11_session ADD CONSTRAINT FK_tl_lavote11_session_1 FOREIGN KEY (`vote_content_id`) REFERENCES `tl_lavote11_content` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lavote11_usr_attempt DROP FOREIGN KEY FK_tl_lavote11_usr_attempt_2; +ALTER IGNORE TABLE tl_lavote11_usr_attempt DROP FOREIGN KEY FK_tl_lavote11_usr_attempt_2; ALTER TABLE tl_lavote11_usr_attempt ADD CONSTRAINT FK_tl_lavote11_usr_attempt_2 FOREIGN KEY (`que_usr_id`) REFERENCES `tl_lavote11_usr` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lavote11_usr_attempt DROP FOREIGN KEY FK_tl_lavote11_usr_attempt_3; +ALTER IGNORE TABLE tl_lavote11_usr_attempt DROP FOREIGN KEY FK_tl_lavote11_usr_attempt_3; ALTER TABLE tl_lavote11_usr_attempt ADD CONSTRAINT FK_tl_lavote11_usr_attempt_3 FOREIGN KEY (`vote_nomination_content_id`) REFERENCES `tl_lavote11_nomination_content` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -- This has to be added as Hibernate is not aware of the cascade Index: lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_wiki/src/java/org/lamsfoundation/lams/tool/wiki/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,47 +5,47 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lawiki10_session DROP FOREIGN KEY FKF01D63C260B3B03B; +ALTER IGNORE TABLE tl_lawiki10_session DROP FOREIGN KEY FKF01D63C260B3B03B; ALTER TABLE tl_lawiki10_session ADD CONSTRAINT FKF01D63C260B3B03B FOREIGN KEY (`wiki_uid`) REFERENCES `tl_lawiki10_wiki` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lawiki10_session DROP FOREIGN KEY FKF01D63C2A3FF7EC0; +ALTER IGNORE TABLE tl_lawiki10_session DROP FOREIGN KEY FKF01D63C2A3FF7EC0; ALTER TABLE tl_lawiki10_session ADD CONSTRAINT FKF01D63C2A3FF7EC0 FOREIGN KEY (`wiki_main_page_uid`) REFERENCES `tl_lawiki10_wiki_page` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lawiki10_user DROP FOREIGN KEY FKED5D7A1FD8004954; +ALTER IGNORE TABLE tl_lawiki10_user DROP FOREIGN KEY FKED5D7A1FD8004954; ALTER TABLE tl_lawiki10_user ADD CONSTRAINT FKED5D7A1FD8004954 FOREIGN KEY (`wiki_session_uid`) REFERENCES `tl_lawiki10_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lawiki10_wiki DROP FOREIGN KEY FKED5E3E04A3FF7EC0; +ALTER IGNORE TABLE tl_lawiki10_wiki DROP FOREIGN KEY FKED5E3E04A3FF7EC0; ALTER TABLE tl_lawiki10_wiki ADD CONSTRAINT FKED5E3E04A3FF7EC0 FOREIGN KEY (`wiki_main_page_uid`) REFERENCES `tl_lawiki10_wiki_page` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lawiki10_wiki_page DROP FOREIGN KEY wiki_page_fk_1; +ALTER IGNORE TABLE tl_lawiki10_wiki_page DROP FOREIGN KEY wiki_page_fk_1; ALTER TABLE tl_lawiki10_wiki_page ADD CONSTRAINT wiki_page_fk_1 FOREIGN KEY (`wiki_session_uid`) REFERENCES `tl_lawiki10_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lawiki10_wiki_page DROP FOREIGN KEY wiki_page_fk_2; +ALTER IGNORE TABLE tl_lawiki10_wiki_page DROP FOREIGN KEY wiki_page_fk_2; ALTER TABLE tl_lawiki10_wiki_page ADD CONSTRAINT wiki_page_fk_2 FOREIGN KEY (`wiki_uid`) REFERENCES `tl_lawiki10_wiki` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lawiki10_wiki_page DROP FOREIGN KEY wiki_page_fk_3; +ALTER IGNORE TABLE tl_lawiki10_wiki_page DROP FOREIGN KEY wiki_page_fk_3; ALTER TABLE tl_lawiki10_wiki_page ADD CONSTRAINT wiki_page_fk_3 FOREIGN KEY (`added_by`) REFERENCES `tl_lawiki10_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lawiki10_wiki_page DROP FOREIGN KEY wiki_page_fk_4; +ALTER IGNORE TABLE tl_lawiki10_wiki_page DROP FOREIGN KEY wiki_page_fk_4; ALTER TABLE tl_lawiki10_wiki_page ADD CONSTRAINT wiki_page_fk_4 FOREIGN KEY (`wiki_current_content`) REFERENCES `tl_lawiki10_wiki_page_content` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; -ALTER TABLE tl_lawiki10_wiki_page_content DROP FOREIGN KEY FK528051242D44CCF8; +ALTER IGNORE TABLE tl_lawiki10_wiki_page_content DROP FOREIGN KEY FK528051242D44CCF8; ALTER TABLE tl_lawiki10_wiki_page_content ADD CONSTRAINT FK528051242D44CCF8 FOREIGN KEY (`wiki_page_uid`) REFERENCES `tl_lawiki10_wiki_page` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lawiki10_wiki_page_content DROP FOREIGN KEY FK528051243233D952; +ALTER IGNORE TABLE tl_lawiki10_wiki_page_content DROP FOREIGN KEY FK528051243233D952; ALTER TABLE tl_lawiki10_wiki_page_content ADD CONSTRAINT FK528051243233D952 FOREIGN KEY (`editor`) REFERENCES `tl_lawiki10_user` (`uid`) ON DELETE SET NULL ON UPDATE CASCADE; Index: lams_tool_wookie/src/java/org/lamsfoundation/lams/tool/wookie/dbupdates/patch20151217.sql =================================================================== diff -u -r74f12ddbbd6da766332b8fc63b7a45e431679080 -r1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed --- lams_tool_wookie/src/java/org/lamsfoundation/lams/tool/wookie/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 74f12ddbbd6da766332b8fc63b7a45e431679080) +++ lams_tool_wookie/src/java/org/lamsfoundation/lams/tool/wookie/dbupdates/patch20151217.sql (.../patch20151217.sql) (revision 1cda4ddcf7266f3e189002f48b4bcd32a7bfc6ed) @@ -5,11 +5,11 @@ -- LDEV-3640 Add necessary cascades -ALTER TABLE tl_lawook10_session DROP FOREIGN KEY FK_WOOKIE_SESSION; +ALTER IGNORE TABLE tl_lawook10_session DROP FOREIGN KEY FK_WOOKIE_SESSION; ALTER TABLE tl_lawook10_session ADD CONSTRAINT FK_WOOKIE_SESSION FOREIGN KEY (`wookie_uid`) REFERENCES `tl_lawook10_wookie` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE; -ALTER TABLE tl_lawook10_user DROP FOREIGN KEY FK_WOOKIE_USER; +ALTER IGNORE TABLE tl_lawook10_user DROP FOREIGN KEY FK_WOOKIE_USER; ALTER TABLE tl_lawook10_user ADD CONSTRAINT FK_WOOKIE_USER FOREIGN KEY (`wookie_session_uid`) REFERENCES `tl_lawook10_session` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE;