Mercurial > dive4elements > framework
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 = ?