Index: lams_tool_lamc/db/sql/updatescripts/updateTo20070820.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_lamc/db/sql/updatescripts/Attic/updateTo20070820.sql,v
diff -u -r1.1 -r1.2
--- lams_tool_lamc/db/sql/updatescripts/updateTo20070820.sql	15 Aug 2007 03:56:03 -0000	1.1
+++ lams_tool_lamc/db/sql/updatescripts/updateTo20070820.sql	17 Aug 2007 05:11:09 -0000	1.2
@@ -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