From b99d016988183cceeee441e85d74c38993fc3adf Mon Sep 17 00:00:00 2001 From: Alain Spineux Date: Tue, 8 Nov 2022 10:34:27 +0100 Subject: [PATCH] Fix update_mysql_tables for MODIFY vs ADD for Protected & VolEncrypted --- bacula/src/cats/update_mysql_tables.in | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/bacula/src/cats/update_mysql_tables.in b/bacula/src/cats/update_mysql_tables.in index 32ac4d3af..0ab9f7d4c 100644 --- a/bacula/src/cats/update_mysql_tables.in +++ b/bacula/src/cats/update_mysql_tables.in @@ -706,9 +706,9 @@ CREATE INDEX meta_attachmentowner ON MetaAttachment (AttachmentTenant(255),Attac CREATE INDEX meta_attachmentemailid ON MetaAttachment (AttachmentEmailId(255)); ALTER TABLE Media - MODIFY COLUMN Protected TINYINT DEFAULT 0, - MODIFY COLUMN UseProtect TINYINT DEFAULT 0, - MODIFY COLUMN VolEncrypted TINYINT DEFAULT 0; + ADD COLUMN Protected tinyint default 0, + ADD COLUMN UseProtect tinyint default 0; + ADD COLUMN VolEncrypted tinyint default 0; ALTER TABLE Object ADD COLUMN FileIndex integer not null default 0, -- 2.47.3