View | Details | Raw Unified | Return to bug 27208
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_27208-add_delay_util_to_message_queue.pl (-1 / +27 lines)
Line 0 Link Here
0
- 
1
use Modern::Perl;
2
3
return {
4
    bug_number  => "27208",
5
    description =>
6
        "Adding new column 'message_queue.delay_until' and sysprefs PickupNoticeDelayMode, PickupNoticeDelayDuration",
7
    up => sub {
8
        my ($args) = @_;
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
10
11
        if ( !column_exists( 'message_queue', 'delay_until' ) ) {
12
            $dbh->do(
13
                q{
14
                    ALTER TABLE message_queue ADD COLUMN `delay_until` TIMESTAMP NULL DEFAULT NULL AFTER `failure_code`
15
                }
16
            );
17
        }
18
19
        $dbh->do(
20
            q{
21
                INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
22
                    ('PickupNoticeDelayMode', 'off', 'off,fixed,staff', 'Delay mode for pickup notices', 'Choice'),
23
                    ('PickupNoticeDelayDuration', '', NULL, 'Delay for pickup notices in hours if PickupNoticeDelayMode is set to "Fixed delay"', 'Integer' )
24
            }
25
        );
26
    },
27
};

Return to bug 27208