From 62645376be9ea69118dbbac45ca6fb6f0beb7e31 Mon Sep 17 00:00:00 2001
From: Marco van Wieringen <mvw@planets.elm.net>
Date: Wed, 21 Apr 2010 20:31:38 +0200
Subject: [PATCH] reindent some Ingres DECLARE queries so they are better
 readable.

---
 bacula/src/cats/sql_cmds.c | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

diff --git a/bacula/src/cats/sql_cmds.c b/bacula/src/cats/sql_cmds.c
index 12da0d306b..c0a1a42dea 100644
--- a/bacula/src/cats/sql_cmds.c
+++ b/bacula/src/cats/sql_cmds.c
@@ -647,7 +647,7 @@ const char *create_temp_basefile[5] = {
    /* Ingres */
    "DECLARE GLOBAL TEMPORARY TABLE basefile%lld ("
    "Path VARBYTE(32000) NOT NULL,"
-   "Name VARBYTE(32000) NOT NULL)"
+   "Name VARBYTE(32000) NOT NULL) "
    "ON COMMIT PRESERVE ROWS WITH NORECOVERY"
 };
 
@@ -696,7 +696,7 @@ const char *create_temp_new_basefile[5] = {
    "FROM ( %s ) AS Temp "
    "JOIN Filename ON (Filename.FilenameId = Temp.FilenameId) "
    "JOIN Path ON (Path.PathId = Temp.PathId) "
-   "WHERE Temp.FileIndex > 0"
+   "WHERE Temp.FileIndex > 0 "
    "ON COMMIT PRESERVE ROWS WITH NORECOVERY",
 };
 
@@ -738,7 +738,7 @@ const char *create_deltabs[5] = {
    "PurgedFiles SMALLINT, "
    "FileSetId INTEGER, "
    "JobFiles INTEGER, "
-   "JobStatus CHAR(1))"
+   "JobStatus CHAR(1)) "
    "ON COMMIT PRESERVE ROWS WITH NORECOVERY"
 };
 
@@ -858,7 +858,7 @@ const char *uar_create_temp[5] = {
    "VolumeName VARBYTE(128),"
    "StartFile INTEGER,"
    "VolSessionId INTEGER,"
-   "VolSessionTime INTEGER)"
+   "VolSessionTime INTEGER) "
    "ON COMMIT PRESERVE ROWS WITH NORECOVERY"
 };
 
@@ -882,7 +882,7 @@ const char *uar_create_temp1[5] = {
    /* Ingres */
    "DECLARE GLOBAL TEMPORARY TABLE temp1 ("
    "JobId INTEGER NOT NULL,"
-   "JobTDate BIGINT)"
+   "JobTDate BIGINT) "
    "ON COMMIT PRESERVE ROWS WITH NORECOVERY"
    };
 
-- 
2.39.5