Convert restore object to use STREAM_RESTORE_OBJECT; cleaner code

[bacula/bacula] / bacula / src / cats / make_postgresql_tables.in

diff --git a/bacula/src/cats/make_postgresql_tables.in b/bacula/src/cats/make_postgresql_tables.in
index 4339a28ebd0b86eb0ad40326ad600cccef39084b..dae28e4c8afc3c3b6b1f91820e42b4abca2f3fe8 100644 (file)
--- a/bacula/src/cats/make_postgresql_tables.in
+++ b/bacula/src/cats/make_postgresql_tables.in
@@ -62,8 +62,7 @@ CREATE INDEX file_jobid_idx on file(jobid);
 
 CREATE TABLE RestoreObject (
    RestoreObjectId SERIAL NOT NULL,
-   Fname TEXT NOT NULL,
-   Path TEXT NOT NULL,
+   ObjectName TEXT NOT NULL,
    RestoreObject TEXT NOT NULL,
    PluginName TEXT NOT NULL,
    ObjectLength INTEGER DEFAULT 0,
@@ -71,6 +70,7 @@ CREATE TABLE RestoreObject (
    ObjectType INTEGER DEFAULT 0,
    FileIndex INTEGER UNSIGNED DEFAULT 0,
    JobId INTEGER UNSIGNED,
+   ObjectCompression INTEGER DEFAULT 0,
    PRIMARY KEY(RestoreObjectId),
    );
 CREATE INDEX restore_jobid_idx on file(JobId);