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

Return to bug 27208