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;
24 echo "Deletion of Bacula MySQL tables succeeded."
26 echo "Deletion of Bacula MySQL tables failed."