From 077b1b216aa8936b52c22a8bb8148811fb796009 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Sat, 1 May 2010 11:12:43 +0200 Subject: [PATCH] Fix RestoreObject schema on PostgreSQL --- bacula/src/cats/make_postgresql_tables.in | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/bacula/src/cats/make_postgresql_tables.in b/bacula/src/cats/make_postgresql_tables.in index 4fb6745247..04e217f913 100644 --- a/bacula/src/cats/make_postgresql_tables.in +++ b/bacula/src/cats/make_postgresql_tables.in @@ -84,10 +84,10 @@ CREATE TABLE RestoreObject ( ObjectFullLength INTEGER DEFAULT 0, ObjectIndex INTEGER DEFAULT 0, ObjectType INTEGER DEFAULT 0, - FileIndex INTEGER UNSIGNED DEFAULT 0, - JobId INTEGER UNSIGNED, + FileIndex INTEGER DEFAULT 0, + JobId INTEGER, ObjectCompression INTEGER DEFAULT 0, - PRIMARY KEY(RestoreObjectId), + PRIMARY KEY(RestoreObjectId) ); CREATE INDEX restore_jobid_idx on RestoreObject(JobId); -- 2.39.5