Mercurial > dive4elements > framework
comparison artifact-database/src/main/resources/sql/org-h2-driver.properties @ 253:a2df2b48d2aa
Enabled the artifact database to handle requests specific to collection attributes and collection item attributes.
artifacts/trunk@1746 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Tue, 26 Apr 2011 07:43:40 +0000 |
| parents | 33b9cc23ac9b |
| children | 22a90706d32d |
comparison
equal
deleted
inserted
replaced
| 252:6de74b0b878e | 253:a2df2b48d2aa |
|---|---|
| 168 (SELECT artifact_id FROM collection_items WHERE \ | 168 (SELECT artifact_id FROM collection_items WHERE \ |
| 169 collection_id IN (SELECT id FROM collections WHERE owner_id = ?) \ | 169 collection_id IN (SELECT id FROM collections WHERE owner_id = ?) \ |
| 170 AND artifact_id NOT IN \ | 170 AND artifact_id NOT IN \ |
| 171 (SELECT artifact_id FROM collection_items WHERE collection_id IN \ | 171 (SELECT artifact_id FROM collection_items WHERE collection_id IN \ |
| 172 (SELECT id FROM collections WHERE owner_id <> ?))) | 172 (SELECT id FROM collections WHERE owner_id <> ?))) |
| 173 | |
| 174 collection.get.attribute= \ | |
| 175 SELECT c.attribute FROM collections c WHERE c.gid = ? | |
| 176 | |
| 177 collection.set.attribute= \ | |
| 178 UPDATE collections SET attribute = ? WHERE gid = ? |