Mercurial > dive4elements > river
diff flys-artifacts/src/main/resources/datacage-sql/org-h2-driver.properties @ 986:70545233f8ee
Datacage: Add users at initial scan.
flys-artifacts/trunk@2418 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Thu, 28 Jul 2011 15:07:20 +0000 |
| parents | 2b05c4a0c6fd |
| children | 82ef338fee91 |
line wrap: on
line diff
--- a/flys-artifacts/src/main/resources/datacage-sql/org-h2-driver.properties Thu Jul 28 14:38:51 2011 +0000 +++ b/flys-artifacts/src/main/resources/datacage-sql/org-h2-driver.properties Thu Jul 28 15:07:20 2011 +0000 @@ -1,2 +1,4 @@ delete.all.users = DELETE FROM users -insert.user = INSERT INTO users (gid) VALUES (?) +user.id.nextval = SELECT NEXTVAL('USERS_ID_SEQ') +user.by.gid = SELECT id FROM users WHERE gid = ? +insert.user = INSERT INTO users (id, gid) VALUES (?, ?)