Mercurial > dive4elements > framework
diff artifact-database/src/main/resources/sql/org-postgresql-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 |
line wrap: on
line diff
--- a/artifact-database/src/main/resources/sql/org-postgresql-driver.properties Fri Sep 07 09:28:43 2012 +0000 +++ b/artifact-database/src/main/resources/sql/org-postgresql-driver.properties Fri Sep 07 13:01:43 2012 +0000 @@ -37,7 +37,7 @@ users.select.id.by.gid=SELECT id FROM users WHERE gid = ?::uuid users.select.gid=SELECT id, name, account, role FROM users WHERE gid = ?::uuid -users.select.account=SELECT id, name, account, role FROM users WHERE account = ? +users.select.account=SELECT gid, name, account, role FROM users WHERE account = ? users.delete.id=DELETE FROM users WHERE id = ?