#!/bin/sh
#
-# Shell script to update MySQL tables from version 1.38 to 1.39
+# Shell script to update MySQL tables from version 1.38 to 2.0
#
echo " "
-echo "This script will update a Bacula SQLite database from version 9 to 10"
-echo " which is needed to convert from Bacula version 1.38.x to 1.39.x or higher"
+echo "This script will update a Bacula MySQL database from version 9 to 10"
+echo " which is needed to convert from Bacula version 1.38.x to 2.0.x or higher"
echo "Depending on the size of your database,"
echo "this script may take several minutes to run."
echo " "
bindir=@SQL_BINDIR@
+db_name=@db_name@
if $bindir/mysql $* -f <<END-OF-DATA
-USE bacula;
+USE ${db_name};
DROP TABLE IF EXISTS MAC;
DROP TABLE IF EXISTS Log;