3 # Shell script to update MySQL tables from version 1.34 to 1.35.5
6 echo "This script will update a Bacula MySQL database from version 7 to 8"
7 echo "Depending on the size of your database,"
8 echo "this script may take several minutes to run."
12 if $bindir/mysql $* -f <<END-OF-DATA
15 ALTER TABLE Media ADD COLUMN LabelType INTEGER UNSIGNED NOT NULL DEFAULT 0;
16 ALTER TABLE Media ADD COLUMN VolParts INTEGER UNSIGNED NOT NULL DEFAULT 0;
20 echo "Update of Bacula MySQL tables succeeded."
22 echo "Update of Bacula MySQL tables failed."