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 EndFile INTEGER UNSIGNED NOT NULL DEFAULT 0;
16 ALTER TABLE Media ADD COLUMN EndBlock INTEGER UNSIGNED NOT NULL DEFAULT 0;
18 ALTER TABLE File ADD INDEX (JobId, PathId, FilenameId);
20 UPDATE Filename SET Name='' WHERE Name=' ';
22 CREATE TABLE CDImages (
23 MediaId INTEGER UNSIGNED NOT NULL,
24 LastBurn DATETIME NOT NULL,
29 INSERT INTO Version (VersionId) VALUES (8);
33 echo "Update of Bacula MySQL tables succeeded."
35 echo "Update of Bacula MySQL tables failed."