Bugzilla – Attachment 194482 Details for
Bug 27208
Add a configurable time delay feature to hold notice templates
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 27208: Atomicupdate
Bug-27208-Atomicupdate.patch (text/plain), 1.78 KB, created by
Kevin Carnes
on 2026-03-05 08:11:39 UTC
(
hide
)
Description:
Bug 27208: Atomicupdate
Filename:
MIME Type:
Creator:
Kevin Carnes
Created:
2026-03-05 08:11:39 UTC
Size:
1.78 KB
patch
obsolete
>From 6e93794417c0e5d5940c91719daa6c681d86f8cf Mon Sep 17 00:00:00 2001 >From: =?UTF-8?q?Bj=C3=B6rn=20Nyl=C3=A9n?= <bjorn.nylen@ub.lu.se> >Date: Tue, 14 Dec 2021 08:34:48 +0000 >Subject: [PATCH] Bug 27208: Atomicupdate > >--- > ...g_27208-add_delay_util_to_message_queue.pl | 27 +++++++++++++++++++ > 1 file changed, 27 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/bug_27208-add_delay_util_to_message_queue.pl > >diff --git a/installer/data/mysql/atomicupdate/bug_27208-add_delay_util_to_message_queue.pl b/installer/data/mysql/atomicupdate/bug_27208-add_delay_util_to_message_queue.pl >new file mode 100755 >index 00000000000..0445d3d6411 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_27208-add_delay_util_to_message_queue.pl >@@ -0,0 +1,27 @@ >+use Modern::Perl; >+ >+return { >+ bug_number => "27208", >+ description => >+ "Adding new column 'message_queue.delay_until' and sysprefs PickupNoticeDelayMode, PickupNoticeDelayDuration", >+ up => sub { >+ my ($args) = @_; >+ my ( $dbh, $out ) = @$args{qw(dbh out)}; >+ >+ if ( !column_exists( 'message_queue', 'delay_until' ) ) { >+ $dbh->do( >+ q{ >+ ALTER TABLE message_queue ADD COLUMN `delay_until` TIMESTAMP NULL DEFAULT NULL AFTER `failure_code` >+ } >+ ); >+ } >+ >+ $dbh->do( >+ q{ >+ INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES >+ ('PickupNoticeDelayMode', 'off', 'off,fixed,staff', 'Delay mode for pickup notices', 'Choice'), >+ ('PickupNoticeDelayDuration', '', NULL, 'Delay for pickup notices in hours if PickupNoticeDelayMode is set to "Fixed delay"', 'Integer' ) >+ } >+ ); >+ }, >+}; >-- >2.43.0
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 27208
:
128387
|
128388
|
128389
|
128390
|
128587
|
128588
|
128589
|
128590
|
128948
|
128949
|
128950
|
128951
|
194480
|
194481
| 194482 |
194483
|
194484