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

(-)a/installer/data/mysql/atomicupdate/Bug_21639_add_phone_transports.perl (+13 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q(
4
        INSERT IGNORE INTO message_transports
5
        (message_attribute_id,message_transport_type,is_digest,letter_module,letter_code)
6
        VALUES
7
        (2, 'phone', 0, 'circulation', 'PREDUE'),
8
        (2, 'phone', 1, 'circulation', 'PREDUEDGST'),
9
        (4, 'phone', 0, 'reserves',    'HOLD')
10
        ));
11
    SetVersion( $DBversion );
12
    print "Upgrade to $DBversion done (Bug 21639 - Add phone transports by default)\n";
13
}
(-)a/installer/data/mysql/en/mandatory/sample_notices_message_transports.sql (-4 / +6 lines)
Lines 3-16 insert into `message_transports` Link Here
3
values
3
values
4
(1, 'email', 0, 'circulation', 'DUE'),
4
(1, 'email', 0, 'circulation', 'DUE'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
6
(2, 'email', 0, 'circulation', 'PREDUE'),
7
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
8
(4, 'email', 0, 'reserves',    'HOLD'),
9
(1, 'sms',   0, 'circulation', 'DUE'),
6
(1, 'sms',   0, 'circulation', 'DUE'),
10
(1, 'sms',   1, 'circulation', 'DUEDGST'),
7
(1, 'sms',   1, 'circulation', 'DUEDGST'),
8
(2, 'email', 0, 'circulation', 'PREDUE'),
9
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
11
(2, 'sms',   0, 'circulation', 'PREDUE'),
10
(2, 'sms',   0, 'circulation', 'PREDUE'),
12
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
11
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
12
(2, 'phone', 0, 'circulation', 'PREDUE'),
13
(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
14
(4, 'email', 0, 'reserves',    'HOLD'),
13
(4, 'sms',   0, 'reserves',    'HOLD'),
15
(4, 'sms',   0, 'reserves',    'HOLD'),
16
(4, 'phone', 0, 'reserves',    'HOLD'),
14
(5, 'email', 0, 'circulation', 'CHECKIN'),
17
(5, 'email', 0, 'circulation', 'CHECKIN'),
15
(5, 'sms',   0, 'circulation', 'CHECKIN'),
18
(5, 'sms',   0, 'circulation', 'CHECKIN'),
16
(6, 'email', 0, 'circulation', 'CHECKOUT'),
19
(6, 'email', 0, 'circulation', 'CHECKOUT'),
17
- 

Return to bug 21639