From a9758f5514d41aa91aed1bc66a71fed75bfb610c Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Fri, 16 Dec 2022 18:54:16 +0100 Subject: [PATCH] Fix schema for old MySQL --- bacula/src/cats/make_mysql_tables.in | 2 +- bacula/src/cats/update_mysql_tables.in | 2 +- bacula/updatedb/update_mysql_tables_1025_to_1026.in | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) diff --git a/bacula/src/cats/make_mysql_tables.in b/bacula/src/cats/make_mysql_tables.in index 31e19a065..b96c3f8d7 100644 --- a/bacula/src/cats/make_mysql_tables.in +++ b/bacula/src/cats/make_mysql_tables.in @@ -396,7 +396,7 @@ CREATE TABLE FileSet ( FileSet TINYBLOB NOT NULL, MD5 TINYBLOB, CreateTime DATETIME, - Content BLOB DEFAULT '', + Content BLOB, PRIMARY KEY(FileSetId) ); diff --git a/bacula/src/cats/update_mysql_tables.in b/bacula/src/cats/update_mysql_tables.in index 9c085b31f..9ebef5ef2 100644 --- a/bacula/src/cats/update_mysql_tables.in +++ b/bacula/src/cats/update_mysql_tables.in @@ -719,7 +719,7 @@ ALTER TABLE Object MODIFY COLUMN ObjectUUID BLOB; ALTER TABLE FileSet - ADD COLUMN Content BLOB DEFAULT ''; + ADD COLUMN Content BLOB; ALTER TABLE Job ADD COLUMN RealStartTime DATETIME, diff --git a/bacula/updatedb/update_mysql_tables_1025_to_1026.in b/bacula/updatedb/update_mysql_tables_1025_to_1026.in index 995741368..c0c339dbe 100644 --- a/bacula/updatedb/update_mysql_tables_1025_to_1026.in +++ b/bacula/updatedb/update_mysql_tables_1025_to_1026.in @@ -91,7 +91,7 @@ ALTER TABLE Object MODIFY COLUMN ObjectUUID BLOB; ALTER TABLE FileSet - ADD COLUMN Content BLOB DEFAULT ''; + ADD COLUMN Content BLOB; ALTER TABLE Job ADD COLUMN RealStartTime DATETIME, -- 2.47.3