From 445209e876f573c3263e40d1de330ed63b819369 Mon Sep 17 00:00:00 2001 From: Marco van Wieringen Date: Thu, 10 Feb 2011 16:06:16 +0100 Subject: [PATCH] Tweak sql_cmds, remove unreferenced sql and reformat a sql query. --- bacula/src/cats/sql_cmds.c | 7 +------ 1 file changed, 1 insertion(+), 6 deletions(-) diff --git a/bacula/src/cats/sql_cmds.c b/bacula/src/cats/sql_cmds.c index b739d6d966..0327e4bfd5 100644 --- a/bacula/src/cats/sql_cmds.c +++ b/bacula/src/cats/sql_cmds.c @@ -217,11 +217,6 @@ const char *uar_sel_filesetid = "WHERE Job.ClientId=%s " "GROUP BY FileSet"; -/* Find MediaType used by this Job */ -const char *uar_mediatype = - "SELECT MediaType FROM JobMedia,Media WHERE JobMedia.JobId=%s " - "AND JobMedia.MediaId=Media.MediaId"; - /* * Find JobId, FileIndex for a given path/file and date * for use when inserting individual files into the tree. @@ -254,7 +249,7 @@ const char *uar_jobids_fileindex = /* Query to get list of files from table -- presuably built by an external program */ const char *uar_jobid_fileindex_from_table = - "SELECT JobId,FileIndex from %s"; + "SELECT JobId,FileIndex FROM %s"; /* Get the list of the last recent version per Delta with a given jobid list * This is a tricky part because with SQL the result of -- 2.39.5