Backport from Bacula Enterprise

[bacula/bacula] / bacula / src / cats / drop_mysql_tables.in

diff --git a/bacula/src/cats/drop_mysql_tables.in b/bacula/src/cats/drop_mysql_tables.in
index 4e543ea379e0c4bd614caf0b794203c1bfbc4272..6b3067f1f5c909e4e299b8bdcc170f1493643eb1 100644 (file)
--- a/bacula/src/cats/drop_mysql_tables.in
+++ b/bacula/src/cats/drop_mysql_tables.in
@@ -1,8 +1,11 @@
 #!/bin/sh
 #
+# Copyright (C) 2000-2015 Kern Sibbald
+# License: BSD 2-Clause; see file LICENSE-FOSS
+#
 # shell script to delete Bacula tables for MySQL
 
-bindir=@SQL_BINDIR@
+bindir=@MYSQL_BINDIR@
 db_name=@db_name@
 
 if $bindir/mysql $* <<END-OF-DATA
@@ -16,7 +19,7 @@ DROP TABLE IF EXISTS MediaType;
 DROP TABLE IF EXISTS File;
 DROP TABLE IF EXISTS Client;
 DROP TABLE IF EXISTS Job;
-DROP TABLE IF EXISTS JobStat;
+DROP TABLE IF EXISTS JobHisto;
 DROP TABLE IF EXISTS Media;
 DROP TABLE IF EXISTS JobMedia;
 DROP TABLE IF EXISTS Pool;
@@ -33,6 +36,10 @@ DROP TABLE IF EXISTS MAC;
 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;
+DROP TABLE IF EXISTS Snapshot;
 END-OF-DATA
 then
    echo "Deletion of ${db_name} MySQL tables succeeded."