comparison artifact-database/src/main/resources/sql/org-h2-driver.properties @ 407:08731e7403b5

Update sql user queries to add the account column artifacts/trunk@5243 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Bjoern Ricks <bjoern.ricks@intevation.de>
date Thu, 23 Aug 2012 13:35:16 +0000
parents 2d525562fae9
children f5ecca16f601
comparison
equal deleted inserted replaced
406:10aa92f2eca0 407:08731e7403b5
31 31
32 # USERS 32 # USERS
33 33
34 users.id.nextval=SELECT NEXTVAL('USERS_ID_SEQ') 34 users.id.nextval=SELECT NEXTVAL('USERS_ID_SEQ')
35 35
36 users.insert=INSERT INTO users (id, gid, name, 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, role FROM users WHERE gid = ? 39 users.select.gid=SELECT id, name, account, role FROM users WHERE gid = ?
40 40
41 users.delete.id=DELETE FROM users WHERE id = ? 41 users.delete.id=DELETE FROM users WHERE id = ?
42 42
43 users.delete.collections=DELETE FROM collections where owner_id = ? 43 users.delete.collections=DELETE FROM collections where owner_id = ?
44 44
45 users.select.all=SELECT id, gid, name, role FROM users 45 users.select.all=SELECT id, gid, name, account, role FROM users
46 46
47 collection.check.artifact=SELECT id FROM collection_items \ 47 collection.check.artifact=SELECT id FROM collection_items \
48 WHERE artifact_id = ? AND collection_id = ? 48 WHERE artifact_id = ? AND collection_id = ?
49 49
50 # COLLECTION ITEMS 50 # COLLECTION ITEMS

http://dive4elements.wald.intevation.org