1BEGIN; -- Necessary for Bareos core 2 3-- 4-- We drop and recreate the stats table which was not used yet. 5-- 6DROP TABLE DeviceStats; 7CREATE TABLE DeviceStats ( 8 DeviceId INTEGER DEFAULT 0, 9 SampleTime TIMESTAMP WITHOUT TIME ZONE NOT NULL, 10 ReadTime BIGINT NOT NULL DEFAULT 0, 11 WriteTime BIGINT NOT NULL DEFAULT 0, 12 ReadBytes BIGINT DEFAULT 0, 13 WriteBytes BIGINT DEFAULT 0, 14 SpoolSize BIGINT DEFAULT 0, 15 NumWaiting SMALLINT DEFAULT 0, 16 NumWriters SMALLINT DEFAULT 0, 17 MediaId INTEGER NOT NULL, 18 VolCatBytes BIGINT DEFAULT 0, 19 VolCatFiles BIGINT DEFAULT 0, 20 VolCatBlocks BIGINT DEFAULT 0 21); 22 23-- 24-- We drop and recreate the stats table which was not used yet. 25-- 26DROP TABLE JobStats; 27CREATE TABLE JobStats ( 28 DeviceId INTEGER DEFAULT 0, 29 SampleTime TIMESTAMP WITHOUT TIME ZONE NOT NULL, 30 JobId INTEGER NOT NULL, 31 JobFiles INTEGER DEFAULT 0, 32 JobBytes BIGINT DEFAULT 0 33); 34 35CREATE TABLE TapeAlerts ( 36 DeviceId INTEGER DEFAULT 0, 37 SampleTime TIMESTAMP WITHOUT TIME ZONE NOT NULL, 38 AlertFlags BIGINT DEFAULT 0 39); 40 41DROP TABLE CDImages; 42 43UPDATE Version SET VersionId = 2003; 44COMMIT; 45 46set client_min_messages = fatal; 47 48ANALYSE; 49