From e8f1049a206dbe159fa38facafa4da981ac71e5a Mon Sep 17 00:00:00 2001 From: Aleisha Amohia Date: Thu, 9 Nov 2023 03:08:51 +0000 Subject: [PATCH] Bug 30295: Add phone transport option Signed-off-by: David Nind --- .../bug_30295-add_RECALL_MANUAL_CANCEL_message_transports.pl | 2 +- .../data/mysql/mandatory/sample_notices_message_transports.sql | 3 ++- 2 files changed, 3 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_30295-add_RECALL_MANUAL_CANCEL_message_transports.pl b/installer/data/mysql/atomicupdate/bug_30295-add_RECALL_MANUAL_CANCEL_message_transports.pl index 267d5e16221..a3955f5e4c9 100755 --- a/installer/data/mysql/atomicupdate/bug_30295-add_RECALL_MANUAL_CANCEL_message_transports.pl +++ b/installer/data/mysql/atomicupdate/bug_30295-add_RECALL_MANUAL_CANCEL_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 (14, "email", 0, "circulation", "RECALL_MANUAL_CANCEL", null), (14, "sms", 0, "circulation", "RECALL_MANUAL_CANCEL", null) } + q{ INSERT IGNORE INTO message_transports (message_attribute_id, message_transport_type, is_digest, letter_module, letter_code, branchcode) VALUES (14, "email", 0, "circulation", "RECALL_MANUAL_CANCEL", null), (14, "sms", 0, "circulation", "RECALL_MANUAL_CANCEL", null), (14, "phone", 0, "circulation", "RECALL_MANUAL_CANCEL", null) } ); }, }; diff --git a/installer/data/mysql/mandatory/sample_notices_message_transports.sql b/installer/data/mysql/mandatory/sample_notices_message_transports.sql index ca194c7c3e4..b0117dc4931 100644 --- a/installer/data/mysql/mandatory/sample_notices_message_transports.sql +++ b/installer/data/mysql/mandatory/sample_notices_message_transports.sql @@ -57,4 +57,5 @@ values (14, "sms", 0, "members", "MEMBERSHIP_EXPIRY"), (14, "phone", 0, "members", "MEMBERSHIP_EXPIRY"), (15, "email", 0, "circulation", "RECALL_MANUAL_CANCEL"), -(15, "sms", 0, "circulation", "RECALL_MANUAL_CANCEL"); +(15, "sms", 0, "circulation", "RECALL_MANUAL_CANCEL"), +(15, "phone", 0, "circulation", "RECALL_MANUAL_CANCEL"); -- 2.39.5