1#!/bin/sh
2#
3# Copyright (C) 2000-2020 Kern Sibbald
4# License: BSD 2-Clause; see file LICENSE-FOSS
5#
6#  Drop Bacula tables -- works for whatever is configured,
7#  MySQL, SQLite, Ingres, or PostgreSQL
8#
9
10# can be used to change the current user with su
11pre_command="sh -c"
12
13default_db_type=@DEFAULT_DB_TYPE@
14
15#
16# See if the first argument is a valid backend name.
17# If so the user overrides the default database backend.
18#
19if [ $# -gt 0 ]; then
20   case $1 in
21     sqlite3)
22       db_type=$1
23       shift
24       ;;
25     mysql)
26       db_type=$1
27       shift
28       ;;
29     postgresql)
30       db_type=$1
31       shift
32       ;;
33     *)
34       ;;
35   esac
36fi
37
38#
39# If no new db_type is gives use the default db_type.
40#
41if [ -z "${db_type}" ]; then
42   db_type="${default_db_type}"
43fi
44
45if [ $db_type = postgresql -a "$UID" = 0 ]; then
46    pre_command="su - postgres -c"
47fi
48
49$pre_command "@scriptdir@/drop_${db_type}_tables $*"
50echo "Dropped ${db_type} tables"
51