Mercurial > dive4elements > framework
changeset 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 | 0f4ee5886f86 |
| children | 8032aade18f7 |
| files | ChangeLog artifact-database/src/main/resources/sql/org-h2-driver.properties artifact-database/src/main/resources/sql/org-postgresql-driver.properties |
| diffstat | 3 files changed, 8 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/ChangeLog Fri Sep 07 09:28:43 2012 +0000 +++ b/ChangeLog Fri Sep 07 13:01:43 2012 +0000 @@ -1,3 +1,9 @@ +2012-09-07 Björn Ricks <bjoern.ricks@intevation.de> + + * artifact-database/src/main/resources/sql/org-h2-driver.properties, + artifact-database/src/main/resources/sql/org-postgresql-driver.properties: + Fix queries for finding a user. + 2012-09-07 Ingo Weinzierl <ingo@intevation.de> Tagged RELEASE 2.9
--- a/artifact-database/src/main/resources/sql/org-h2-driver.properties Fri Sep 07 09:28:43 2012 +0000 +++ b/artifact-database/src/main/resources/sql/org-h2-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 = ? users.select.gid=SELECT id, name, account, role FROM users WHERE gid = ? -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 = ?
--- 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 = ?