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

http://dive4elements.wald.intevation.org