Index: lams_tool_laqa/db/sql/updatescripts/updateTo20080108.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_laqa/db/sql/updatescripts/Attic/updateTo20080108.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ lams_tool_laqa/db/sql/updatescripts/updateTo20080108.sql	8 Jan 2008 01:32:54 -0000	1.1
@@ -0,0 +1,16 @@
+-- Update the Q&A tables to version 20080108
+-- This is for the LAMS 2.1 release.
+
+UPDATE tl_laqa11_content 
+SET lockWhenFinished = 0 
+WHERE qa_content_id = (
+	SELECT default_tool_content_id 
+	FROM lams_tool
+	WHERE tool_signature = 'laqa11'
+);
+
+UPDATE lams_tool SET modified_date_time = NOW() WHERE tool_signature = 'laqa11';
+
+-- 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 = "20080108" WHERE tool_signature = "laqa11";
Index: lams_tool_vote/db/sql/updatescripts/updateTo20080108.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_vote/db/sql/updatescripts/Attic/updateTo20080108.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ lams_tool_vote/db/sql/updatescripts/updateTo20080108.sql	8 Jan 2008 01:32:54 -0000	1.1
@@ -0,0 +1,16 @@
+-- Update the Vote tables to version 20080108
+-- This is for the LAMS 2.1 release.
+
+UPDATE tl_lavote11_content 
+SET lock_on_finish = 0 
+WHERE content_id = (
+	SELECT default_tool_content_id 
+	FROM lams_tool
+	WHERE tool_signature = 'lavote11'
+);
+
+UPDATE lams_tool SET modified_date_time = NOW() WHERE tool_signature = 'lavote11';
+
+-- 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 = "20080108" WHERE tool_signature = "lavote11";