diff artifact-database/src/main/resources/sql/org-postgresql-driver.properties @ 199:face2302387c

Insert collection attribute into database, too. Fixed broken SQL schema. artifacts/trunk@1437 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 09 Mar 2011 11:14:21 +0000
parents 94654cbf8db2
children 199f0e553e3a
line wrap: on
line diff
--- a/artifact-database/src/main/resources/sql/org-postgresql-driver.properties	Wed Mar 09 11:03:25 2011 +0000
+++ b/artifact-database/src/main/resources/sql/org-postgresql-driver.properties	Wed Mar 09 11:14:21 2011 +0000
@@ -104,8 +104,9 @@
     (SELECT id FROM collections WHERE owner_id = ?)
 
 collections.insert= \
-    INSERT INTO collections (id, gid, name, owner_id, creation, last_access, ttl) \
-    VALUES (?, ?::uuid, ?, ?, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ?)
+    INSERT INTO collections \
+    (id, gid, name, owner_id, creation, last_access, ttl, attribute) \
+    VALUES (?, ?::uuid, ?, ?, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ?, ?)
 
 collection.creation.time=SELECT creation from collections WHERE id = ?
 

http://dive4elements.wald.intevation.org