Index: lams_tool_scribe/build.properties
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_scribe/build.properties,v
diff -u -r1.1 -r1.2
--- lams_tool_scribe/build.properties	15 Sep 2006 03:09:53 -0000	1.1
+++ lams_tool_scribe/build.properties	13 Feb 2007 01:19:41 -0000	1.2
@@ -2,6 +2,9 @@
 # project-wide properties 
 signature=lascrb11
 
+# project version
+tool.version=20061024
+
 package=org/lamsfoundation/lams/tool/scribe
 package.name=org.lamsfoundation.lams.tool.scribe
 weblib=lib
Index: lams_tool_scribe/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_scribe/build.xml,v
diff -u -r1.4 -r1.5
--- lams_tool_scribe/build.xml	9 Feb 2007 01:53:01 -0000	1.4
+++ lams_tool_scribe/build.xml	13 Feb 2007 01:19:41 -0000	1.5
@@ -350,9 +350,17 @@
 				<include name="create_lams_tool_scribe.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}">
@@ -387,6 +395,7 @@
 			deployFiles="${build.lib}/${product}.war,${build.lib}/${product}.jar" 
 			toolJarFileName="${product}.jar"
 			toolSignature="${signature}" 
+			toolVersion="${tool.version}"
 			toolTablesScriptPath="${db.scripts}/create_lams_tool_scribe.sql" 
 			toolTablesDeleteScriptPath="${db.scripts}/drop_lams_tool_scribe.sql" 
 			toolActivityInsertScriptPath="${db.scripts}/activity_insert.sql" 
Index: lams_tool_scribe/db/sql/tool_insert.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_scribe/db/sql/tool_insert.sql,v
diff -u -r1.3 -r1.4
--- lams_tool_scribe/db/sql/tool_insert.sql	24 Oct 2006 06:50:50 -0000	1.3
+++ lams_tool_scribe/db/sql/tool_insert.sql	13 Feb 2007 01:19:41 -0000	1.4
@@ -34,7 +34,7 @@
 'Scribe',
 'Scribe',
 'scribe',
-'20061024',
+'@tool_version@',
 NULL,
 NULL,
 0,
Index: lams_tool_survey/build.properties
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_survey/build.properties,v
diff -u -r1.2 -r1.3
--- lams_tool_survey/build.properties	13 Sep 2006 07:20:18 -0000	1.2
+++ lams_tool_survey/build.properties	13 Feb 2007 01:24:59 -0000	1.3
@@ -10,3 +10,6 @@
 ### project properties ###
 signature=lasurv11
 project.displayname = lams survey tool
+
+# project version
+tool.version=20070208
Index: lams_tool_survey/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_survey/build.xml,v
diff -u -r1.5 -r1.6
--- lams_tool_survey/build.xml	9 Feb 2007 01:50:46 -0000	1.5
+++ lams_tool_survey/build.xml	13 Feb 2007 01:24:59 -0000	1.6
@@ -321,9 +321,17 @@
 				<include name="drop_lams_tool_forum.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}">
@@ -358,6 +366,7 @@
 			deployFiles="${build.lib}/${product}.war,${build.lib}/${product}.jar"
 			toolJarFileName="${product}.jar"
 			toolSignature="${signature}"
+			toolVersion="${tool.version}"
 			toolTablesScriptPath="${db.scripts}/create_lams_tool_survey.sql"
 			toolTablesDeleteScriptPath="${db.scripts}/drop_lams_tool_survey.sql"
 			toolActivityInsertScriptPath="${db.scripts}/activity_insert.sql"
Index: lams_tool_survey/db/sql/tool_insert.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_survey/db/sql/tool_insert.sql,v
diff -u -r1.5 -r1.6
--- lams_tool_survey/db/sql/tool_insert.sql	9 Feb 2007 06:05:44 -0000	1.5
+++ lams_tool_survey/db/sql/tool_insert.sql	13 Feb 2007 01:24:59 -0000	1.6
@@ -36,7 +36,7 @@
 'Survey',
 'Survey',
 'survey',
-'20070208',
+'@tool_version@',
 NULL,
 NULL,
 0,
Index: lams_tool_vote/build.properties
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_vote/build.properties,v
diff -u -r1.2 -r1.3
--- lams_tool_vote/build.properties	29 Apr 2006 13:58:10 -0000	1.2
+++ lams_tool_vote/build.properties	13 Feb 2007 01:27:51 -0000	1.3
@@ -3,6 +3,9 @@
 #name of this project
 signature=lavote11
 
+#project version
+tool.version=20061113
+
 #submit files package definition
 vote.package=org.lamsfoundation.lams.tool.vote
 vote.path=org/lamsfoundation/lams/tool/vote
Index: lams_tool_vote/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_vote/build.xml,v
diff -u -r1.10 -r1.11
--- lams_tool_vote/build.xml	9 Feb 2007 01:45:15 -0000	1.10
+++ lams_tool_vote/build.xml	13 Feb 2007 01:27:51 -0000	1.11
@@ -355,9 +355,17 @@
 					<include name="create_lams_tool_vote.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}">
@@ -392,6 +400,7 @@
 				deployFiles="${build.lib}/${product}.war,${build.lib}/${product}.jar"
 				toolJarFileName="${product}.jar"
 				toolSignature="${signature}"
+				toolVersion="${tool.version}"
 				toolTablesScriptPath="${db.scripts}/create_lams_tool_vote.sql"
 				toolTablesDeleteScriptPath="${db.scripts}/drop_lams_tool_vote.sql"
 				toolActivityInsertScriptPath="${db.scripts}/activity_insert.sql"
Index: lams_tool_vote/db/sql/tool_insert.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_vote/db/sql/tool_insert.sql,v
diff -u -r1.8 -r1.9
--- lams_tool_vote/db/sql/tool_insert.sql	13 Nov 2006 20:35:40 -0000	1.8
+++ lams_tool_vote/db/sql/tool_insert.sql	13 Feb 2007 01:27:51 -0000	1.9
@@ -55,7 +55,7 @@
 'Voting',
 'Voting',
 'vote',
-'20061113',
+'@tool_version@',
 NULL,
 NULL,
 0,