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