Mercurial > dive4elements > framework
comparison artifact-database/src/main/resources/sql/org-h2-driver.properties @ 181:116482169b44
Adapted the sql statements for fetching all collections and all user collections from database.
artifacts/trunk@1407 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Mon, 07 Mar 2011 11:10:45 +0000 |
| parents | 38fbbeffe8fe |
| children | a22b7e367b25 |
comparison
equal
deleted
inserted
replaced
| 180:38fbbeffe8fe | 181:116482169b44 |
|---|---|
| 102 | 102 |
| 103 collection.creation.time=SELECT creation from collections WHERE id = ? | 103 collection.creation.time=SELECT creation from collections WHERE id = ? |
| 104 | 104 |
| 105 collections.select.user= \ | 105 collections.select.user= \ |
| 106 SELECT c.gid, c.name, c.creation, u.gid FROM \ | 106 SELECT c.gid, c.name, c.creation, u.gid FROM \ |
| 107 collections c OUTER LEFT JOIN users u ON c.owner_id = u.id \ | 107 collections c LEFT OUTER JOIN users u ON c.owner_id = u.id \ |
| 108 WHERE u.gid = ? | 108 WHERE u.gid = ? |
| 109 | 109 |
| 110 collections.select.all= \ | 110 collections.select.all= \ |
| 111 SELECT c.gid, c.name, c.creation, u.gid FROM \ | 111 SELECT c.gid, c.name, c.creation, u.gid FROM \ |
| 112 collections c OUTER LEFT JOIN users u ON c.owner_id = u.id | 112 collections c LEFT OUTER JOIN users u ON c.owner_id = u.id |
| 113 | 113 |
| 114 users.collections=SELECT collection_id, gid, name FROM collections WHERE owner_id = ? | 114 users.collections=SELECT collection_id, gid, name FROM collections WHERE owner_id = ? |
| 115 users.collection.ids=SELECT collection_id FROM collections WHERE owner_id = ? | 115 users.collection.ids=SELECT collection_id FROM collections WHERE owner_id = ? |
| 116 | 116 |
| 117 users.delete.all.collections=DELETE FROM collections WHERE owner_id = ? | 117 users.delete.all.collections=DELETE FROM collections WHERE owner_id = ? |