# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1251994405 0
# Node ID b1ec257e9d8d043e3ad313731766d37dfd0d73bd
# Parent  141457e0d7b14638f625ac997a45fc59bb9c8570
Added dependencies to H2 and restlet.



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

diff -r 141457e0d7b1 -r b1ec257e9d8d Changelog
--- a/Changelog	Thu Sep 03 13:59:35 2009 +0000
+++ b/Changelog	Thu Sep 03 16:13:25 2009 +0000
@@ -1,3 +1,17 @@
+2009-09-03	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
+
+	* artifact-database/doc/schema.sql: Schema to store artifacts
+	in H2 databases.
+
+	* artifact-database/pom.xml: Added dependencies to H2 and
+	restlet.
+
+	* pom.xml: Added repository to fetch restlet.
+
+	* README: Describe how to create a H2 database to store artifacts.
+	TODO: Make it more general because description assumes usage of
+	a unixoid system.
+
 2009-09-03	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
 
 	* artifact-database/**: created new sub project for the artefact 
diff -r 141457e0d7b1 -r b1ec257e9d8d README
--- a/README	Thu Sep 03 13:59:35 2009 +0000
+++ b/README	Thu Sep 03 16:13:25 2009 +0000
@@ -0,0 +1,8 @@
+
+Create a new H2 database for usage in the artifact database:
+
+$ java -cp `find ~/.m2/ -name h2\*.jar` org.h2.tools.Shell \
+    -user USER \
+    -password PASSWORD \
+    -url jdbc:h2:PATH_TO_FILE \
+    < artifact-database/doc/schema.sql
diff -r 141457e0d7b1 -r b1ec257e9d8d artifact-database/doc/schema.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/artifact-database/doc/schema.sql	Thu Sep 03 16:13:25 2009 +0000
@@ -0,0 +1,16 @@
+--
+-- schema to store artifacts in H2 databases.
+--
+
+BEGIN;
+
+CREATE TABLE artifacts (
+    id          INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
+    gid         UUID      NOT NULL UNIQUE,
+    creation    TIMESTAMP NOT NULL,
+    last_access TIMESTAMP NOT NULL,
+    ttl         TIME, -- NULL means eternal
+    data        BLOB
+);
+
+COMMIT;
diff -r 141457e0d7b1 -r b1ec257e9d8d artifact-database/pom.xml
--- a/artifact-database/pom.xml	Thu Sep 03 13:59:35 2009 +0000
+++ b/artifact-database/pom.xml	Thu Sep 03 16:13:25 2009 +0000
@@ -16,5 +16,15 @@
         <artifactId>artifacts</artifactId>
         <version>1.0-SNAPSHOT</version>
     </dependency>
+    <dependency>  
+      <groupId>org.restlet</groupId>  
+      <artifactId>org.restlet</artifactId>  
+      <version>2.0-M3</version>  
+    </dependency> 
+    <dependency>
+        <groupId>com.h2database</groupId>
+        <artifactId>h2</artifactId>
+        <version>1.1.117</version>
+    </dependency>
   </dependencies>
 </project>
diff -r 141457e0d7b1 -r b1ec257e9d8d pom.xml
--- a/pom.xml	Thu Sep 03 13:59:35 2009 +0000
+++ b/pom.xml	Thu Sep 03 16:13:25 2009 +0000
@@ -7,8 +7,15 @@
   <version>1.0-SNAPSHOT</version>
   <name>artifact-system</name>
   <url>http://maven.apache.org</url>
+  <repositories>
+    <repository>  
+        <id>maven-restlet</id>  
+        <name>Public online Restlet repository</name>  
+        <url>http://maven.restlet.org</url>  
+    </repository>
+  </repositories>
   <modules>
     <module>artifacts</module>
     <module>artifact-database</module>
   </modules>
-</project>
\ No newline at end of file
+</project>