From 352843bd61006761fb269608c398f395c763df21 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 1 Dec 2021 10:21:59 +0100 Subject: [PATCH] Bug 29586: Add atomic update for existing intallations In case an installation was created on 21.11.00 Signed-off-by: Jonathan Druart Signed-off-by: David Nind Signed-off-by: Tomas Cohen Arazi Signed-off-by: Fridolin Somers Signed-off-by: Kyle M Hall --- .../data/mysql/atomicupdate/bug_29586.pl | 23 +++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_29586.pl diff --git a/installer/data/mysql/atomicupdate/bug_29586.pl b/installer/data/mysql/atomicupdate/bug_29586.pl new file mode 100755 index 0000000000..7e0341b1f3 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_29586.pl @@ -0,0 +1,23 @@ +use Modern::Perl; + +return { + bug_number => "29586", + description => "Add Hold Reminder messaging preference if missing", + up => sub { + my ($args) = @_; + my ($dbh, $out) = @$args{qw(dbh out)}; + $dbh->do(q{ + INSERT IGNORE INTO `message_attributes` + (message_attribute_id, message_name, `takes_days`) + VALUES (10, 'Hold_Reminder', 0) + }); + $dbh->do(q{ + INSERT IGNORE INTO `message_transports` + (`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`) + VALUES (10, 'email', 0, 'circulation', 'HOLD_REMINDER'), + (10, 'sms', 0, 'circulation', 'HOLD_REMINDER'), + (10, 'phone', 0, 'circulation', 'HOLD_REMINDER'), + (10, 'itiva', 0, 'circulation', 'HOLD_REMINDER') + }); + }, +} -- 2.39.5