From 61a268d086d2e3fc7e5902cb6083ca5360dd870f Mon Sep 17 00:00:00 2001 From: Simon Rettberg Date: Mon, 20 Jul 2015 12:20:16 +0200 Subject: [server] Simplified db schema a bit --- .../main/java/org/openslx/bwlp/sat/database/mappers/DbSoftwareTag.java | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'dozentenmodulserver/src/main/java') diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbSoftwareTag.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbSoftwareTag.java index 6cabd021..44e50090 100644 --- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbSoftwareTag.java +++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbSoftwareTag.java @@ -54,8 +54,7 @@ public class DbSoftwareTag { } public static List getImageTags(MysqlConnection connection, String imageBaseId) throws SQLException { - MysqlStatement stmt = connection.prepareStatement("SELECT displayname FROM tag" - + " INNER JOIN imagebase_x_tag USING (tagid)" + MysqlStatement stmt = connection.prepareStatement("SELECT tagname FROM imagetag" + " WHERE imagebaseid = :imagebaseid"); stmt.setString("imagebaseid", imageBaseId); ResultSet rs = stmt.executeQuery(); -- cgit v1.2.3-55-g7522