comparison artifact-database/src/main/resources/sql/org-h2-driver.properties @ 413:f5ecca16f601

Implement method to find/get a user by its account name artifacts/trunk@5260 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Bjoern Ricks <bjoern.ricks@intevation.de>
date Fri, 24 Aug 2012 14:04:38 +0000
parents 08731e7403b5
children 4213dd6ca169
comparison
equal deleted inserted replaced
412:f4b14240ffa3 413:f5ecca16f601
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 41
41 users.delete.id=DELETE FROM users WHERE id = ? 42 users.delete.id=DELETE FROM users WHERE id = ?
42 43
43 users.delete.collections=DELETE FROM collections where owner_id = ? 44 users.delete.collections=DELETE FROM collections where owner_id = ?
44 45

http://dive4elements.wald.intevation.org