Attachment 128949 Details for Bug 27208 – Bug 27208: Atomicupdate

[patch] Bug 27208: Atomicupdate

Bug-27208-Atomicupdate.patch (text/plain), 1.68 KB, created by Björn Nylén on 2022-01-02 16:08:52 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Björn Nylén

Created: 2022-01-02 16:08:52 UTC

Size: 1.68 KB

patch

obsolete

>From 62535dcd69ac6c6689281dffa1d72420578577bc 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 | 22 +++++++++++++++++++
> 1 file changed, 22 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 0000000000..477b8eacb7
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_27208-add_delay_util_to_message_queue.pl
>@@ -0,0 +1,22 @@
>+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', '0', NULL ,  'Delay for pickup notices in hours if PickupNoticeDelayMode is set to "Fixed delay"',  'Integer' )
>+                 });
>+
>+    },
>+}
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 27208: 128387 | 128388 | 128389 | 128390 | 128587 | 128588 | 128589 | 128590 | 128948 | 128949 | 128950 | 128951