Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql =================================================================== diff -u -r8d6cf04ec6c1da33edd6e1299ad87dad81eb3b8d -r88ac6897c5fcfc58c7d0691d5b1ec9868bbe92a1 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql (.../patch20110228_updateTo236.sql) (revision 8d6cf04ec6c1da33edd6e1299ad87dad81eb3b8d) +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql (.../patch20110228_updateTo236.sql) (revision 88ac6897c5fcfc58c7d0691d5b1ec9868bbe92a1) @@ -2,7 +2,7 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; - +SET FOREIGN_KEY_CHECKS = 0; ----------------------Put all sql statements below here------------------------- ALTER TABLE tl_lafrum11_forum ADD COLUMN allow_rate_messages smallint not null default 0; @@ -34,4 +34,5 @@ -- If there were no errors, commit and restore autocommit to on COMMIT; -SET AUTOCOMMIT = 1; \ No newline at end of file +SET AUTOCOMMIT = 1; + SET FOREIGN_KEY_CHECKS = 1; \ No newline at end of file Index: lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20110217_updateTo236.sql =================================================================== diff -u -rcd0b7b82232971e95d54348b03049beb1dfe0ecb -r88ac6897c5fcfc58c7d0691d5b1ec9868bbe92a1 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20110217_updateTo236.sql (.../patch20110217_updateTo236.sql) (revision cd0b7b82232971e95d54348b03049beb1dfe0ecb) +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20110217_updateTo236.sql (.../patch20110217_updateTo236.sql) (revision 88ac6897c5fcfc58c7d0691d5b1ec9868bbe92a1) @@ -2,7 +2,7 @@ -- Turn off autocommit, so nothing is committed if there is an error SET AUTOCOMMIT = 0; - +SET FOREIGN_KEY_CHECKS=0; ----------------------Put all sql statements below here------------------------- ALTER TABLE tl_laqa11_content ADD COLUMN allow_rate_answers TINYINT(1) NOT NULL DEFAULT 0; @@ -34,4 +34,5 @@ -- If there were no errors, commit and restore autocommit to on COMMIT; -SET AUTOCOMMIT = 1; \ No newline at end of file +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file