Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql =================================================================== diff -u -r88ac6897c5fcfc58c7d0691d5b1ec9868bbe92a1 -r8aad17797da49be7c1c7c9cbdf3919f8d6bef2eb --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql (.../patch20110228_updateTo236.sql) (revision 88ac6897c5fcfc58c7d0691d5b1ec9868bbe92a1) +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110228_updateTo236.sql (.../patch20110228_updateTo236.sql) (revision 8aad17797da49be7c1c7c9cbdf3919f8d6bef2eb) @@ -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 =================================================================== diff -u --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110408_updateTo236.sql (revision 0) +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20110408_updateTo236.sql (revision 8aad17797da49be7c1c7c9cbdf3919f8d6bef2eb) @@ -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;