comparison artifact-database/src/main/resources/sql/org-h2-driver.properties @ 317:824051dff018

When loading all artifacts fetch the name of the collections, too. artifacts/trunk@2453 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 02 Aug 2011 14:05:34 +0000
parents 31ee2b3b5a57
children 61017c6031b8
comparison
equal deleted inserted replaced
316:0ca9b1073ccf 317:824051dff018
181 181
182 collection.set.attribute= \ 182 collection.set.attribute= \
183 UPDATE collections SET attribute = ? WHERE gid = ? 183 UPDATE collections SET attribute = ? WHERE gid = ?
184 184
185 all.artifacts = \ 185 all.artifacts = \
186 SELECT u.gid AS u_gid, c.gid AS c_gid, a.gid AS a_gid, a.factory AS factory, a.data AS data FROM \ 186 SELECT u.gid AS u_gid, c.gid AS c_gid, c.name as name, \
187 a.gid AS a_gid, a.factory AS factory, a.data AS data \
188 FROM \
187 users u INNER JOIN collections c ON u.id = c.owner_id \ 189 users u INNER JOIN collections c ON u.id = c.owner_id \
188 INNER JOIN collection_items ci ON c.id = ci.collection_id \ 190 INNER JOIN collection_items ci ON c.id = ci.collection_id \
189 INNER JOIN artifacts a ON a.id = ci.artifact_id \ 191 INNER JOIN artifacts a ON a.id = ci.artifact_id \
190 ORDER BY u_gid, c_gid 192 ORDER BY u_gid, c_gid

http://dive4elements.wald.intevation.org