3 # shell script to delete Bacula tables for PostgreSQL
7 db_name=${db_name:-@db_name@}
8 db_user=${db_user:-@db_user@}
10 sql -u${db_user} ${db_name} $* <<END-OF-DATA
26 DROP TABLE LocationLog;
29 DROP TABLE unsavedfiles;
31 DROP TABLE PathHierarchy;
32 DROP TABLE PathVisibility;
35 DROP SEQUENCE filename_seq;
36 DROP SEQUENCE path_seq;
37 DROP SEQUENCE file_seq;
38 DROP SEQUENCE Job_seq;
39 DROP SEQUENCE JobHisto_seq;
40 DROP SEQUENCE Location_seq;
41 DROP SEQUENCE fileset_seq;
42 DROP SEQUENCE jobmedia_seq;
43 DROP SEQUENCE media_seq;
44 DROP SEQUENCE MediaType_seq;
45 DROP SEQUENCE Storage_seq;
46 DROP SEQUENCE Device_seq;
47 DROP SEQUENCE pool_seq;
48 DROP SEQUENCE client_seq;
49 DROP SEQUENCE Log_seq;
50 DROP SEQUENCE LocationLog_seq;
51 DROP SEQUENCE basefiles_seq;
57 echo "Deletion of Bacula Ingres tables succeeded."
59 echo "Deletion of Bacula Ingres tables failed."