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
14 DROP TABLE RestoreObject;
27 DROP TABLE LocationLog;
30 DROP TABLE UnsavedFiles;
32 DROP TABLE PathHierarchy;
33 DROP TABLE PathVisibility;
36 DROP SEQUENCE Filename_Seq;
37 DROP SEQUENCE Path_Seq;
38 DROP SEQUENCE File_Seq;
39 DROP SEQUENCE RestoreObject_Seq;
40 DROP SEQUENCE Job_Seq;
41 DROP SEQUENCE JobHisto_Seq;
42 DROP SEQUENCE Location_Seq;
43 DROP SEQUENCE Fileset_Seq;
44 DROP SEQUENCE JobMedia_Seq;
45 DROP SEQUENCE Media_Seq;
46 DROP SEQUENCE MediaType_Seq;
47 DROP SEQUENCE Storage_Seq;
48 DROP SEQUENCE Device_Seq;
49 DROP SEQUENCE Pool_Seq;
50 DROP SEQUENCE Client_Seq;
51 DROP SEQUENCE Log_Seq;
52 DROP SEQUENCE LocationLog_Seq;
53 DROP SEQUENCE BaseFiles_Seq;
59 echo "Deletion of Bacula Ingres tables succeeded."
61 echo "Deletion of Bacula Ingres tables failed."