comparison artifact-database/src/main/resources/sql/org-h2-driver.properties @ 175:16e6e661e6bf

Added code to delete collections. artifacts/trunk@1401 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 04 Mar 2011 17:11:40 +0000
parents 940ed629419f
children a0eff2227588
comparison
equal deleted inserted replaced
174:25d472a67a9f 175:16e6e661e6bf
38 38
39 users.select.all=SELECT id, gid, name, role FROM users 39 users.select.all=SELECT id, gid, name, role FROM users
40 40
41 # COLLECTIONS 41 # COLLECTIONS
42 collections.id.nextval=SELECT NEXTVAL('COLLECTIONS_ID_SEQ') 42 collections.id.nextval=SELECT NEXTVAL('COLLECTIONS_ID_SEQ')
43
44 collections.id.by.gid=SELECT id FROM collections WHERE gid = ?
45
46 delete.collection.items=DELETE FROM collection_items WHERE collection_id = ?
47
48 delete.collection=DELETE FROM collections WHERE id = ?
43 49
44 delete.user.collection.items= \ 50 delete.user.collection.items= \
45 DELETE FROM collection_items WHERE collection_id IN \ 51 DELETE FROM collection_items WHERE collection_id IN \
46 (SELECT id FROM collections WHERE owner_id = ?) 52 (SELECT id FROM collections WHERE owner_id = ?)
47 53

http://dive4elements.wald.intevation.org