Mercurial > dive4elements > framework
comparison artifact-database/src/main/resources/sql/org-postgresql-driver.properties @ 124:caf9f456f7e3
Added SQL statements to handle users in database.
artifacts/trunk@1348 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Tue, 01 Mar 2011 17:43:16 +0000 |
| parents | 8447467cef86 |
| children | 2950c6011afa |
comparison
equal
deleted
inserted
replaced
| 123:9187abefba8b | 124:caf9f456f7e3 |
|---|---|
| 20 creation = CURRENT_TIMESTAMP, last_access = CURRENT_TIMESTAMP, \ | 20 creation = CURRENT_TIMESTAMP, last_access = CURRENT_TIMESTAMP, \ |
| 21 ttl = ?, factory = ?, data = ? \ | 21 ttl = ?, factory = ?, data = ? \ |
| 22 WHERE id = ? | 22 WHERE id = ? |
| 23 | 23 |
| 24 artifacts.delete=DELETE FROM artifacts WHERE id = ? | 24 artifacts.delete=DELETE FROM artifacts WHERE id = ? |
| 25 | |
| 26 # USERS | |
| 27 | |
| 28 users.id.nextval=SELECT NEXTVAL('USERS_ID_SEQ') | |
| 29 | |
| 30 users.insert=INSERT INTO users (id, gid, name, role) VALUES (?, ?, ?, ?) | |
| 31 | |
| 32 users.select.gid=SELECT id, name, role FROM users WHERE gid = ?::uuid | |
| 33 | |
| 34 users.delete.gid=DELETE FROM users WHERE id = ? | |
| 35 | |
| 36 users.delete.collections=DELETE FROM collections where owner_id = ? | |
| 37 | |
| 38 users.select.all=SELECT id, gid, name, role FROM users |