From c85f46beb39f951aa3870967afd9aa21a15dcfff 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. Signed-off-by: David Nind Signed-off-by: Kyle M Hall Signed-off-by: Martin Renvoize --- .../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 87c8dc2643..4a56684c8a 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.5