#!/bin/sh
#
# shell script to delete Bareos tables for PostgreSQL

bindir=/usr/bin
db_name=bareos

$bindir/psql -f - -d ${db_name} $* <<END-OF-DATA
DROP TABLE unsavedfiles;
DROP TABLE basefiles;
DROP TABLE jobmedia;
DROP TABLE file;
DROP TABLE job;
DROP TABLE jobhisto;
DROP TABLE media;
DROP TABLE client;
DROP TABLE pool;
DROP TABLE fileset;
DROP TABLE path;
DROP TABLE filename;
DROP TABLE counters;
DROP TABLE version;
DROP TABLE CDImages;
DROP TABLE Device;
DROP TABLE Storage;
DROP TABLE MediaType;
DROP TABLE Status;
DROP TABLE Quota;
DROP TABLE NDMPLevelMap;
DROP TABLE MAC;
DROP TABLE log;
DROP TABLE Location;
DROP TABLE locationlog;
DROP TABLE PathVisibility;
DROP TABLE PathHierarchy;
DROP TABLE RestoreObject;
END-OF-DATA
pstat=$?
if test $pstat = 0;
then
   echo "Deletion of Bareos PostgreSQL tables succeeded."
else
   echo "Deletion of Bareos PostgreSQL tables failed."
fi
exit $pstat
