Mercurial > dive4elements > framework
comparison artifact-database/src/main/resources/sql/org-h2-driver.properties @ 319:61017c6031b8
Fixed H2 SQL to set TTL of collection.
artifacts/trunk@2467 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Mon, 08 Aug 2011 13:06:05 +0000 |
| parents | 824051dff018 |
| children | b46c5b13ac94 |
comparison
equal
deleted
inserted
replaced
| 318:2ed77f7e1bab | 319:61017c6031b8 |
|---|---|
| 96 INNER JOIN artifacts a ON ci.artifact_id = a.id \ | 96 INNER JOIN artifacts a ON ci.artifact_id = a.id \ |
| 97 WHERE c.ttl IS NOT NULL \ | 97 WHERE c.ttl IS NOT NULL \ |
| 98 AND DATEDIFF('MILLISECOND', c.last_access, CURRENT_TIMESTAMP) > c.ttl \ | 98 AND DATEDIFF('MILLISECOND', c.last_access, CURRENT_TIMESTAMP) > c.ttl \ |
| 99 AND a.id NOT IN ($LOCKED_IDS$) | 99 AND a.id NOT IN ($LOCKED_IDS$) |
| 100 | 100 |
| 101 collections.update.ttl=UPDATE collections SET ttl = ? WHERE id = ? | 101 collections.update.ttl=UPDATE collections SET ttl = ? WHERE gid = ? |
| 102 | 102 |
| 103 collections.update.name=UPDATE collections SET name = ? WHERE gid = ? | 103 collections.update.name=UPDATE collections SET name = ? WHERE gid = ? |
| 104 | 104 |
| 105 collections.touch.trigger.function = \ | 105 collections.touch.trigger.function = \ |
| 106 UPDATE collections SET last_access = current_timestamp \ | 106 UPDATE collections SET last_access = current_timestamp \ |