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.4 -r1.5 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql 23 Jun 2011 01:53:54 -0000 1.4 +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql 17 Feb 2012 12:18:30 -0000 1.5 @@ -25,14 +25,9 @@ UPDATE lams_tool SET tool_version = "20110228" WHERE tool_signature = "lafrum11"; --- LDEV-2657 -alter table tl_lafrum11_forum add column submission_deadline datetime default null; - -UPDATE lams_tool SET tool_version = "20110408" WHERE tool_signature = "lafrum11"; - ----------------------Put all sql statements above here------------------------- -- If there were no errors, commit and restore autocommit to on COMMIT; SET AUTOCOMMIT = 1; - SET FOREIGN_KEY_CHECKS = 1; \ No newline at end of file + SET FOREIGN_KEY_CHECKS = 1; Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110408_updateTo236.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110408_updateTo236.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110408_updateTo236.sql 17 Feb 2012 12:18:30 -0000 1.1 @@ -0,0 +1,19 @@ + +-- SQL statements to update to LAMS 2.3.6 + +-- 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------------------------- + +-- LDEV-2657 +alter table tl_lafrum11_forum add column submission_deadline datetime default null; + +UPDATE lams_tool SET tool_version = "20110408" WHERE tool_signature = "lafrum11"; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; + SET FOREIGN_KEY_CHECKS = 1;