3 # Shell script to update MySQL tables from version 2.0 to 3.0
6 echo "This script will update a Bacula MySQL database from version 10 to 11"
7 echo " which is needed to convert from Bacula version 2.0.x to 3.0.x or higher"
12 if $bindir/mysql $* -f <<END-OF-DATA
15 -- Create a table like Job for long term statistics
16 CREATE TABLE JobHistory (LIKE Job);
18 -- Fix bad index on Media table
20 CREATE UNIQUE INDEX inx8 ON Media (VolumeName(128));
23 INSERT INTO Version (VersionId) VALUES (11);
27 echo "Update of Bacula MySQL tables succeeded."
29 echo "Update of Bacula MySQL tables failed."