/usr/lib/bareos/scripts/ddl/updates/postgresql.2001_2002.sql is in bareos-database-postgresql 14.2.1+20141017gitc6c5b56-3+deb8u3.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 | BEGIN; -- Necessary for Bareos core
CREATE TABLE NDMPJobEnvironment (
JobId INTEGER NOT NULL,
FileIndex INTEGER NOT NULL,
EnvName TEXT NOT NULL,
EnvValue TEXT NOT NULL,
CONSTRAINT NDMPJobEnvironment_pkey PRIMARY KEY (JobId, FileIndex, EnvName)
);
CREATE TABLE DeviceStats (
SampleTime TIMESTAMP WITHOUT TIME ZONE NOT NULL,
ReadTime BIGINT NOT NULL DEFAULT 0,
WriteTime BIGINT NOT NULL DEFAULT 0,
ReadBytes BIGINT DEFAULT 0,
WriteBytes BIGINT DEFAULT 0,
Spool SMALLINT DEFAULT 0,
Waiting SMALLINT DEFAULT 0,
Writers SMALLINT DEFAULT 0,
MediaId INTEGER NOT NULL,
VolCatBytes BIGINT DEFAULT 0,
VolCatFiles BIGINT DEFAULT 0,
VolCatBlocks BIGINT DEFAULT 0
);
CREATE TABLE JobStats (
SampleTime TIMESTAMP WITHOUT TIME ZONE NOT NULL,
JobId INTEGER NOT NULL,
JobFiles INTEGER DEFAULT 0,
JobBytes BIGINT DEFAULT 0
);
ALTER TABLE Media ADD COLUMN MinBlockSize INTEGER DEFAULT 0;
ALTER TABLE Media ADD COLUMN MaxBlockSize INTEGER DEFAULT 0;
ALTER TABLE Pool ADD COLUMN MinBlockSize INTEGER DEFAULT 0;
ALTER TABLE Pool ADD COLUMN MaxBlockSize INTEGER DEFAULT 0;
UPDATE Version SET VersionId = 2002;
COMMIT;
set client_min_messages = fatal;
ANALYSE;
|