From 5590d36b9538f1084ae29e0be851ac4adba4252a Mon Sep 17 00:00:00 2001
From: Dan Langille <dan@langille.org>
Date: Wed, 10 Dec 2003 19:09:37 +0000
Subject: [PATCH] For symmetry, add this file.  At present, all it does is
 update the version table.

git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@855 91ce42f0-d328-0410-95d8-f526ca767f89
---
 bacula/src/cats/update_postgresql_tables.in | 22 +++++++++++++++++++++
 1 file changed, 22 insertions(+)
 create mode 100755 bacula/src/cats/update_postgresql_tables.in

diff --git a/bacula/src/cats/update_postgresql_tables.in b/bacula/src/cats/update_postgresql_tables.in
new file mode 100755
index 0000000000..5a1d492814
--- /dev/null
+++ b/bacula/src/cats/update_postgresql_tables.in
@@ -0,0 +1,22 @@
+#!/bin/sh
+#
+# Shell script to update PostgreSQL tables
+#
+echo " "
+echo "Depending on the size of your database,"
+echo "this script may take several minutes to run."
+echo " "
+bindir=@SQL_BINDIR@
+
+if $bindir/psql $* -f - <<END-OF-DATA
+\c bacula
+
+UPDATE Version SET VersionId=7;
+
+END-OF-DATA
+then
+   echo "Update of Bacula PostgreSQL tables succeeded."
+else
+   echo "Update of Bacula PostgreSQL tables failed."
+fi
+exit 0
-- 
2.39.5