Index: lams_tool_forum/build.properties
===================================================================
diff -u -rfe96d09692633e2c243d7af4363c5267b5bca655 -r7c25592018d845ec3f8d0d0b5825d5f7f2ce6261
--- lams_tool_forum/build.properties	(.../build.properties)	(revision fe96d09692633e2c243d7af4363c5267b5bca655)
+++ lams_tool_forum/build.properties	(.../build.properties)	(revision 7c25592018d845ec3f8d0d0b5825d5f7f2ce6261)
@@ -16,3 +16,11 @@
 appserver.deploy.dir = C:/resin-3.0.13/webapps
 #appserver.deploy.dir = C:/Program Files/tomcat 4.1/webapps
 #appserver.deploy.dir = C:/tomcat41/jakarta-tomcat-4.1.31/webapps
+
+lib.dir=${basedir}/lib
+db.name = forum
+db.driver=com.mysql.jdbc.Driver
+db.url=jdbc:mysql://localhost/${db.name}?characterEncoding=utf8
+db.username=root
+db.password=root
+db.scripts=/db/sql
Index: lams_tool_forum/build.xml
===================================================================
diff -u -rc0928429e100f6918d24baa6f04206dd7d64f8f5 -r7c25592018d845ec3f8d0d0b5825d5f7f2ce6261
--- lams_tool_forum/build.xml	(.../build.xml)	(revision c0928429e100f6918d24baa6f04206dd7d64f8f5)
+++ lams_tool_forum/build.xml	(.../build.xml)	(revision 7c25592018d845ec3f8d0d0b5825d5f7f2ce6261)
@@ -191,8 +191,44 @@
             classpathref="test.class.path"
             destdir="${test.classes.dir}"/>
     </target>
+	
+	
+	<!-- =================================================================== -->
+	<!-- Forum Database tasks                                               -->
+	<!-- =================================================================== -->
+	<target name="clean-db"	description="clean forum database.">
+		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+				password="${db.password}">			
+			<fileset dir="${lib.dir}">
+				<include name="**/*.jar"/>
+			</fileset>
+			<transaction src="${db.scripts}/cleanup_lams_tool_forum.sql"/>
+		</sql>
+	</target>
+	
+	<target name="init-db"	description="drop and create forum database.">
+		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+				password="${db.password}">
+			<fileset dir="${lib.dir}">
+				<include name="**/*.jar"/>
+			</fileset>
+			<transaction src="${db.scripts}/drop_lams_tool_forum.sql"/>
+			<transaction src="${db.scripts}/create_lams_tool_forum.sql"/>
+		</sql>
+	</target>
+	
+	<target name="build-db"	depends="init-db" 
+							description="build qa tool database.">
+		<sql driver="${db.driver}" url="${db.url}" userid="${db.username}"
+				password="${db.password}">
+			<fileset dir="${lib.dir}">
+				<include name="**/*.jar"/>
+			</fileset>
+			<transaction src="${db.scripts}/insert_lams_tool_forum_data.sql"/>
+		</sql>
+	</target>
 
-    <target name="junit" depends="compiletest">
+    <target name="junit" depends="compiletest, init-db">
         <echo>+-------------------------------------------+</echo>
         <echo>| run junit tests and save results in /test |</echo>
         <echo>+-------------------------------------------+</echo>