From b5a9e41199297cefc8c1e0cffc8a188144a463ed Mon Sep 17 00:00:00 2001 From: Kern Sibbald Date: Wed, 24 May 2017 18:07:43 +0200 Subject: [PATCH] Put FilenameId in .bvfs_lsfiles output --- bacula/src/cats/sql_cmds.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/bacula/src/cats/sql_cmds.c b/bacula/src/cats/sql_cmds.c index c6bfc525d3..0625f3f4ee 100644 --- a/bacula/src/cats/sql_cmds.c +++ b/bacula/src/cats/sql_cmds.c @@ -736,7 +736,7 @@ const char *sql_bvfs_select[] = }; static const char *sql_bvfs_list_files_default = -"SELECT 'F', T1.PathId, Filename.Name, " +"SELECT 'F', T1.PathId, File.FilenameId, " "File.JobId, File.LStat, File.FileId " "FROM Job, File, ( " "SELECT MAX(JobTDate) AS JobTDate, PathId, FilenameId " @@ -770,7 +770,7 @@ const char *sql_bvfs_list_files[] = { /* JobId PathId JobId PathId WHERE? Filename? Limit Offset*/ /* Postgresql */ - "SELECT Type, PathId, Name, JobId, LStat, FileId " + "SELECT Type, PathId, FilenameId, JobId, LStat, FileId " "FROM (" "SELECT DISTINCT ON (FilenameId) 'F' as Type, PathId, T.FilenameId, " "Filename.Name, JobId, LStat, FileId, FileIndex " -- 2.39.5