From 04439b93335f5eb04c63a60ebe4f96292cf3cce7 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Wed, 24 May 2023 17:07:52 +0200 Subject: [PATCH] Fix MySQL catalog upgrade script with StatusInfo field --- bacula/src/cats/update_mysql_tables.in | 2 ++ bacula/updatedb/update_mysql_tables_1025_to_1026.in | 2 ++ 2 files changed, 4 insertions(+) diff --git a/bacula/src/cats/update_mysql_tables.in b/bacula/src/cats/update_mysql_tables.in index bf2289294..870d5a749 100644 --- a/bacula/src/cats/update_mysql_tables.in +++ b/bacula/src/cats/update_mysql_tables.in @@ -740,6 +740,7 @@ ALTER TABLE Job ADD COLUMN LastReadDevice blob, ADD COLUMN WriteStorageId integer default 0, ADD COLUMN WriteDevice blob, + ADD COLUMN StatusInfo blob, ADD COLUMN Encrypted int default 0; ALTER TABLE JobHisto @@ -751,6 +752,7 @@ ALTER TABLE JobHisto ADD COLUMN LastReadDevice blob, ADD COLUMN WriteStorageId integer default 0, ADD COLUMN WriteDevice blob, + ADD COLUMN StatusInfo blob, ADD COLUMN Encrypted int default 0; INSERT INTO Events (EventsCode, EventsType, EventsTime, EventsDaemon, EventsSource, EventsRef, EventsText) VALUES diff --git a/bacula/updatedb/update_mysql_tables_1025_to_1026.in b/bacula/updatedb/update_mysql_tables_1025_to_1026.in index 3d285342c..66df26868 100644 --- a/bacula/updatedb/update_mysql_tables_1025_to_1026.in +++ b/bacula/updatedb/update_mysql_tables_1025_to_1026.in @@ -111,6 +111,7 @@ ALTER TABLE Job ADD COLUMN LastReadDevice blob, ADD COLUMN WriteStorageId integer default 0, ADD COLUMN WriteDevice blob, + ADD COLUMN StatusInfo blob, ADD COLUMN Encrypted int default 0; ALTER TABLE JobHisto @@ -122,6 +123,7 @@ ALTER TABLE JobHisto ADD COLUMN LastReadDevice blob, ADD COLUMN WriteStorageId integer default 0, ADD COLUMN WriteDevice blob, + ADD COLUMN StatusInfo blob, ADD COLUMN Encrypted int default 0; INSERT INTO Events (EventsCode, EventsType, EventsTime, EventsDaemon, EventsSource, EventsRef, EventsText) VALUES -- 2.47.3