1BEGIN; -- Necessary for Bacula core
2
3CREATE TABLE RestoreObject (
4   RestoreObjectId SERIAL NOT NULL,
5   ObjectName TEXT NOT NULL,
6   RestoreObject BYTEA NOT NULL,
7   PluginName TEXT NOT NULL,
8   ObjectLength INTEGER DEFAULT 0,
9   ObjectFullLength INTEGER DEFAULT 0,
10   ObjectIndex INTEGER DEFAULT 0,
11   ObjectType INTEGER DEFAULT 0,
12   FileIndex INTEGER DEFAULT 0,
13   JobId INTEGER,
14   ObjectCompression INTEGER DEFAULT 0,
15   PRIMARY KEY(RestoreObjectId)
16);
17CREATE INDEX restore_jobid_idx on RestoreObject(JobId);
18
19ALTER TABLE File ADD COLUMN DeltaSeq smallint default 0;
20
21UPDATE Version SET VersionId=14;
22COMMIT;
23
24set client_min_messages = fatal;
25CREATE INDEX media_poolid_idx on Media (PoolId);
26
27ANALYSE;
28