3 # This script is needed to convert from Bacula Enterprise 2.6 to 4.0 or
4 # Standard version 3.0 to 5.0
7 echo "This script will update a Bacula SQLite database from version 11 to 12"
8 echo " which is needed to convert from Bacula Enterprise 2.6 to 4.0 or "
9 echo " Standard version 3.0 to 5.0"
10 echo "Depending on the size of your database,"
11 echo "this script may take several minutes to run."
20 ${sqlite} $* ${db_name}.db <<END-OF-DATA
22 ALTER TABLE Job ADD COLUMN HasCache TINYINT DEFAULT 0;
23 ALTER TABLE Job ADD COLUMN Reviewed TINYINT DEFAULT 0;
24 ALTER TABLE Job ADD COLUMN Comment TEXT;
25 ALTER TABLE JobHisto ADD COLUMN HasCache TINYINT DEFAULT 0;
26 ALTER TABLE JobHisto ADD COLUMN Reviewed TINYINT DEFAULT 0;
27 ALTER TABLE JobHisto ADD COLUMN Comment TEXT;
29 ALTER TABLE Status ADD COLUMN Severity int;
30 UPDATE Status SET Severity = 15;
31 UPDATE Status SET Severity = 100 where JobStatus = 'f';
32 UPDATE Status SET Severity = 90 where JobStatus = 'A';
33 UPDATE Status SET Severity = 10 where JobStatus = 'T';
34 UPDATE Status SET Severity = 20 where JobStatus = 'e';
35 UPDATE Status SET Severity = 25 where JobStatus = 'E';
37 CREATE TABLE PathHierarchy
39 PathId integer NOT NULL,
40 PPathId integer NOT NULL,
41 CONSTRAINT pathhierarchy_pkey PRIMARY KEY (PathId)
44 CREATE INDEX pathhierarchy_ppathid
45 ON PathHierarchy (PPathId);
47 CREATE TABLE PathVisibility
49 PathId integer NOT NULL,
50 JobId integer NOT NULL,
53 CONSTRAINT pathvisibility_pkey PRIMARY KEY (JobId, PathId)
56 CREATE INDEX pathvisibility_jobid
57 ON PathVisibility (JobId);
59 CREATE INDEX basefiles_jobid_idx ON BaseFiles ( JobId );
61 UPDATE Version SET VersionId=12;
65 DROP INDEX IF EXISTS inx9;
66 CREATE INDEX file_jpf_idx ON File (JobId, PathId, FilenameId);