Mercurial > dive4elements > framework
comparison artifact-database/src/main/resources/sql/org-h2-driver.properties @ 275:e92d5944fe4b
Enabled the artifact database to retrieve requests to change the name of a specific collection.
artifacts/trunk@2074 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Wed, 08 Jun 2011 07:36:43 +0000 |
| parents | 92166f7c3842 |
| children | 942a54670a72 |
comparison
equal
deleted
inserted
replaced
| 274:92166f7c3842 | 275:e92d5944fe4b |
|---|---|
| 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 id = ? |
| 102 | 102 |
| 103 collections.update.name=UPDATE collections SET name = ? WHERE gid = ? | |
| 104 | |
| 103 collections.touch.trigger.function = \ | 105 collections.touch.trigger.function = \ |
| 104 UPDATE collections SET last_access = current_timestamp \ | 106 UPDATE collections SET last_access = current_timestamp \ |
| 105 WHERE id IN \ | 107 WHERE id IN \ |
| 106 (SELECT c.id FROM collections c \ | 108 (SELECT c.id FROM collections c \ |
| 107 INNER JOIN collection_items ci ON c.id = ci.collection_id \ | 109 INNER JOIN collection_items ci ON c.id = ci.collection_id \ |