Index: lams_tool_chat/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_chat/build.xml,v
diff -u -r1.19 -r1.20
--- lams_tool_chat/build.xml	15 Feb 2007 01:13:00 -0000	1.19
+++ lams_tool_chat/build.xml	15 Feb 2007 04:47:34 -0000	1.20
@@ -361,6 +361,12 @@
 				<filter token="tool_version" value="${tool.version}" />
 			</filterset>
 		</copy>
+		
+		<copy overwrite="yes" todir="${build.deploy}/sql/updatescripts" failonerror="false">
+			<fileset dir="${db.scripts}/updatescripts/">
+				<include name="*.sql" />
+			</fileset>
+		</copy>
 
 		<copy overwrite="yes" todir="${build.deploy}/">
 			<fileset dir="${deploy.tool.dir}">
@@ -405,7 +411,7 @@
 			toolVersion="${tool.version}"
 			hideTool="${hideTool}"
 			minServerVersionNumber="${min.server.version.number}"
-			toolUpdateScriptPath="${build.deploy}/sql/updateTo${tool.version}.sql"
+			toolUpdateScriptPath="${build.deploy}/sql/updatescripts/updateTo${tool.version}.sql"
 			toolTablesScriptPath="${build.deploy}/sql/create_lams_tool_chat.sql" 
 			toolTablesDeleteScriptPath="${build.deploy}/sql/drop_lams_tool_chat.sql" 
 			toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" 
Index: lams_tool_example/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_example/build.xml,v
diff -u -r1.14 -r1.15
--- lams_tool_example/build.xml	15 Feb 2007 01:13:18 -0000	1.14
+++ lams_tool_example/build.xml	15 Feb 2007 04:47:39 -0000	1.15
@@ -306,13 +306,19 @@
 				</copy>
 			
 				<copy overwrite="yes" todir="${build.deploy}/sql">
-								<fileset dir="${db.scripts}/">
-									<include name="tool_insert.sql" />
-								</fileset>	
-								<filterset>
-									<filter token="tool_version" value="${tool.version}" />
-								</filterset>
+					<fileset dir="${db.scripts}/">
+						<include name="tool_insert.sql" />
+					</fileset>	
+					<filterset>
+						<filter token="tool_version" value="${tool.version}" />
+					</filterset>
 				</copy>
+			
+				<copy overwrite="yes" todir="${build.deploy}/sql/updatescripts" failonerror="false">
+					<fileset dir="${db.scripts}/updatescripts/">
+						<include name="*.sql" />
+					</fileset>
+				</copy>
 
 				<copy overwrite="yes" todir="${build.deploy}/">
 					<fileset dir="${deploy.tool.dir}">
@@ -357,7 +363,7 @@
 					toolVersion="${tool.version}"
 					hideTool="${hideTool}"
 					minServerVersionNumber="${min.server.version.number}"
-					toolUpdateScriptPath="${build.deploy}/sql/updateTo${tool.version}.sql"
+					toolUpdateScriptPath="${build.deploy}/sql/updatescripts/updateTo${tool.version}.sql"
 					toolTablesScriptPath="${build.deploy}/sql/create_lams_tool_example.sql" 
 					toolTablesDeleteScriptPath="${build.deploy}/sql/drop_lams_tool_example.sql" 
 					toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" 
Index: lams_tool_forum/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_forum/build.xml,v
diff -u -r1.50 -r1.51
--- lams_tool_forum/build.xml	15 Feb 2007 01:13:03 -0000	1.50
+++ lams_tool_forum/build.xml	15 Feb 2007 04:47:45 -0000	1.51
@@ -334,6 +334,12 @@
 			</filterset>
 		</copy>
 		
+		<copy overwrite="yes" todir="${build.deploy}/sql/updatescripts" failonerror="false">
+			<fileset dir="${db.scripts}/updatescripts/">
+				<include name="*.sql" />
+			</fileset>
+		</copy>
+		
 		<copy overwrite="yes" todir="${build.deploy}/">
 			<fileset dir="${deploy.tool.dir}">
 				<include name="*.*"/>
@@ -378,7 +384,7 @@
 			toolVersion="${tool.version}"
 			hideTool="${hideTool}"
 			minServerVersionNumber="${min.server.version.number}"
-			toolUpdateScriptPath="${build.deploy}/sql/updateTo${tool.version}.sql"
+			toolUpdateScriptPath="${build.deploy}/sql/updatescripts/updateTo${tool.version}.sql"
 			toolTablesScriptPath="${build.deploy}/sql/create_lams_tool_forum.sql" 
 			toolTablesDeleteScriptPath="${build.deploy}/sql/drop_lams_tool_forum.sql" 
 			toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" 
Index: lams_tool_lamc/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_lamc/build.xml,v
diff -u -r1.40 -r1.41
--- lams_tool_lamc/build.xml	15 Feb 2007 01:13:01 -0000	1.40
+++ lams_tool_lamc/build.xml	15 Feb 2007 04:47:36 -0000	1.41
@@ -331,13 +331,19 @@
 			</copy>
 			
 			<copy overwrite="yes" todir="${build.deploy}/sql">
-								<fileset dir="${db.scripts}/">
-									<include name="tool_insert.sql" />
-								</fileset>	
-								<filterset>
-									<filter token="tool_version" value="${tool.version}" />
-								</filterset>
+				<fileset dir="${db.scripts}/">
+					<include name="tool_insert.sql" />
+				</fileset>	
+				<filterset>
+					<filter token="tool_version" value="${tool.version}" />
+				</filterset>
 			</copy>
+			
+			<copy overwrite="yes" todir="${build.deploy}/sql/updatescripts" failonerror="false">
+				<fileset dir="${db.scripts}/updatescripts/">
+					<include name="*.sql" />
+				</fileset>
+			</copy>
 
 			<copy overwrite="yes" todir="${build.deploy}/">
 				<fileset dir="${deploy.tool.dir}">
@@ -382,7 +388,7 @@
 				toolVersion="${tool.version}"
 				hideTool="${hideTool}"
 				minServerVersionNumber="${min.server.version.number}"
-				toolUpdateScriptPath="${build.deploy}/sql/updateTo${tool.version}.sql"
+				toolUpdateScriptPath="${build.deploy}/sql/updatescripts/updateTo${tool.version}.sql"
 				toolTablesScriptPath="${build.deploy}/sql/create_lams_tool_mc.sql" 
 				toolTablesDeleteScriptPath="${build.deploy}/sql/drop_lams_tool_mc.sql" 
 				toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" 
Index: lams_tool_laqa/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_laqa/build.xml,v
diff -u -r1.40 -r1.41
--- lams_tool_laqa/build.xml	15 Feb 2007 01:13:04 -0000	1.40
+++ lams_tool_laqa/build.xml	15 Feb 2007 04:47:46 -0000	1.41
@@ -324,13 +324,19 @@
 			</copy>
 			
 			<copy overwrite="yes" todir="${build.deploy}/sql">
-								<fileset dir="${db.scripts}/">
-									<include name="tool_insert.sql" />
-								</fileset>	
-								<filterset>
-									<filter token="tool_version" value="${tool.version}" />
-								</filterset>
+				<fileset dir="${db.scripts}/">
+					<include name="tool_insert.sql" />
+				</fileset>	
+				<filterset>
+					<filter token="tool_version" value="${tool.version}" />
+				</filterset>
 			</copy>
+			
+			<copy overwrite="yes" todir="${build.deploy}/sql/updatescripts" failonerror="false">
+				<fileset dir="${db.scripts}/updatescripts/">
+					<include name="*.sql" />
+				</fileset>
+			</copy>
 
 			<copy overwrite="yes" todir="${build.deploy}/">
 				<fileset dir="${deploy.tool.dir}">
@@ -375,7 +381,7 @@
 				toolVersion="${tool.version}"
 				hideTool="${hideTool}"
 				minServerVersionNumber="${min.server.version.number}"
-				toolUpdateScriptPath="${build.deploy}/sql/updateTo${tool.version}.sql"
+				toolUpdateScriptPath="${build.deploy}/sql/updatescripts/updateTo${tool.version}.sql"
 				toolTablesScriptPath="${build.deploy}/sql/create_lams_tool_qa.sql" 
 				toolTablesDeleteScriptPath="${build.deploy}/sql/drop_lams_tool_qa.sql" 
 				toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" 
Index: lams_tool_larsrc/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_larsrc/build.xml,v
diff -u -r1.20 -r1.21
--- lams_tool_larsrc/build.xml	15 Feb 2007 01:12:58 -0000	1.20
+++ lams_tool_larsrc/build.xml	15 Feb 2007 04:47:27 -0000	1.21
@@ -342,6 +342,12 @@
 			</filterset>
 		</copy>
 
+		<copy overwrite="yes" todir="${build.deploy}/sql/updatescripts" failonerror="false">
+			<fileset dir="${db.scripts}/updatescripts/">
+				<include name="*.sql" />
+			</fileset>
+		</copy>
+		
 		<copy overwrite="yes" todir="${build.deploy}/">
 			<fileset dir="${deploy.tool.dir}">
 				<include name="*.*"/>
@@ -385,7 +391,7 @@
 			toolVersion="${tool.version}"
 			hideTool="${hideTool}"
 			minServerVersionNumber="${min.server.version.number}"
-			toolUpdateScriptPath="${build.deploy}/sql/updateTo${tool.version}.sql"
+			toolUpdateScriptPath="${build.deploy}/sql/updatescripts/updateTo${tool.version}.sql"
 			toolTablesScriptPath="${build.deploy}/sql/create_lams_tool_rsrc.sql" 
 			toolTablesDeleteScriptPath="${build.deploy}/sql/drop_lams_tool_rsrc.sql" 
 			toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" 
Index: lams_tool_nb/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/build.xml,v
diff -u -r1.36 -r1.37
--- lams_tool_nb/build.xml	15 Feb 2007 01:12:59 -0000	1.36
+++ lams_tool_nb/build.xml	15 Feb 2007 04:47:33 -0000	1.37
@@ -414,6 +414,12 @@
 							<filter token="tool_version" value="${tool.version}" />
 						</filterset>
 				</copy>
+			
+				<copy overwrite="yes" todir="${build.deploy}/sql/updatescripts" failonerror="false">
+					<fileset dir="${db.scripts}/updatescripts/">
+						<include name="*.sql" />
+					</fileset>
+				</copy>
 
 				<copy overwrite="yes" todir="${build.deploy}/">
 					<fileset dir="${deploy.tool.dir}">
@@ -458,7 +464,7 @@
 					toolVersion="${tool.version}"
 					hideTool="${hideTool}"
 					minServerVersionNumber="${min.server.version.number}"
-					toolUpdateScriptPath="${build.deploy}/sql/updateTo${tool.version}.sql"
+					toolUpdateScriptPath="${build.deploy}/sql/updatescripts/updateTo${tool.version}.sql"
 					toolTablesScriptPath="${build.deploy}/sql/create_lams_tool_nb.sql" 
 					toolTablesDeleteScriptPath="${build.deploy}/sql/drop_lams_tool_nb.sql" 
 					toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" 
Index: lams_tool_notebook/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_notebook/build.xml,v
diff -u -r1.10 -r1.11
--- lams_tool_notebook/build.xml	15 Feb 2007 01:13:01 -0000	1.10
+++ lams_tool_notebook/build.xml	15 Feb 2007 04:47:37 -0000	1.11
@@ -361,6 +361,12 @@
 				<filter token="tool_version" value="${tool.version}" />
 			</filterset>
 		</copy>
+		
+		<copy overwrite="yes" todir="${build.deploy}/sql/updatescripts" failonerror="false">
+			<fileset dir="${db.scripts}/updatescripts/">
+				<include name="*.sql" />
+			</fileset>
+		</copy>
 
 		<copy overwrite="yes" todir="${build.deploy}/">
 			<fileset dir="${deploy.tool.dir}">
Index: lams_tool_sbmt/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_sbmt/build.xml,v
diff -u -r1.43 -r1.44
--- lams_tool_sbmt/build.xml	15 Feb 2007 01:13:02 -0000	1.43
+++ lams_tool_sbmt/build.xml	15 Feb 2007 04:47:41 -0000	1.44
@@ -361,6 +361,12 @@
 				<filter token="tool_version" value="${tool.version}" />
 			</filterset>
 		</copy>
+		
+		<copy overwrite="yes" todir="${build.deploy}/sql/updatescripts" failonerror="false">
+			<fileset dir="${db.scripts}/updatescripts/">
+				<include name="*.sql" />
+			</fileset>
+		</copy>
 
 		<copy overwrite="yes" todir="${build.deploy}/">
 			<fileset dir="${deploy.tool.dir}">
@@ -405,7 +411,7 @@
 			toolVersion="${tool.version}"
 			hideTool="${hideTool}"
 			minServerVersionNumber="${min.server.version.number}"
-			toolUpdateScriptPath="${build.deploy}/sql/updateTo${tool.version}.sql"
+			toolUpdateScriptPath="${build.deploy}/sql/updatescripts/updateTo${tool.version}.sql"
 			toolTablesScriptPath="${build.deploy}/sql/create_lams_tool_sbmt.sql" 
 			toolTablesDeleteScriptPath="${build.deploy}/sql/drop_lams_tool_sbmt.sql" 
 			toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" 
Index: lams_tool_survey/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_survey/build.xml,v
diff -u -r1.11 -r1.12
--- lams_tool_survey/build.xml	15 Feb 2007 01:13:03 -0000	1.11
+++ lams_tool_survey/build.xml	15 Feb 2007 04:47:43 -0000	1.12
@@ -332,6 +332,12 @@
 				<filter token="tool_version" value="${tool.version}" />
 			</filterset>
 		</copy>
+		
+		<copy overwrite="yes" todir="${build.deploy}/sql/updatescripts" failonerror="false">
+			<fileset dir="${db.scripts}/updatescripts/">
+				<include name="*.sql" />
+			</fileset>
+		</copy>
 
 		<copy overwrite="yes" todir="${build.deploy}/">
 			<fileset dir="${deploy.tool.dir}">
@@ -376,7 +382,7 @@
 			toolVersion="${tool.version}"
 			hideTool="${hideTool}"
 			minServerVersionNumber="${min.server.version.number}"
-			toolUpdateScriptPath="${build.deploy}/sql/updateTo${tool.version}.sql"
+			toolUpdateScriptPath="${build.deploy}/sql/updatescripts/updateTo${tool.version}.sql"
 			toolTablesScriptPath="${build.deploy}/sql/create_lams_tool_survey.sql" 
 			toolTablesDeleteScriptPath="${build.deploy}/sql/drop_lams_tool_survey.sql" 
 			toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql" 
Index: lams_tool_vote/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_vote/build.xml,v
diff -u -r1.16 -r1.17
--- lams_tool_vote/build.xml	15 Feb 2007 01:13:02 -0000	1.16
+++ lams_tool_vote/build.xml	15 Feb 2007 04:47:40 -0000	1.17
@@ -366,6 +366,12 @@
 					<filter token="tool_version" value="${tool.version}" />
 				</filterset>
 			</copy>
+			
+			<copy overwrite="yes" todir="${build.deploy}/sql/updatescripts" failonerror="false">
+				<fileset dir="${db.scripts}/updatescripts/">
+					<include name="*.sql" />
+				</fileset>
+			</copy>
 
 			<copy overwrite="yes" todir="${build.deploy}/">
 				<fileset dir="${deploy.tool.dir}">
@@ -410,7 +416,7 @@
 				toolVersion="${tool.version}"
 				hideTool="${hideTool}"
 				minServerVersionNumber="${min.server.version.number}"
-				toolUpdateScriptPath="${build.deploy}/sql/updateTo${tool.version}.sql"
+				toolUpdateScriptPath="${build.deploy}/sql/updatescripts/updateTo${tool.version}.sql"
 				toolTablesScriptPath="${build.deploy}/sql/create_lams_tool_vote.sql" 
 				toolTablesDeleteScriptPath="${build.deploy}/sql/drop_lams_tool_vote.sql" 
 				toolActivityInsertScriptPath="${build.deploy}/sql/activity_insert.sql"