From 598c8f34db72715576e8009ad119a12745dc2a13 Mon Sep 17 00:00:00 2001
From: Marco van Wieringen <mvw@planets.elm.net>
Date: Fri, 26 Mar 2010 21:09:36 +0100
Subject: [PATCH] Fix array dimensions due to adding Ingres to certain sql
 arrays.

---
 bacula/src/cats/sql_cmds.c   | 6 +++---
 bacula/src/cats/sql_cmds.h   | 6 +++---
 bacula/src/cats/sql_create.c | 2 +-
 3 files changed, 7 insertions(+), 7 deletions(-)

diff --git a/bacula/src/cats/sql_cmds.c b/bacula/src/cats/sql_cmds.c
index 18c0ac968f..c930e6369d 100644
--- a/bacula/src/cats/sql_cmds.c
+++ b/bacula/src/cats/sql_cmds.c
@@ -612,7 +612,7 @@ const char *select_recent_version[4] = {
 /* ====== ua_prune.c */
 
 /* List of SQL commands to create temp table and indicies  */
-const char *create_deltabs[4] = {
+const char *create_deltabs[5] = {
    /* MySQL */
    "CREATE TEMPORARY TABLE DelCandidates ("
    "JobId INTEGER UNSIGNED NOT NULL, "
@@ -692,7 +692,7 @@ const char *uar_file[4] = {
    "AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId "
    "AND Filename.Name='%s' ORDER BY StartTime DESC LIMIT 20"};
 
-const char *uar_create_temp[4] = {
+const char *uar_create_temp[5] = {
    /* Mysql */
    "CREATE TEMPORARY TABLE temp ("
    "JobId INTEGER UNSIGNED NOT NULL,"
@@ -761,7 +761,7 @@ const char *uar_create_temp[4] = {
    "ON COMMIT PRESERVE ROWS WITH NORECOVERY"
    };
 
-const char *uar_create_temp1[4] = {
+const char *uar_create_temp1[5] = {
    /* Mysql */
    "CREATE TEMPORARY TABLE temp1 ("
    "JobId INTEGER UNSIGNED NOT NULL,"
diff --git a/bacula/src/cats/sql_cmds.h b/bacula/src/cats/sql_cmds.h
index 10cf606f28..e72bd36c7a 100644
--- a/bacula/src/cats/sql_cmds.h
+++ b/bacula/src/cats/sql_cmds.h
@@ -75,11 +75,11 @@ extern const char CATS_IMP_EXP *uar_sel_jobid_temp;
 
 extern const char CATS_IMP_EXP *select_recent_version[4];
 extern const char CATS_IMP_EXP *select_recent_version_with_basejob[4];
-extern const char CATS_IMP_EXP *create_deltabs[4];
+extern const char CATS_IMP_EXP *create_deltabs[5];
 
 extern const char CATS_IMP_EXP *uar_file[4];
-extern const char CATS_IMP_EXP *uar_create_temp[4];
-extern const char CATS_IMP_EXP *uar_create_temp1[4];
+extern const char CATS_IMP_EXP *uar_create_temp[5];
+extern const char CATS_IMP_EXP *uar_create_temp1[5];
 extern const char CATS_IMP_EXP *uar_jobid_fileindex_from_dir[4];
 extern const char CATS_IMP_EXP *sql_get_max_connections[4];
 extern const uint32_t CATS_IMP_EXP sql_get_max_connections_index[4];
diff --git a/bacula/src/cats/sql_create.c b/bacula/src/cats/sql_create.c
index 510358ffe0..0eb2fbc5f0 100644
--- a/bacula/src/cats/sql_create.c
+++ b/bacula/src/cats/sql_create.c
@@ -1091,7 +1091,7 @@ bool db_write_batch_file_records(JCR *jcr)
 
 
 /* List of SQL commands to create temp table and indicies  */
-const char *create_temp_basefile[4] = {
+const char *create_temp_basefile[5] = {
    /* MySQL */
    "CREATE TEMPORARY TABLE basefile%lld ("
 //   "CREATE TABLE basefile%lld ("
-- 
2.39.5