Index: lams_tool_lamc/build.properties
===================================================================
diff -u -rd5c86099c21b0fda847318cb1515fe09bcdf74b4 -r89837538d45d0f73f6c1f22ccbcebbdedb706f8d
--- lams_tool_lamc/build.properties	(.../build.properties)	(revision d5c86099c21b0fda847318cb1515fe09bcdf74b4)
+++ lams_tool_lamc/build.properties	(.../build.properties)	(revision 89837538d45d0f73f6c1f22ccbcebbdedb706f8d)
@@ -4,7 +4,7 @@
 signature=lamc11
 
 #version of this project
-tool.version=20070524
+tool.version=20070820
 
 # hide tool option
 hideTool=false
Index: lams_tool_lamc/db/sql/updatescripts/updateTo20070820.sql
===================================================================
diff -u -rf04e5eaf5a3b6bd01c39426e993609857686d936 -r89837538d45d0f73f6c1f22ccbcebbdedb706f8d
--- lams_tool_lamc/db/sql/updatescripts/updateTo20070820.sql	(.../updateTo20070820.sql)	(revision f04e5eaf5a3b6bd01c39426e993609857686d936)
+++ lams_tool_lamc/db/sql/updatescripts/updateTo20070820.sql	(.../updateTo20070820.sql)	(revision 89837538d45d0f73f6c1f22ccbcebbdedb706f8d)
@@ -22,4 +22,8 @@
 ( select max(attemptOrder) from tl_lamc11_usr_attempt att where att.que_usr_id = qu1.uid );
 
 update tl_lamc11_que_usr qu1 set qu1.last_attempt_total_mark = 
-( select sum(mark) from tl_lamc11_usr_attempt att where att.que_usr_id = qu1.uid and att.attemptOrder = qu1.last_attempt_order);
\ No newline at end of file
+( select sum(mark) from tl_lamc11_usr_attempt att where att.que_usr_id = qu1.uid and att.attemptOrder = qu1.last_attempt_order);
+
+-- update the tool version - special code that should only be executed if the upgrade is being done manually.
+-- if it is being done via the tool deployer then it will update the version automatically.
+-- update lams_tool set tool_version = "20070820" where tool_signature = "lamc11";
\ No newline at end of file