Mercurial > dive4elements > framework
comparison artifact-database/src/main/resources/sql/org-postgresql-driver.properties @ 213:199f0e553e3a
Bugfix: Repaired broken SQL statement.
artifacts/trunk@1550 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Wed, 23 Mar 2011 16:20:11 +0000 |
| parents | face2302387c |
| children | a9c8fa38ba03 |
comparison
equal
deleted
inserted
replaced
| 212:d7042094f7b7 | 213:199f0e553e3a |
|---|---|
| 79 collection.item.delete=DELETE FROM collection_items WHERE id = ? | 79 collection.item.delete=DELETE FROM collection_items WHERE id = ? |
| 80 | 80 |
| 81 collection.items.list.gid= \ | 81 collection.items.list.gid= \ |
| 82 SELECT a.gid, ci.attribute FROM collection_items ci \ | 82 SELECT a.gid, ci.attribute FROM collection_items ci \ |
| 83 INNER JOIN artifacts a ON ci.artifact_id = a.id \ | 83 INNER JOIN artifacts a ON ci.artifact_id = a.id \ |
| 84 WHERE ci.id IN (SELECT id FROM collections WHERE gid = ?::uuid) | 84 WHERE ci.collection_id IN (SELECT id FROM collections WHERE gid = ?::uuid) |
| 85 | 85 |
| 86 # COLLECTIONS | 86 # COLLECTIONS |
| 87 collections.touch.by.gid =\ | 87 collections.touch.by.gid =\ |
| 88 UPDATE collections SET last_access = CURRENT_TIMESTAMP \ | 88 UPDATE collections SET last_access = CURRENT_TIMESTAMP \ |
| 89 WHERE gid = ?::uuid | 89 WHERE gid = ?::uuid |