Convert restore object to use STREAM_RESTORE_OBJECT; cleaner code

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

diff --git a/bacula/src/cats/make_sqlite3_tables.in b/bacula/src/cats/make_sqlite3_tables.in
index 40a17e9c4f413d4e8c6a5c42bccf460884831393..3c72458824d144db39a403a14f2e7cee79692983 100644 (file)
--- a/bacula/src/cats/make_sqlite3_tables.in
+++ b/bacula/src/cats/make_sqlite3_tables.in
@@ -51,16 +51,16 @@ CREATE INDEX file_jpf_idx ON File (JobId, PathId, FilenameId);
 
 CREATE TABLE RestoreObject (
    RestoreObjectId INTEGER,
-   Fname TEXT DEFAULT '',
-   Path TEXT DEFAULT '',
+   ObjectName TEXT DEFAULT '',
    RestoreObject TEXT DEFAULT '',
    PluginName TEXT DEFAULT '',
+   ObjectLength INTEGER DEFAULT 0,
    ObjectIndex INTEGER DEFAULT 0,
    ObjectType INTEGER DEFAULT 0,
    FileIndex INTEGER UNSIGNED DEFAULT 0,
+   ObejctCompression INTEGER DEFAULT 0,
    JobId INTEGER UNSIGNED REFERENCES Job NOT NULL,
-   PRIMARY KEY(RestoreObjectId),
-   INDEX (JobId)
+   PRIMARY KEY(RestoreObjectId)
    );
 CREATE INDEX restore_jobid_idx ON RestoreObject (JobId);