Mercurial > dive4elements > river

annotate flys-artifacts/src/main/resources/datacage-sql/org-h2-driver.properties @ 986:70545233f8ee

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
rev   line source
984
2b05c4a0c6fd Datacage: clear database before initial scan
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 983
diff changeset
1 delete.all.users = DELETE FROM users
986
70545233f8ee Datacage: Add users at initial scan.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 984
diff changeset
2 user.id.nextval = SELECT NEXTVAL('USERS_ID_SEQ')
70545233f8ee Datacage: Add users at initial scan.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 984
diff changeset
3 user.by.gid = SELECT id FROM users WHERE gid = ?
70545233f8ee Datacage: Add users at initial scan.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 984
diff changeset
4 insert.user = INSERT INTO users (id, gid) VALUES (?, ?)
http://dive4elements.wald.intevation.org