From 6559b38fedf01257809f485e0b21bf61c22d9d7f Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Fri, 28 Jan 2011 15:52:36 +0100 Subject: [PATCH] Tweak ident some queries --- bacula/src/cats/sql_cmds.c | 44 +++++++++++++++++++------------------- 1 file changed, 22 insertions(+), 22 deletions(-) diff --git a/bacula/src/cats/sql_cmds.c b/bacula/src/cats/sql_cmds.c index 6f52796a8d..387621e4f3 100644 --- a/bacula/src/cats/sql_cmds.c +++ b/bacula/src/cats/sql_cmds.c @@ -1,4 +1,4 @@ -/* +&/* Bacula® - The Network Backup Solution Copyright (C) 2002-2010 Free Software Foundation Europe e.V. @@ -966,50 +966,50 @@ const char *batch_unlock_tables_query[] = { const char *batch_fill_path_query[] = { /* Mysql */ "INSERT INTO Path (Path) " - "SELECT a.Path FROM " - "(SELECT DISTINCT Path FROM batch) AS a WHERE NOT EXISTS " - "(SELECT Path FROM Path AS p WHERE p.Path = a.Path)", + "SELECT a.Path FROM " + "(SELECT DISTINCT Path FROM batch) AS a WHERE NOT EXISTS " + "(SELECT Path FROM Path AS p WHERE p.Path = a.Path)", /* Postgresql */ "INSERT INTO Path (Path) " - "SELECT a.Path FROM " - "(SELECT DISTINCT Path FROM batch) AS a " - "WHERE NOT EXISTS (SELECT Path FROM Path WHERE Path = a.Path) ", + "SELECT a.Path FROM " + "(SELECT DISTINCT Path FROM batch) AS a " + "WHERE NOT EXISTS (SELECT Path FROM Path WHERE Path = a.Path) ", /* SQLite3 */ "INSERT INTO Path (Path) " - "SELECT DISTINCT Path FROM batch " - "EXCEPT SELECT Path FROM Path", + "SELECT DISTINCT Path FROM batch " + "EXCEPT SELECT Path FROM Path", /* Ingres */ "INSERT INTO Path (Path) " - "SELECT DISTINCT b.Path FROM batch b " - "WHERE NOT EXISTS (SELECT Path FROM Path p WHERE p.Path = b.Path)" + "SELECT DISTINCT b.Path FROM batch b " + "WHERE NOT EXISTS (SELECT Path FROM Path p WHERE p.Path = b.Path)" }; const char *batch_fill_filename_query[] = { /* Mysql */ "INSERT INTO Filename (Name) " - "SELECT a.Name FROM " - "(SELECT DISTINCT Name FROM batch) AS a WHERE NOT EXISTS " - "(SELECT Name FROM Filename AS f WHERE f.Name = a.Name)", + "SELECT a.Name FROM " + "(SELECT DISTINCT Name FROM batch) AS a WHERE NOT EXISTS " + "(SELECT Name FROM Filename AS f WHERE f.Name = a.Name)", /* Postgresql */ "INSERT INTO Filename (Name) " - "SELECT a.Name FROM " - "(SELECT DISTINCT Name FROM batch) as a " - "WHERE NOT EXISTS " - "(SELECT Name FROM Filename WHERE Name = a.Name)", + "SELECT a.Name FROM " + "(SELECT DISTINCT Name FROM batch) as a " + "WHERE NOT EXISTS " + "(SELECT Name FROM Filename WHERE Name = a.Name)", /* SQLite3 */ "INSERT INTO Filename (Name) " - "SELECT DISTINCT Name FROM batch " - "EXCEPT SELECT Name FROM Filename", + "SELECT DISTINCT Name FROM batch " + "EXCEPT SELECT Name FROM Filename", /* Ingres */ "INSERT INTO Filename (Name) " - "SELECT DISTINCT b.Name FROM batch b " - "WHERE NOT EXISTS (SELECT Name FROM Filename f WHERE f.Name = b.Name)" + "SELECT DISTINCT b.Name FROM batch b " + "WHERE NOT EXISTS (SELECT Name FROM Filename f WHERE f.Name = b.Name)" }; const char *match_query[] = { -- 2.39.5