Index: lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081022_updateFrom21.sql
===================================================================
diff -u -r667583f574672f48a6777c6d3e7e0f6b7a06d3f7 -r59550921a627a4ca6f9b83cdff15082656c140b1
--- lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081022_updateFrom21.sql	(.../patch20081022_updateFrom21.sql)	(revision 667583f574672f48a6777c6d3e7e0f6b7a06d3f7)
+++ lams_tool_forum/src/java/org/lamsfoundation/lams/tool/forum/dbupdates/patch20081022_updateFrom21.sql	(.../patch20081022_updateFrom21.sql)	(revision 59550921a627a4ca6f9b83cdff15082656c140b1)
@@ -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
===================================================================
diff -u -rf7c130109254ea187c148bdd7270455130c2f8a1 -r59550921a627a4ca6f9b83cdff15082656c140b1
--- lams_tool_larsrc/build.properties	(.../build.properties)	(revision f7c130109254ea187c148bdd7270455130c2f8a1)
+++ lams_tool_larsrc/build.properties	(.../build.properties)	(revision 59550921a627a4ca6f9b83cdff15082656c140b1)
@@ -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
===================================================================
diff -u
--- lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20081107_updateFrom21.sql	(revision 0)
+++ lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20081107_updateFrom21.sql	(revision 59550921a627a4ca6f9b83cdff15082656c140b1)
@@ -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
===================================================================
diff -u -r5442c61bdf4d3ddafc69c7ff497be6c1a9a40db5 -r59550921a627a4ca6f9b83cdff15082656c140b1
--- lams_tool_sbmt/build.properties	(.../build.properties)	(revision 5442c61bdf4d3ddafc69c7ff497be6c1a9a40db5)
+++ lams_tool_sbmt/build.properties	(.../build.properties)	(revision 59550921a627a4ca6f9b83cdff15082656c140b1)
@@ -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
===================================================================
diff -u
--- lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20081107_updateFrom21.sql	(revision 0)
+++ lams_tool_sbmt/src/java/org/lamsfoundation/lams/tool/sbmt/dbupdates/patch20081107_updateFrom21.sql	(revision 59550921a627a4ca6f9b83cdff15082656c140b1)
@@ -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
===================================================================
diff -u -r667583f574672f48a6777c6d3e7e0f6b7a06d3f7 -r59550921a627a4ca6f9b83cdff15082656c140b1
--- lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql	(.../patch20081021_updateFrom21.sql)	(revision 667583f574672f48a6777c6d3e7e0f6b7a06d3f7)
+++ lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/dbupdates/patch20081021_updateFrom21.sql	(.../patch20081021_updateFrom21.sql)	(revision 59550921a627a4ca6f9b83cdff15082656c140b1)
@@ -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