From 8dd670c22991ed73b1c8d29bda22a4e0eec33e0a Mon Sep 17 00:00:00 2001 From: Jacob O'Mara Date: Wed, 2 Jul 2025 17:26:48 +0100 Subject: [PATCH] Bug 4858: Add print message transports to installer and atomic update --- .../sample_notices_message_transports.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) diff --git a/installer/data/mysql/mandatory/sample_notices_message_transports.sql b/installer/data/mysql/mandatory/sample_notices_message_transports.sql index c0395e09c92..ff91505a4ce 100644 --- a/installer/data/mysql/mandatory/sample_notices_message_transports.sql +++ b/installer/data/mysql/mandatory/sample_notices_message_transports.sql @@ -7,6 +7,8 @@ values (1, 'sms', 1, 'circulation', 'DUEDGST'), (1, 'phone', 0, 'circulation', 'DUE'), (1, 'phone', 1, 'circulation', 'DUEDGST'), +(1, 'print', 0, 'circulation', 'DUE'), +(1, 'print', 1, 'circulation', 'DUEDGST'), (2, 'email', 0, 'circulation', 'PREDUE'), (2, 'email', 1, 'circulation', 'PREDUEDGST'), (2, 'sms', 0, 'circulation', 'PREDUE'), @@ -15,6 +17,8 @@ values (2, 'phone', 1, 'circulation', 'PREDUEDGST'), (2, 'itiva', 0, 'circulation', 'PREDUE'), (2, 'itiva', 1, 'circulation', 'PREDUEDGST'), +(2, 'print', 0, 'circulation', 'PREDUE'), +(2, 'print', 1, 'circulation', 'PREDUEDGST'), (4, 'email', 0, 'reserves', 'HOLD'), (4, 'sms', 0, 'reserves', 'HOLD'), (4, 'phone', 0, 'reserves', 'HOLD'), @@ -22,37 +26,49 @@ values (4, 'email', 1, 'reserves', 'HOLDDGST'), (4, 'sms', 1, 'reserves', 'HOLDDGST'), (4, 'phone', 1, 'reserves', 'HOLDDGST'), +(4, 'print', 0, 'reserves', 'HOLD'), +(4, 'print', 1, 'reserves', 'HOLDDGST'), (5, 'email', 0, 'circulation', 'CHECKIN'), (5, 'sms', 0, 'circulation', 'CHECKIN'), (5, 'phone', 0, 'circulation', 'CHECKIN'), +(5, 'print', 0, 'circulation', 'CHECKIN'), (6, 'email', 0, 'circulation', 'CHECKOUT'), (6, 'sms', 0, 'circulation', 'CHECKOUT'), (6, 'phone', 0, 'circulation', 'CHECKOUT'), +(6, 'print', 0, 'circulation', 'CHECKOUT'), (7, 'email', 0, 'ill', 'ILL_PICKUP_READY'), (7, 'sms', 0, 'ill', 'ILL_PICKUP_READY'), (7, 'phone', 0, 'ill', 'ILL_PICKUP_READY'), +(7, 'print', 0, 'ill', 'ILL_PICKUP_READY'), (8, 'email', 0, 'ill', 'ILL_REQUEST_UNAVAIL'), (8, 'sms', 0, 'ill', 'ILL_REQUEST_UNAVAIL'), (8, 'phone', 0, 'ill', 'ILL_REQUEST_UNAVAIL'), +(8, 'print', 0, 'ill', 'ILL_REQUEST_UNAVAIL'), (9, 'email', 0, 'circulation', 'AUTO_RENEWALS'), (9, 'sms', 0, 'circulation', 'AUTO_RENEWALS'), (9, 'phone', 0, 'circulation', 'AUTO_RENEWALS'), (9, 'email', 1, 'circulation', 'AUTO_RENEWALS_DGST'), (9, 'sms', 1, 'circulation', 'AUTO_RENEWALS_DGST'), (9, 'phone', 1, 'circulation', 'AUTO_RENEWALS_DGST'), +(9, 'print', 0, 'circulation', 'AUTO_RENEWALS'), +(9, 'print', 1, 'circulation', 'AUTO_RENEWALS_DGST'), (10, 'email', 0, 'circulation', 'HOLD_REMINDER'), (10, 'sms', 0, 'circulation', 'HOLD_REMINDER'), (10, 'phone', 0, 'circulation', 'HOLD_REMINDER'), (10, 'itiva', 0, 'circulation', 'HOLD_REMINDER'), +(10, 'print', 0, 'circulation', 'HOLD_REMINDER'), (11, 'email', 0, 'ill', 'ILL_REQUEST_UPDATE'), (11, 'sms', 0, 'ill', 'ILL_REQUEST_UPDATE'), (11, 'phone', 0, 'ill', 'ILL_REQUEST_UPDATE'), +(11, 'print', 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"), +(12, 'print', 0, 'circulation', 'PICKUP_RECALLED_ITEM'), (13, "email", 0, "circulation", "RETURN_RECALLED_ITEM"), (13, "sms", 0, "circulation", "RETURN_RECALLED_ITEM"), (13, "phone", 0, "circulation", "RETURN_RECALLED_ITEM"), +(13, 'print', 0, 'circulation', 'RETURN_RECALLED_ITEM'); (14, "email", 0, "members", "MEMBERSHIP_EXPIRY"), (14, "sms", 0, "members", "MEMBERSHIP_EXPIRY"), (14, "phone", 0, "members", "MEMBERSHIP_EXPIRY"); -- 2.39.5