- Add index file to JobId field of File records for PostgreSQL.

[bacula/bacula] / bacula / src / dird / sql_cmds.c

diff --git a/bacula/src/dird/sql_cmds.c b/bacula/src/dird/sql_cmds.c
index 0058374b5044115bf68d919d90d26cd08bc7d06c..10768d312d3c70fa34fd2360dd8ac3b4e7ffaf79 100644 (file)
--- a/bacula/src/dird/sql_cmds.c
+++ b/bacula/src/dird/sql_cmds.c
@@ -185,7 +185,7 @@ const char *uar_file =
    "FROM Client,Job,File,Filename,Path WHERE Client.ClientId=Job.ClientId "
    "AND JobStatus='T' AND Job.JobId=File.JobId "
    "AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId "
-   "AND Filename.Name='%s' LIMIT 20";
+   "AND Filename.Name='%s' ORDER BY StartTime DESC LIMIT 20";
 #else
 /* List Jobs where a particular file is saved */
 const char *uar_file = 
@@ -195,7 +195,7 @@ const char *uar_file =
    "FROM Client,Job,File,Filename,Path WHERE Client.ClientId=Job.ClientId "
    "AND JobStatus='T' AND Job.JobId=File.JobId "
    "AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId "
-   "AND Filename.Name='%s' LIMIT 20";
+   "AND Filename.Name='%s' ORDER BY StartTime DESC LIMIT 20";
 #endif