From 2765d6e6909de76ad33daf3717daccdc751d6cba Mon Sep 17 00:00:00 2001 From: Aleisha Amohia Date: Fri, 26 Apr 2024 02:19:27 +0000 Subject: [PATCH] Bug 23781 (follow-up): Reorder atomic updates so they apply when run the first time. --- .../mysql/atomicupdate/bug_23781-recalls_sms_notices.pl | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_23781-recalls_sms_notices.pl b/installer/data/mysql/atomicupdate/bug_23781-recalls_sms_notices.pl index 87c8dc2643d..4a56684c8ac 100755 --- a/installer/data/mysql/atomicupdate/bug_23781-recalls_sms_notices.pl +++ b/installer/data/mysql/atomicupdate/bug_23781-recalls_sms_notices.pl @@ -14,15 +14,15 @@ return { say $out "Added recalls SMS notices: RETURN_RECALLED_ITEM, PICKUP_RECALLED_ITEM"; $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), (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) } + q{ INSERT IGNORE INTO message_attributes (message_attribute_id, message_name, takes_days) VALUES (12, 'Recall_Waiting', 0), (13, 'Recall_Requested', 0) } ); - say $out "Added message transports for recalls notices"; + say $out "Added message attributes for recalls: Recall_Waiting, Recall_Requested"; $dbh->do( - q{ INSERT IGNORE INTO message_attributes (message_attribute_id, message_name, takes_days) VALUES (12, 'Recall_Waiting', 0), (13, 'Recall_Requested', 0) } + 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) } ); - say $out "Added message attributes for recalls: Recall_Waiting, Recall_Requested"; + say $out "Added message transports for recalls notices"; }, }; -- 2.39.2