Real fix of bug #1897

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

diff --git a/bacula/src/cats/drop_bacula_tables.in b/bacula/src/cats/drop_bacula_tables.in
index ebfb0be8a16d7473bd6f7031e3b285f5aef5cf07..f3534167bff11655eb2d092cc1806f576cc054e7 100755 (executable)
--- a/bacula/src/cats/drop_bacula_tables.in
+++ b/bacula/src/cats/drop_bacula_tables.in
@@ -1,12 +1,44 @@
 #!/bin/sh
 #
 #  Drop Bacula tables -- works for whatever is configured,
-#    MySQL or SQLite
-#
-if test xsqlite = x@DB_NAME@ ; then
-  source ./drop_sqlite_tables
-  echo "Dropped SQLite tables"
-else
-  source ./drop_mysql_tables
-  echo "Dropped MySQL tables"
+#  MySQL, SQLite, Ingres, or PostgreSQL
+#
+
+default_db_type=@DEFAULT_DB_TYPE@
+
+#
+# See if the first argument is a valid backend name.
+# If so the user overrides the default database backend.
+#
+if [ $# -gt 0 ]; then
+   case $1 in
+     sqlite3)
+       db_type=$1
+       shift
+       ;;
+     mysql)
+       db_type=$1
+       shift
+       ;;
+     postgresql)
+       db_type=$1
+       shift
+       ;;
+     ingres)
+       db_type=$1
+       shift
+       ;;
+     *)
+       ;;
+   esac
+fi
+
+#
+# If no new db_type is gives use the default db_type.
+#
+if [ -z "${db_type}" ]; then
+   db_type="${default_db_type}"
 fi
+
+@scriptdir@/drop_${db_type}_tables $*
+echo "Dropped ${db_type} tables"