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
20 DROP TABLE MediaType\g
26 DROP TABLE LocationLog\g
28 DROP TABLE basefiles\g
29 DROP TABLE unsavedfiles\g
30 DROP TABLE CDImages \g
31 DROP TABLE PathHierarchy\g
32 DROP TABLE PathVisibility\g
35 DROP SEQUENCE filename_seq\g
36 DROP SEQUENCE path_seq\g
37 DROP SEQUENCE file_seq\g
38 DROP SEQUENCE Job_seq\g
39 DROP SEQUENCE JobHisto_seq\g
40 DROP SEQUENCE Location_seq\g
41 DROP SEQUENCE fileset_seq\g
42 DROP SEQUENCE jobmedia_seq\g
43 DROP SEQUENCE media_seq\g
44 DROP SEQUENCE MediaType_seq\g
45 DROP SEQUENCE Storage_seq\g
46 DROP SEQUENCE Device_seq\g
47 DROP SEQUENCE pool_seq\g
48 DROP SEQUENCE client_seq\g
49 DROP SEQUENCE Log_seq\g
50 DROP SEQUENCE LocationLog_seq\g
51 DROP SEQUENCE basefiles_seq\g
56 echo "Deletion of Bacula Ingres tables succeeded."
58 echo "Deletion of Bacula Ingres tables failed."