1CREATE TABLE NDMPJobEnvironment (
2   JobId INTEGER UNSIGNED NOT NULL REFERENCES Job,
3   FileIndex INTEGER UNSIGNED NOT NULL,
4   EnvName TINYBLOB NOT NULL,
5   EnvValue TINYBLOB NOT NULL,
6   CONSTRAINT NDMPJobEnvironment_pkey PRIMARY KEY (JobId, FileIndex, EnvName(256))
7);
8
9CREATE TABLE DeviceStats (
10   SampleTime DATETIME NOT NULL,
11   ReadTime BIGINT UNSIGNED DEFAULT 0,
12   WriteTime BIGINT UNSIGNED DEFAULT 0,
13   ReadBytes BIGINT UNSIGNED DEFAULT 0,
14   WriteBytes BIGINT UNSIGNED DEFAULT 0,
15   Spool INTEGER UNSIGNED DEFAULT 0,
16   Waiting INTEGER DEFAULT 0,
17   Writers INTEGER DEFAULT 0,
18   MediaId INTEGER UNSIGNED DEFAULT 0 REFERENCES Media,
19   VolCatBytes BIGINT UNSIGNED DEFAULT 0,
20   VolCatFiles BIGINT UNSIGNED DEFAULT 0,
21   VolCatBlocks BIGINT UNSIGNED DEFAULT 0
22);
23
24CREATE TABLE JobStats (
25   SampleTime DATETIME NOT NULL,
26   JobId INTEGER UNSIGNED NOT NULL REFERENCES Job,
27   JobFiles INTEGER UNSIGNED DEFAULT 0,
28   JobBytes BIGINT UNSIGNED DEFAULT 0
29);
30
31ALTER TABLE Media ADD COLUMN MinBlockSize INTEGER UNSIGNED DEFAULT 0;
32ALTER TABLE Media ADD COLUMN MaxBlockSize INTEGER UNSIGNED DEFAULT 0;
33
34ALTER TABLE Pool ADD COLUMN MinBlockSize INTEGER UNSIGNED DEFAULT 0;
35ALTER TABLE Pool ADD COLUMN MaxBlockSize INTEGER UNSIGNED DEFAULT 0;
36
37UPDATE Version SET VersionId = 2002;
38
39-- remove unsecure user entry,
40-- created by older Bareos versions,
41-- if configured to run without password
42DELETE FROM mysql.user where User='bareos' and Host="%" and Password="";
43FLUSH PRIVILEGES;
44