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 File;
13 DROP TABLE IF EXISTS Client;
14 DROP TABLE IF EXISTS Job;
15 DROP TABLE IF EXISTS Media;
16 DROP TABLE IF EXISTS JobMedia;
17 DROP TABLE IF EXISTS Pool;
18 DROP TABLE IF EXISTS MultiVolume;
19 DROP TABLE IF EXISTS FileSave;
20 DROP TABLE IF EXISTS FileSet;
21 DROP TABLE IF EXISTS Version;
22 DROP TABLE IF EXISTS Counters;
23 DROP TABLE IF EXISTS BaseFiles;
24 DROP TABLE IF EXISTS UnsavedFiles;
27 echo "Deletion of Bacula MySQL tables succeeded."
29 echo "Deletion of Bacula MySQL tables failed."