Index: lams_tool_forum/build.properties
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_forum/build.properties,v
diff -u -r1.5 -r1.6
--- lams_tool_forum/build.properties	29 Jun 2005 06:44:31 -0000	1.5
+++ lams_tool_forum/build.properties	5 Jul 2005 06:03:56 -0000	1.6
@@ -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
===================================================================
RCS file: /usr/local/cvsroot/lams_tool_forum/build.xml,v
diff -u -r1.7 -r1.8
--- lams_tool_forum/build.xml	5 Jul 2005 03:42:50 -0000	1.7
+++ lams_tool_forum/build.xml	5 Jul 2005 06:03:56 -0000	1.8
@@ -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>