Mercurial > dive4elements > framework
comparison artifact-database/src/main/resources/sql/org-h2-driver.properties @ 421:4213dd6ca169
Fix queries for finding a user
artifacts/trunk@5383 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Bjoern Ricks <bjoern.ricks@intevation.de> |
|---|---|
| date | Fri, 07 Sep 2012 13:01:43 +0000 |
| parents | f5ecca16f601 |
| children | 9497f58484a0 |
comparison
equal
deleted
inserted
replaced
| 420:0f4ee5886f86 | 421:4213dd6ca169 |
|---|---|
| 35 | 35 |
| 36 users.insert=INSERT INTO users (id, gid, name, account, role) VALUES (?, ?, ?, ?, ?) | 36 users.insert=INSERT INTO users (id, gid, name, account, role) VALUES (?, ?, ?, ?, ?) |
| 37 | 37 |
| 38 users.select.id.by.gid=SELECT id FROM users WHERE gid = ? | 38 users.select.id.by.gid=SELECT id FROM users WHERE gid = ? |
| 39 users.select.gid=SELECT id, name, account, role FROM users WHERE gid = ? | 39 users.select.gid=SELECT id, name, account, role FROM users WHERE gid = ? |
| 40 users.select.account=SELECT id, name, account, role FROM users WHERE account = ? | 40 users.select.account=SELECT gid, name, account, role FROM users WHERE account = ? |
| 41 | 41 |
| 42 users.delete.id=DELETE FROM users WHERE id = ? | 42 users.delete.id=DELETE FROM users WHERE id = ? |
| 43 | 43 |
| 44 users.delete.collections=DELETE FROM collections where owner_id = ? | 44 users.delete.collections=DELETE FROM collections where owner_id = ? |
| 45 | 45 |