3 # shell script to delete Bacula tables for MySQL
7 if $bindir/mysql $* <<END-OF-DATA
9 DROP TABLE IF EXISTS Filename;
10 DROP TABLE IF EXISTS Path;
11 DROP TABLE IF EXISTS LongName;
12 DROP TABLE IF EXISTS Device;
13 DROP TABLE IF EXISTS Storage;
14 DROP TABLE IF EXISTS MediaType;
15 DROP TABLE IF EXISTS File;
16 DROP TABLE IF EXISTS Client;
17 DROP TABLE IF EXISTS Job;
18 DROP TABLE IF EXISTS Media;
19 DROP TABLE IF EXISTS JobMedia;
20 DROP TABLE IF EXISTS Pool;
21 DROP TABLE IF EXISTS MultiVolume;
22 DROP TABLE IF EXISTS FileSave;
23 DROP TABLE IF EXISTS FileSet;
24 DROP TABLE IF EXISTS Version;
25 DROP TABLE IF EXISTS Counters;
26 DROP TABLE IF EXISTS BaseFiles;
27 DROP TABLE IF EXISTS UnsavedFiles;
28 DROP TABLE IF EXISTS CDImages;
29 DROP TABLE IF EXISTS Status;
30 DROP TABLE IF EXISTS MAC;
31 DROP TABLE IF EXISTS Log;
32 DROP TABLE IF EXISTS Location;
33 DROP TABLE IF EXISTS LocationLog;
36 echo "Deletion of Bacula MySQL tables succeeded."
38 echo "Deletion of Bacula MySQL tables failed."