Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081022_updateFrom21.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081022_updateFrom21.sql,v diff -u -r1.2 -r1.3 --- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081022_updateFrom21.sql 6 Nov 2008 23:52:43 -0000 1.2 +++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081022_updateFrom21.sql 7 Nov 2008 01:38:31 -0000 1.3 @@ -25,6 +25,7 @@ REFERENCES tl_lafrum11_message(uid) ON DELETE CASCADE ON UPDATE CASCADE )TYPE=InnoDB; +ALTER TABLE tl_lafrum11_forum ADD COLUMN mark_release_notify tinyint DEFAULT 0; ----------------------Put all sql statements above here------------------------- -- If there were no errors, commit and restore autocommit to on Index: lams_tool_larsrc/build.properties =================================================================== RCS file: /usr/local/cvsroot/lams_tool_larsrc/build.properties,v diff -u -r1.12 -r1.13 --- lams_tool_larsrc/build.properties 3 Mar 2008 04:05:47 -0000 1.12 +++ lams_tool_larsrc/build.properties 7 Nov 2008 01:38:29 -0000 1.13 @@ -13,7 +13,7 @@ weblib=lib #project version -tool.version=20080229 +tool.version=20081107 # hide tool option hideTool=false Index: lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20081107_updateFrom21.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20081107_updateFrom21.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20081107_updateFrom21.sql 7 Nov 2008 01:38:29 -0000 1.1 @@ -0,0 +1,14 @@ +-- SQL statements to update from LAMS 2.1/2.1.1 + +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; + +----------------------Put all sql statements below here------------------------- + +ALTER TABLE tl_larsrc11_resource ADD COLUMN assigment_submit_notify tinyint DEFAULT 0; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; \ No newline at end of file Index: lams_tool_sbmt/build.properties =================================================================== RCS file: /usr/local/cvsroot/lams_tool_sbmt/build.properties,v diff -u -r1.20 -r1.21 --- lams_tool_sbmt/build.properties 13 May 2008 00:57:21 -0000 1.20 +++ lams_tool_sbmt/build.properties 7 Nov 2008 01:38:30 -0000 1.21 @@ -8,7 +8,7 @@ signature=lasbmt11 #project version -tool.version=20080509 +tool.version=20081107 # Minimum compatible version min.server.version.number=2.0.3 Index: lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20081107_updateFrom21.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20081107_updateFrom21.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20081107_updateFrom21.sql 7 Nov 2008 01:38:30 -0000 1.1 @@ -0,0 +1,15 @@ +-- SQL statements to update from LAMS 2.1/2.1.1 + +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; + +----------------------Put all sql statements below here------------------------- + +ALTER TABLE tl_lasbmt11_content ADD COLUMN mark_release_notify tinyint DEFAULT 0; +ALTER TABLE tl_lasbmt11_content ADD COLUMN file_submit_notify tinyint DEFAULT 0; + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; \ No newline at end of file Index: lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql =================================================================== RCS file: /usr/local/cvsroot/lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql,v diff -u -r1.2 -r1.3 --- lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql 6 Nov 2008 23:52:44 -0000 1.2 +++ lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql 7 Nov 2008 01:38:29 -0000 1.3 @@ -27,6 +27,7 @@ UPDATE lams_tool SET supports_outputs=1 WHERE tool_signature='lasurv11'; +ALTER TABLE tl_lasurv11_survey ADD COLUMN answer_submit_notify tinyint DEFAULT 0; ----------------------Put all sql statements above here------------------------- -- If there were no errors, commit and restore autocommit to on