#
# shell script to delete Bacula tables for MySQL
-bindir=@SQL_BINDIR@
+bindir=@MYSQL_BINDIR@
db_name=@db_name@
if $bindir/mysql $* <<END-OF-DATA
DROP TABLE IF EXISTS File;
DROP TABLE IF EXISTS Client;
DROP TABLE IF EXISTS Job;
-DROP TABLE IF EXISTS JobHistory;
+DROP TABLE IF EXISTS JobHisto;
DROP TABLE IF EXISTS Media;
DROP TABLE IF EXISTS JobMedia;
DROP TABLE IF EXISTS Pool;
DROP TABLE IF EXISTS Log;
DROP TABLE IF EXISTS Location;
DROP TABLE IF EXISTS LocationLog;
+DROP TABLE IF EXISTS PathVisibility;
+DROP TABLE IF EXISTS PathHierarchy;
+DROP TABLE IF EXISTS RestoreObject;
END-OF-DATA
then
echo "Deletion of ${db_name} MySQL tables succeeded."