Index: lams_tool_example/build.xml
===================================================================
diff -u -ra235ec2e0173ec1cdc645a2321500284630ea7f1 -r0b1d9b25bb467095dddfd12e2350a4d261a0306f
--- lams_tool_example/build.xml	(.../build.xml)	(revision a235ec2e0173ec1cdc645a2321500284630ea7f1)
+++ lams_tool_example/build.xml	(.../build.xml)	(revision 0b1d9b25bb467095dddfd12e2350a4d261a0306f)
@@ -347,6 +347,7 @@
 					deployFiles="${build.lib}/${product}.war,${build.lib}/${product}.jar"
 					toolJarFileName="${product}.jar"
 					toolSignature="${signature}"
+					toolVersion="${tool.version}"
 					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_example/db/sql/tool_insert.sql
===================================================================
diff -u -r40529cd9dba723f60bb5b2ae6143638371651625 -r0b1d9b25bb467095dddfd12e2350a4d261a0306f
--- lams_tool_example/db/sql/tool_insert.sql	(.../tool_insert.sql)	(revision 40529cd9dba723f60bb5b2ae6143638371651625)
+++ lams_tool_example/db/sql/tool_insert.sql	(.../tool_insert.sql)	(revision 0b1d9b25bb467095dddfd12e2350a4d261a0306f)
@@ -34,7 +34,7 @@
 'Example',
 'Example',
 'example',
-'20061102',
+'@tool_version@',
 NULL,
 NULL,
 0,
Index: lams_tool_lamc/build.properties
===================================================================
diff -u -r327a30d46eca82ac7c5a3819d74655a2867323c2 -r0b1d9b25bb467095dddfd12e2350a4d261a0306f
--- lams_tool_lamc/build.properties	(.../build.properties)	(revision 327a30d46eca82ac7c5a3819d74655a2867323c2)
+++ lams_tool_lamc/build.properties	(.../build.properties)	(revision 0b1d9b25bb467095dddfd12e2350a4d261a0306f)
@@ -3,6 +3,9 @@
 #name of this project
 signature=lamc11
 
+#version of this project
+tool.version=20061113
+
 #submit files package definition
 mc.package=org.lamsfoundation.lams.tool.mc
 mc.path=org/lamsfoundation/lams/tool/mc
@@ -19,3 +22,4 @@
 
 testweb=${basedir}/test/web
 testwebinf=${testweb}/WEB-INF
+
Index: lams_tool_lamc/build.xml
===================================================================
diff -u -r4fb255fea868033aaa6d97d33efb7b2d7def5ff2 -r0b1d9b25bb467095dddfd12e2350a4d261a0306f
--- lams_tool_lamc/build.xml	(.../build.xml)	(revision 4fb255fea868033aaa6d97d33efb7b2d7def5ff2)
+++ lams_tool_lamc/build.xml	(.../build.xml)	(revision 0b1d9b25bb467095dddfd12e2350a4d261a0306f)
@@ -327,9 +327,17 @@
 					<include name="create_lams_tool_mc.sql"/>
 					<include name="activity_insert.sql"/>
 					<include name="library_insert.sql"/>
-					<include name="tool_insert.sql"/>
 				</fileset>
 			</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>
+			</copy>
 
 			<copy overwrite="yes" todir="${build.deploy}/">
 				<fileset dir="${deploy.tool.dir}">
@@ -364,6 +372,7 @@
 				deployFiles="${build.lib}/${product}.war,${build.lib}/${product}.jar"
 				toolJarFileName="${product}.jar"
 				toolSignature="${signature}"
+				toolVersion="${tool.version}"
 				toolTablesScriptPath="${db.scripts}/create_lams_tool_mc.sql"
 				toolTablesDeleteScriptPath="${db.scripts}/drop_lams_tool_mc.sql"
 				toolActivityInsertScriptPath="${db.scripts}/activity_insert.sql"
Index: lams_tool_lamc/db/sql/tool_insert.sql
===================================================================
diff -u -r82631c32c25cdbc2d547ee2cdc4a3178cb707f15 -r0b1d9b25bb467095dddfd12e2350a4d261a0306f
--- lams_tool_lamc/db/sql/tool_insert.sql	(.../tool_insert.sql)	(revision 82631c32c25cdbc2d547ee2cdc4a3178cb707f15)
+++ lams_tool_lamc/db/sql/tool_insert.sql	(.../tool_insert.sql)	(revision 0b1d9b25bb467095dddfd12e2350a4d261a0306f)
@@ -34,7 +34,7 @@
 'MCQ',
 'Multiple Choice Questions',
 'mc',
-'20061113',
+'@tool_version@',
 NULL,
 NULL,
 0,
Index: lams_tool_laqa/build.properties
===================================================================
diff -u -re48a67de27af42221ddce80419f05c1be4680430 -r0b1d9b25bb467095dddfd12e2350a4d261a0306f
--- lams_tool_laqa/build.properties	(.../build.properties)	(revision e48a67de27af42221ddce80419f05c1be4680430)
+++ lams_tool_laqa/build.properties	(.../build.properties)	(revision 0b1d9b25bb467095dddfd12e2350a4d261a0306f)
@@ -3,6 +3,9 @@
 #name of this project
 signature=laqa11
 
+#version of this project
+tool.version=20061113
+
 #submit files package definition
 qa.package=org.lamsfoundation.lams.tool.qa
 qa.path=org/lamsfoundation/lams/tool/qa
Index: lams_tool_laqa/build.xml
===================================================================
diff -u -r4fb255fea868033aaa6d97d33efb7b2d7def5ff2 -r0b1d9b25bb467095dddfd12e2350a4d261a0306f
--- lams_tool_laqa/build.xml	(.../build.xml)	(revision 4fb255fea868033aaa6d97d33efb7b2d7def5ff2)
+++ lams_tool_laqa/build.xml	(.../build.xml)	(revision 0b1d9b25bb467095dddfd12e2350a4d261a0306f)
@@ -320,9 +320,17 @@
 					<include name="create_lams_tool_qa.sql"/>
 					<include name="activity_insert.sql"/>
 					<include name="library_insert.sql"/>
-					<include name="tool_insert.sql"/>
 				</fileset>
 			</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>
+			</copy>
 
 			<copy overwrite="yes" todir="${build.deploy}/">
 				<fileset dir="${deploy.tool.dir}">
@@ -357,6 +365,7 @@
 				deployFiles="${build.lib}/${product}.war,${build.lib}/${product}.jar"
 				toolJarFileName="${product}.jar"
 				toolSignature="${signature}"
+				toolVersion="${tool.version}"
 				toolTablesScriptPath="${db.scripts}/create_lams_tool_qa.sql"
 				toolTablesDeleteScriptPath="${db.scripts}/drop_lams_tool_qa.sql"
 				toolActivityInsertScriptPath="${db.scripts}/activity_insert.sql"
Index: lams_tool_laqa/db/sql/tool_insert.sql
===================================================================
diff -u -r139266c30da4c42fbf9d5d20094393f355d13dad -r0b1d9b25bb467095dddfd12e2350a4d261a0306f
--- lams_tool_laqa/db/sql/tool_insert.sql	(.../tool_insert.sql)	(revision 139266c30da4c42fbf9d5d20094393f355d13dad)
+++ lams_tool_laqa/db/sql/tool_insert.sql	(.../tool_insert.sql)	(revision 0b1d9b25bb467095dddfd12e2350a4d261a0306f)
@@ -55,7 +55,7 @@
 'Question and Answer',
 'Q/A Tool',
 'qa',
-'20061113',
+'@tool_version@',
 NULL,
 NULL,
 0,