From 4fcf9dc57feb5bc4c9dffce0ea730c33067321b9 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Fri, 12 Aug 2022 14:55:39 +0200 Subject: [PATCH] Add Job::Encrypted catalog field --- bacula/src/cats/make_mysql_tables.in | 1 + bacula/src/cats/make_postgresql_tables.in | 1 + bacula/src/cats/make_sqlite3_tables.in | 1 + 3 files changed, 3 insertions(+) diff --git a/bacula/src/cats/make_mysql_tables.in b/bacula/src/cats/make_mysql_tables.in index 1d537688e..ebf683c4f 100644 --- a/bacula/src/cats/make_mysql_tables.in +++ b/bacula/src/cats/make_mysql_tables.in @@ -330,6 +330,7 @@ CREATE TABLE Job ( WriteStorageId integer default 0, -- Id of the Storage used to Write WriteDevice blob, -- Name of the Write Device StatusInfo blob, -- Info to determine the error status + Encrypted int default 0, -- 0 no, 1 fd side, 2 sd side, 3 both PRIMARY KEY(JobId), INDEX (Name(128)) ); diff --git a/bacula/src/cats/make_postgresql_tables.in b/bacula/src/cats/make_postgresql_tables.in index 0e43271b4..a1da714e2 100644 --- a/bacula/src/cats/make_postgresql_tables.in +++ b/bacula/src/cats/make_postgresql_tables.in @@ -303,6 +303,7 @@ CREATE TABLE Job WriteStorageId integer default 0, -- Id of the Storage used to Write WriteDevice text default '', -- Name of the Write Device StatusInfo text default '', -- Info to determine the error status + Encrypted int default 0, -- 0 no, 1 fd side, 2 sd side, 3 both primary key (jobid) ); diff --git a/bacula/src/cats/make_sqlite3_tables.in b/bacula/src/cats/make_sqlite3_tables.in index e36f7e513..29c774a2f 100644 --- a/bacula/src/cats/make_sqlite3_tables.in +++ b/bacula/src/cats/make_sqlite3_tables.in @@ -259,6 +259,7 @@ CREATE TABLE Job ( WriteStorageId integer default 0, -- Id of the Storage used to Write WriteDevice text default '', -- Name of the Write Device StatusInfo text default '', -- Info to determine the error status + Encrypted int default 0, -- 0 no, 1 fd side, 2 sd side, 3 both PRIMARY KEY(JobId) ); CREATE INDEX inx6 ON Job (Name); -- 2.47.3