#
# shell script to delete Bacula tables for PostgreSQL
-bindir=@SQL_BINDIR@
+bindir=@POSTGRESQL_BINDIR@
db_name=@db_name@
$bindir/psql -f - -d ${db_name} $* <<END-OF-DATA
drop table jobmedia;
drop table file;
drop table job;
-drop table jobstat;
+drop table jobhisto;
drop table media;
drop table client;
drop table pool;
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;