comparison artifact-database/src/main/resources/sql/org-postgresql-driver.properties @ 422:a8b6b4924f4e 2.9

Merged revisions 5376,5383 via svnmerge from file:///home/clients/bsh/bsh-generischer-viewer/Material/SVN/artifacts/trunk ........ r5376 | ingo | 2012-09-07 11:28:43 +0200 (Fr, 07 Sep 2012) | 1 line Tagged 'artifacts' as 2.9 ........ r5383 | bricks | 2012-09-07 15:01:43 +0200 (Fr, 07 Sep 2012) | 2 lines Fix queries for finding a user ........ artifacts/tags/2.9@5386 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Fri, 07 Sep 2012 13:09:11 +0000
parents f5ecca16f601
children 9497f58484a0
comparison
equal deleted inserted replaced
419:92b51af2d02d 422:a8b6b4924f4e
35 35
36 users.insert=INSERT INTO users (id, gid, name, account, role) VALUES (?, ?::uuid, ?, ?, ?) 36 users.insert=INSERT INTO users (id, gid, name, account, role) VALUES (?, ?::uuid, ?, ?, ?)
37 37
38 users.select.id.by.gid=SELECT id FROM users WHERE gid = ?::uuid 38 users.select.id.by.gid=SELECT id FROM users WHERE gid = ?::uuid
39 users.select.gid=SELECT id, name, account, role FROM users WHERE gid = ?::uuid 39 users.select.gid=SELECT id, name, account, role FROM users WHERE gid = ?::uuid
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

http://dive4elements.wald.intevation.org