From a1c98e616e1c1e069f4aeb495d03b51eaa0bb128 Mon Sep 17 00:00:00 2001 From: Aleisha Amohia Date: Thu, 9 Nov 2023 02:59:42 +0000 Subject: [PATCH] Bug 23781: Add phone transport option Signed-off-by: David Nind --- .../atomicupdate/bug_23781-recalls_message_transports.pl | 2 +- .../mysql/mandatory/sample_notices_message_transports.sql | 4 +++- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_23781-recalls_message_transports.pl b/installer/data/mysql/atomicupdate/bug_23781-recalls_message_transports.pl index 8f5b920c88..4dc592f7b8 100755 --- a/installer/data/mysql/atomicupdate/bug_23781-recalls_message_transports.pl +++ b/installer/data/mysql/atomicupdate/bug_23781-recalls_message_transports.pl @@ -8,7 +8,7 @@ return { my ( $dbh, $out ) = @$args{qw(dbh out)}; $dbh->do( - q{ INSERT IGNORE INTO message_transports (message_attribute_id, message_transport_type, is_digest, letter_module, letter_code, branchcode) VALUES (12, "email", 0, "circulation", "PICKUP_RECALLED_ITEM", null), (12, "sms", 0, "circulation", "PICKUP_RECALLED_ITEM", null), (13, "email", 0, "circulation", "RETURN_RECALLED_ITEM", null), (13, "sms", 0, "circulation", "RETURN_RECALLED_ITEM", null) } + q{ INSERT IGNORE INTO message_transports (message_attribute_id, message_transport_type, is_digest, letter_module, letter_code, branchcode) VALUES (12, "email", 0, "circulation", "PICKUP_RECALLED_ITEM", null), (12, "sms", 0, "circulation", "PICKUP_RECALLED_ITEM", null), (12, "phone", 0, "circulation", "PICKUP_RECALLED_ITEM", null), (13, "email", 0, "circulation", "RETURN_RECALLED_ITEM", null), (13, "sms", 0, "circulation", "RETURN_RECALLED_ITEM", null), (13, "phone", 0, "circulation", "RETURN_RECALLED_ITEM", null) } ); }, }; diff --git a/installer/data/mysql/mandatory/sample_notices_message_transports.sql b/installer/data/mysql/mandatory/sample_notices_message_transports.sql index 631e5de2cc..977e59f5ea 100644 --- a/installer/data/mysql/mandatory/sample_notices_message_transports.sql +++ b/installer/data/mysql/mandatory/sample_notices_message_transports.sql @@ -47,5 +47,7 @@ values (11, 'phone', 0, 'ill', 'ILL_REQUEST_UPDATE'), (12, "email", 0, "circulation", "PICKUP_RECALLED_ITEM"), (12, "sms", 0, "circulation", "PICKUP_RECALLED_ITEM"), +(12, "phone", 0, "circulation", "PICKUP_RECALLED_ITEM"), (13, "email", 0, "circulation", "RETURN_RECALLED_ITEM"), -(13, "sms", 0, "circulation", "RETURN_RECALLED_ITEM"); +(13, "sms", 0, "circulation", "RETURN_RECALLED_ITEM"), +(13, "phone", 0, "circulation", "RETURN_RECALLED_ITEM"); -- 2.30.2