Index: lams_tool_example/build.properties
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_example/build.properties,v
diff -u -r1.3 -r1.4
--- lams_tool_example/build.properties	13 Feb 2007 00:53:05 -0000	1.3
+++ lams_tool_example/build.properties	13 Feb 2007 01:12:54 -0000	1.4
@@ -2,7 +2,10 @@
 # project-wide properties 
 signature=laex11
 
+# project version example
+tool.version=20061102
+
 package=org/lamsfoundation/lams/tool/example
 package.name=org.lamsfoundation.lams.tool.example
-tool.version=20061102
 
+
Index: lams_tool_larsrc/build.properties
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_larsrc/build.properties,v
diff -u -r1.3 -r1.4
--- lams_tool_larsrc/build.properties	17 Aug 2006 03:54:42 -0000	1.3
+++ lams_tool_larsrc/build.properties	13 Feb 2007 01:06:06 -0000	1.4
@@ -11,3 +11,6 @@
 signature=larsrc11
 project.displayname = lams share resources tool
 weblib=lib
+
+#project version
+tool.version=20061102
\ No newline at end of file
Index: lams_tool_larsrc/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_larsrc/build.xml,v
diff -u -r1.14 -r1.15
--- lams_tool_larsrc/build.xml	9 Feb 2007 01:42:16 -0000	1.14
+++ lams_tool_larsrc/build.xml	13 Feb 2007 01:06:06 -0000	1.15
@@ -330,9 +330,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}">
@@ -367,6 +375,7 @@
 			deployFiles="${build.lib}/${product}.war,${build.lib}/${product}.jar"
 			toolJarFileName="${product}.jar"
 			toolSignature="${signature}"
+			toolVersion="${tool.version}"
 			toolTablesScriptPath="${db.scripts}/create_lams_tool_rsrc.sql"
 			toolTablesDeleteScriptPath="${db.scripts}/drop_lams_tool_rsrc.sql"
 			toolActivityInsertScriptPath="${db.scripts}/activity_insert.sql"
Index: lams_tool_larsrc/db/sql/tool_insert.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_larsrc/db/sql/tool_insert.sql,v
diff -u -r1.8 -r1.9
--- lams_tool_larsrc/db/sql/tool_insert.sql	3 Nov 2006 00:09:40 -0000	1.8
+++ lams_tool_larsrc/db/sql/tool_insert.sql	13 Feb 2007 01:06:06 -0000	1.9
@@ -36,7 +36,7 @@
 'Shared Resources',
 'Shared Resources',
 'sharedresources',
-'20061102',
+'@tool_version@',
 NULL,
 NULL,
 0,
Index: lams_tool_nb/build.properties
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/build.properties,v
diff -u -r1.11 -r1.12
--- lams_tool_nb/build.properties	7 Apr 2006 00:46:45 -0000	1.11
+++ lams_tool_nb/build.properties	13 Feb 2007 01:09:05 -0000	1.12
@@ -8,4 +8,7 @@
 ## Test toolContentID
 test.contentid=355
 
+# project version
+tool.version=20061102
 
+
Index: lams_tool_nb/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/build.xml,v
diff -u -r1.30 -r1.31
--- lams_tool_nb/build.xml	9 Feb 2007 01:47:57 -0000	1.30
+++ lams_tool_nb/build.xml	13 Feb 2007 01:09:05 -0000	1.31
@@ -403,9 +403,17 @@
 						<include name="create_lams_tool_nb.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}">
@@ -440,6 +448,7 @@
 					deployFiles="${build.lib}/${product}.war,${build.lib}/${product}.jar"
 					toolJarFileName="${product}.jar"
 					toolSignature="${signature}"
+					toolVersion="${tool.version}"
 					toolTablesScriptPath="${db.scripts}/create_lams_tool_nb.sql"
 					toolTablesDeleteScriptPath="${db.scripts}/drop_lams_tool_nb.sql"
 					toolActivityInsertScriptPath="${db.scripts}/activity_insert.sql"
Index: lams_tool_nb/db/sql/tool_insert.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_nb/db/sql/tool_insert.sql,v
diff -u -r1.21 -r1.22
--- lams_tool_nb/db/sql/tool_insert.sql	3 Nov 2006 00:09:52 -0000	1.21
+++ lams_tool_nb/db/sql/tool_insert.sql	13 Feb 2007 01:09:05 -0000	1.22
@@ -34,7 +34,7 @@
 'NoticeboardX',
 'Displays a NoticeboardX',
 'nb',
-'20061102',
+'@tool_version@',
 NULL,
 NULL,
 0,
Index: lams_tool_notebook/build.properties
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_notebook/build.properties,v
diff -u -r1.1 -r1.2
--- lams_tool_notebook/build.properties	20 Jul 2006 01:11:09 -0000	1.1
+++ lams_tool_notebook/build.properties	13 Feb 2007 01:12:53 -0000	1.2
@@ -2,6 +2,9 @@
 # project-wide properties 
 signature=lantbk11
 
+#project version
+tool.version=20061102
+
 package=org/lamsfoundation/lams/tool/notebook
 package.name=org.lamsfoundation.lams.tool.notebook
 weblib=lib
Index: lams_tool_notebook/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_notebook/build.xml,v
diff -u -r1.4 -r1.5
--- lams_tool_notebook/build.xml	9 Feb 2007 01:32:52 -0000	1.4
+++ lams_tool_notebook/build.xml	13 Feb 2007 01:12:53 -0000	1.5
@@ -350,9 +350,17 @@
 				<include name="create_lams_tool_notebook.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_notebook.sql" 
 			toolTablesDeleteScriptPath="${db.scripts}/drop_lams_tool_notebook.sql" 
 			toolActivityInsertScriptPath="${db.scripts}/activity_insert.sql" 
Index: lams_tool_notebook/db/sql/tool_insert.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_notebook/db/sql/tool_insert.sql,v
diff -u -r1.4 -r1.5
--- lams_tool_notebook/db/sql/tool_insert.sql	3 Nov 2006 00:10:04 -0000	1.4
+++ lams_tool_notebook/db/sql/tool_insert.sql	13 Feb 2007 01:12:53 -0000	1.5
@@ -34,7 +34,7 @@
 'Notebook',
 'Notebook',
 'notebook',
-'20061102',
+'@tool_version@',
 NULL,
 NULL,
 0,
Index: lams_tool_sbmt/build.properties
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_sbmt/build.properties,v
diff -u -r1.11 -r1.12
--- lams_tool_sbmt/build.properties	17 Jan 2006 05:12:08 -0000	1.11
+++ lams_tool_sbmt/build.properties	13 Feb 2007 01:15:51 -0000	1.12
@@ -7,6 +7,9 @@
 #name of this project
 signature=lasbmt11
 
+#project version
+tool.version=20061102
+
 #submit files package definition
 sbmt.package=org.lamsfoundation.lams.tool.sbmt
 sbmt.path=org/lamsfoundation/lams/tool/sbmt
Index: lams_tool_sbmt/build.xml
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_sbmt/build.xml,v
diff -u -r1.37 -r1.38
--- lams_tool_sbmt/build.xml	9 Feb 2007 01:39:05 -0000	1.37
+++ lams_tool_sbmt/build.xml	13 Feb 2007 01:15:51 -0000	1.38
@@ -350,9 +350,17 @@
 				<include name="create_lams_tool_sbmt.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}"
 			toolTablesDeleteScriptPath="${db.scripts}/drop_lams_tool_sbmt.sql"
 			toolTablesScriptPath="${db.scripts}/create_lams_tool_sbmt.sql"
 			toolActivityInsertScriptPath="${db.scripts}/activity_insert.sql"
Index: lams_tool_sbmt/db/sql/tool_insert.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_sbmt/db/sql/tool_insert.sql,v
diff -u -r1.19 -r1.20
--- lams_tool_sbmt/db/sql/tool_insert.sql	3 Nov 2006 00:10:18 -0000	1.19
+++ lams_tool_sbmt/db/sql/tool_insert.sql	13 Feb 2007 01:15:51 -0000	1.20
@@ -34,7 +34,7 @@
 'Submit File',
 'Submit File Tool Description',
 'submitfile',
-'20061102',
+'@tool_version@',
 NULL,
 NULL,
 0,