comparison flys-artifacts/src/main/resources/datacage-sql/org-h2-driver.properties @ 1006:1917f32701dc

Forwarded kill collections and artifacts events to datacage. flys-artifacts/trunk@2447 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 02 Aug 2011 11:38:20 +0000
parents 0e8c03b69627
children 02c327ffbad7
comparison
equal deleted inserted replaced
1005:52949da92f7a 1006:1917f32701dc
23 delete.collection.by.gid = DELETE FROM collections WHERE gid = ? 23 delete.collection.by.gid = DELETE FROM collections WHERE gid = ?
24 delete.user.by.gid = DELETE FROM user WHERE gid = ? 24 delete.user.by.gid = DELETE FROM user WHERE gid = ?
25 delete.artifact.data.by.artifact.id = DELETE FROM artifact_data WHERE artifact_id = ? 25 delete.artifact.data.by.artifact.id = DELETE FROM artifact_data WHERE artifact_id = ?
26 delete.outs.by.artifact.id = DELETE FROM outs WHERE artifact_id = ? 26 delete.outs.by.artifact.id = DELETE FROM outs WHERE artifact_id = ?
27 delete.facets.by.artifact.id = DELETE FROM facets WHERE out_id IN (SELECT id FROM outs WHERE artifact_id = ?) 27 delete.facets.by.artifact.id = DELETE FROM facets WHERE out_id IN (SELECT id FROM outs WHERE artifact_id = ?)
28
29 delete.artifact.by.gid = DELETE FROM artifacts WHERE gid = ?

http://dive4elements.wald.intevation.org