Mercurial > dive4elements > framework
comparison artifact-database/src/main/resources/sql/org-h2-driver.properties @ 340:560d2e6eaf9c
Fix SQL typo.
artifacts/trunk@2957 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
|---|---|
| date | Thu, 13 Oct 2011 11:38:52 +0000 |
| parents | b46c5b13ac94 |
| children | 542caebea773 |
comparison
equal
deleted
inserted
replaced
| 339:f6beb4ffcf23 | 340:560d2e6eaf9c |
|---|---|
| 75 | 75 |
| 76 collection.item.outdate.artifact= \ | 76 collection.item.outdate.artifact= \ |
| 77 UPDATE artifacts \ | 77 UPDATE artifacts \ |
| 78 SET last_access = DATEADD('MILLISECOND', -2, CURRENT_TIMESTAMP), ttl = 1 \ | 78 SET last_access = DATEADD('MILLISECOND', -2, CURRENT_TIMESTAMP), ttl = 1 \ |
| 79 WHERE id = ? AND \ | 79 WHERE id = ? AND \ |
| 80 NOT EXSITS \ | 80 NOT EXISTS \ |
| 81 (SELECT id FROM collection_items WHERE collection_id <> ? AND artifact_id = ?) | 81 (SELECT id FROM collection_items WHERE collection_id <> ? AND artifact_id = ?) |
| 82 | 82 |
| 83 collection.item.delete=DELETE FROM collection_items WHERE id = ? | 83 collection.item.delete=DELETE FROM collection_items WHERE id = ? |
| 84 | 84 |
| 85 collection.items.list.gid= \ | 85 collection.items.list.gid= \ |