3 # Shell script to update MySQL tables from version 1.38 to 2.0
6 echo "This script will update a Bacula MySQL database from version 9 to 10"
7 echo " which is needed to convert from Bacula version 1.38.x to 2.0.x or higher"
8 echo "Depending on the size of your database,"
9 echo "this script may take several minutes to run."
13 db_name=${db_name:-@db_name@}
15 if mysql $* -f <<END-OF-DATA
18 DROP TABLE IF EXISTS MAC;
19 DROP TABLE IF EXISTS Log;
20 DROP TABLE IF EXISTS Location;
21 DROP TABLE IF EXISTS LocationLog;
24 LogId INTEGER UNSIGNED AUTO_INCREMENT,
25 JobId INTEGER UNSIGNED DEFAULT 0 REFERENCES Job,
26 Time DATETIME DEFAULT 0,
27 LogText BLOB NOT NULL,
32 CREATE TABLE Location (
33 LocationId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
34 Location TINYBLOB NOT NULL,
35 Cost INTEGER DEFAULT 0,
37 PRIMARY KEY(LocationId)
40 CREATE TABLE LocationLog (
41 LocLogId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
42 Date DATETIME DEFAULT 0,
44 MediaId INTEGER UNSIGNED DEFAULT 0 REFERENCES Media,
45 LocationId INTEGER UNSIGNED DEFAULT 0 REFERENCES Location,
46 NewVolStatus ENUM('Full', 'Archive', 'Append', 'Recycle', 'Purged',
47 'Read-Only', 'Disabled', 'Error', 'Busy', 'Used', 'Cleaning') NOT NULL,
52 ALTER TABLE Media ADD COLUMN MediaTypeId INTEGER UNSIGNED DEFAULT 0 REFERENCES MediaType;
53 ALTER TABLE Media ADD COLUMN DeviceId INTEGER UNSIGNED DEFAULT 0 REFERENCES Device;
54 ALTER TABLE Media ADD COLUMN LocationId INTEGER UNSIGNED DEFAULT 0 REFERENCES Location;
55 ALTER TABLE Media ADD COLUMN RecycleCount INTEGER UNSIGNED DEFAULT 0;
56 ALTER TABLE Media ADD COLUMN InitialWrite DATETIME DEFAULT 0;
57 ALTER TABLE Media ADD COLUMN ScratchPoolId INTEGER UNSIGNED DEFAULT 0 REFERENCES Pool;
58 ALTER TABLE Media ADD COLUMN RecyclePoolId INTEGER UNSIGNED DEFAULT 0 REFERENCES Pool;
59 ALTER TABLE Media ADD COLUMN Enabled TINYINT DEFAULT 1;
60 ALTER TABLE Media ADD COLUMN Comment BLOB;
62 ALTER TABLE JobMedia DROP COLUMN Stripe;
64 ALTER TABLE Job ADD COLUMN PriorJobId INTEGER UNSIGNED DEFAULT 0 REFERENCES Job;
65 ALTER TABLE Job ADD COLUMN RealEndTime DATETIME DEFAULT 0;
70 INSERT INTO Version (VersionId) VALUES (10);
74 echo "Update of Bacula MySQL tables succeeded."
76 echo "Update of Bacula MySQL tables failed."