Mercurial > dive4elements > framework
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 |