# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1307368838 0
# Node ID aa9f2f5ff0328da7cba6c0a0140312458e3b90d7
# Parent  89f6de49803d749482c470f4f709affaf6a6b3c6
flys/issue75: fixed doc and schema to make H2 work again.

artifacts/trunk@2059 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r 89f6de49803d -r aa9f2f5ff032 ChangeLog
--- a/ChangeLog	Fri Jun 03 06:37:23 2011 +0000
+++ b/ChangeLog	Mon Jun 06 14:00:38 2011 +0000
@@ -1,3 +1,11 @@
+2011-06-06	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
+
+	flys/issue75
+
+	* artifact-database/doc/schema-h2.sql: Fixed SQL syntax error in trigger creation.
+
+	* README: Adjusted to use new lib versions.
+
 2011-06-03  Ingo Weinzierl <ingo@intevation.de>
 
 	* artifacts-common/src/main/java/de/intevation/artifacts/common/utils/ClientProtocolUtils.java:
diff -r 89f6de49803d -r aa9f2f5ff032 README
--- a/README	Fri Jun 03 06:37:23 2011 +0000
+++ b/README	Mon Jun 06 14:00:38 2011 +0000
@@ -1,9 +1,13 @@
 
 Create a new H2 database for usage in the artifact database:
 
-$ java -cp `find ~/.m2/ -name h2\*.jar` org.h2.tools.RunScript \
-    -user USER \
-    -password PASSWORD \
-    -url jdbc:h2:artifact-database/doc/example-conf/artifacts.db \
-    -script artifact-database/doc/schema-h2.sql
+$ mkdir testdb
 
+$ for i in h2-1.3.152 artifact-database-1.0-SNAPSHOT artifacts-common-1.0-SNAPSHOT log4j-1.2.14 ; do
+>    export CLASSPATH=$CLASSPATH:`find ~/.m2/ -name $i.jar`
+> done
+
+$ java org.h2.tools.RunScript \
+>    -url jdbc:h2:`readlink -f testdb`/artifacts.db \
+>    -script artifact-database/doc/schema-h2.sql
+
diff -r 89f6de49803d -r aa9f2f5ff032 artifact-database/doc/schema-h2.sql
--- a/artifact-database/doc/schema-h2.sql	Fri Jun 03 06:37:23 2011 +0000
+++ b/artifact-database/doc/schema-h2.sql	Mon Jun 06 14:00:38 2011 +0000
@@ -51,7 +51,7 @@
 );
 
 CREATE TRIGGER collections_access_update_trigger AFTER UPDATE
-    ON TABLE artifacts FOR EACH ROW 
+    ON artifacts FOR EACH ROW 
     CALL "de.intevation.artifactdatabase.h2.CollectionAccessUpdateTrigger";
 
 COMMIT;