From c643bfa3e44f33adcce3fcb53fbad733a78be804 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 267d5e1622..a3955f5e4c 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 50a9593b0d..ad2e01965e 100644 --- a/installer/data/mysql/mandatory/sample_notices_message_transports.sql +++ b/installer/data/mysql/mandatory/sample_notices_message_transports.sql @@ -52,4 +52,5 @@ values (13, "sms", 0, "circulation", "RETURN_RECALLED_ITEM"), (13, "phone", 0, "circulation", "RETURN_RECALLED_ITEM"), (14, "email", 0, "circulation", "RECALL_MANUAL_CANCEL"), -(14, "sms", 0, "circulation", "RECALL_MANUAL_CANCEL"); +(14, "sms", 0, "circulation", "RECALL_MANUAL_CANCEL"), +(14, "phone", 0, "circulation", "RECALL_MANUAL_CANCEL"); -- 2.30.2