Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql,v diff -u -r1.1.2.5 -r1.1.2.6 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql 8 May 2011 11:06:22 -0000 1.1.2.5 +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql 23 Jun 2011 02:01:45 -0000 1.1.2.6 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20110217_updateTo236.sql,v diff -u -r1.1.2.5 -r1.1.2.6 --- lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20110217_updateTo236.sql 8 May 2011 10:38:43 -0000 1.1.2.5 +++ lams_tool_laqa/src/java/org/lamsfoundation/lams/tool/qa/dbupdates/patch20110217_updateTo236.sql 23 Jun 2011 02:02:42 -0000 1.1.2.6 @@ -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