From 70cf799aa79d4c1ee8961bc8c631c013214de738 Mon Sep 17 00:00:00 2001
From: Kern Sibbald <kern@sibbald.com>
Date: Mon, 29 May 2017 08:52:49 +0200
Subject: [PATCH] Fix database update scripts

---
 bacula/src/cats/update_mysql_tables.in      | 4 ++--
 bacula/src/cats/update_postgresql_tables.in | 4 ++--
 bacula/src/cats/update_sqlite3_tables.in    | 4 ++--
 3 files changed, 6 insertions(+), 6 deletions(-)

diff --git a/bacula/src/cats/update_mysql_tables.in b/bacula/src/cats/update_mysql_tables.in
index f33356feda..0c7329281c 100644
--- a/bacula/src/cats/update_mysql_tables.in
+++ b/bacula/src/cats/update_mysql_tables.in
@@ -35,10 +35,10 @@ if [ "x$DBVERSION" = x ]; then
     exit 1
 fi
 
-if [ "$DBVERSION" -lt 12 -o "$DBVERSION" -gt 14 ] ; then
+if [ "$DBVERSION" -lt 12 -o "$DBVERSION" -gt 15 ] ; then
     echo " "
     echo "The existing database is version $DBVERSION !!"
-    echo "This script can only update an existing version 12-14 version 15."
+    echo "This script can only update an existing version 12-15 to version 16."
     echo "Error. Cannot upgrade this database."
     echo " "
     exit 1
diff --git a/bacula/src/cats/update_postgresql_tables.in b/bacula/src/cats/update_postgresql_tables.in
index 3a7e4bc137..aa6400e075 100644
--- a/bacula/src/cats/update_postgresql_tables.in
+++ b/bacula/src/cats/update_postgresql_tables.in
@@ -34,10 +34,10 @@ if [ "x$DBVERSION" = x ]; then
     exit 1
 fi
 
-if [ "$DBVERSION" -lt 12 -o "$DBVERSION" -gt 14 ] ; then
+if [ "$DBVERSION" -lt 12 -o "$DBVERSION" -gt 15 ] ; then
     echo " "
     echo "The existing database is version $DBVERSION !!"
-    echo "This script can only update an existing version 12-14, 1014-1016 database to version 1017."
+    echo "This script can only update an existing version 12-15 database to version 16."
     echo "Error. Cannot upgrade this database."
     echo " "
     exit 1
diff --git a/bacula/src/cats/update_sqlite3_tables.in b/bacula/src/cats/update_sqlite3_tables.in
index 00be950baf..7595a2f56d 100644
--- a/bacula/src/cats/update_sqlite3_tables.in
+++ b/bacula/src/cats/update_sqlite3_tables.in
@@ -22,10 +22,10 @@ DBVERSION=`sqlite3 ${db_name}.db <<END
 SELECT VersionId FROM Version LIMIT 1;
 END
 `
-if [ "$DBVERSION" -lt 12 -o "$DBVERSION" -gt 14 ] ; then
+if [ "$DBVERSION" -lt 12 -o "$DBVERSION" -gt 15 ] ; then
     echo " "
     echo "The existing database is version $DBVERSION !!"
-    echo "This script can only update an existing version 12, 13, 14 or 1014 database to version 1015."
+    echo "This script can only update an existing version 12, 13, 14 or 15 database to version 16."
     echo "Error. Cannot upgrade this database."
     echo " "
     exit 1
-- 
2.39.2