@@ -, +, @@ --- .../data/mysql/atomicupdate/bug_29586.pl | 23 +++++++++++++++++++ 1 file changed, 23 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_29586.pl --- a/installer/data/mysql/atomicupdate/bug_29586.pl +++ a/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') + }); + }, +} --