X-Git-Url: https://git.sur5r.net/?a=blobdiff_plain;f=bacula%2Fsrc%2Fcats%2Fmake_sqlite3_tables.in;h=4585d05acb133b9628ace478fce584466cffc555;hb=cd7acc68ac7b79a612e3c3ce64fa191e303e2c72;hp=1cf00f1d7edc588d88a11ac23a48bb4e74b4565c;hpb=e1e7c2aaef15193daad550d12c2ca4c65e76778c;p=bacula%2Fbacula

diff --git a/bacula/src/cats/make_sqlite3_tables.in b/bacula/src/cats/make_sqlite3_tables.in
index 1cf00f1d7e..4585d05acb 100644
--- a/bacula/src/cats/make_sqlite3_tables.in
+++ b/bacula/src/cats/make_sqlite3_tables.in
@@ -51,17 +51,17 @@ 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,
+   ObjectFullLength 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);
 
@@ -434,7 +434,7 @@ INSERT INTO Status (JobStatus,JobStatusLong,Severity) VALUES
 
 
 -- Initialize Version		 
-INSERT INTO Version (VersionId) VALUES (12);
+INSERT INTO Version (VersionId) VALUES (@BDB_VERSION@);
 
 
 PRAGMA default_cache_size = 100000;