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

(-)a/installer/data/mysql/account_debit_types.sql (+1 lines)
Lines 6-11 INSERT INTO account_debit_types ( code, description, can_be_added_manually, defa Link Here
6
('NEW_CARD', 'New card fee', 1, NULL, 1),
6
('NEW_CARD', 'New card fee', 1, NULL, 1),
7
('OVERDUE', 'Overdue fine', 0, NULL, 1),
7
('OVERDUE', 'Overdue fine', 0, NULL, 1),
8
('PROCESSING', 'Lost item processing fee', 0, NULL, 1),
8
('PROCESSING', 'Lost item processing fee', 0, NULL, 1),
9
('PAYOUT', 'Payment from library to patron', 0, NULL, 1),
9
('RENT', 'Rental fee', 0, NULL, 1),
10
('RENT', 'Rental fee', 0, NULL, 1),
10
('RENT_DAILY', 'Daily rental fee', 0, NULL, 1),
11
('RENT_DAILY', 'Daily rental fee', 0, NULL, 1),
11
('RENT_RENEW', 'Renewal of rental item', 0, NULL, 1),
12
('RENT_RENEW', 'Renewal of rental item', 0, NULL, 1),
(-)a/installer/data/mysql/account_offset_types.sql (-1 / +2 lines)
Lines 16-19 INSERT INTO account_offset_types ( type ) VALUES Link Here
16
('OVERDUE_DECREASE'),
16
('OVERDUE_DECREASE'),
17
('OVERDUE'),
17
('OVERDUE'),
18
('Void Payment'),
18
('Void Payment'),
19
('Credit Applied');
19
('Credit Applied'),
20
('PAYOUT');
(-)a/installer/data/mysql/atomicupdate/bug_24080.perl (-1 / +25 lines)
Line 0 Link Here
0
- 
1
$DBversion = 'XXX';    # will be replaced by the RM
2
if ( CheckVersion($DBversion) ) {
3
4
    $dbh->do(
5
        qq{
6
            INSERT IGNORE INTO account_debit_types (
7
              code,
8
              description,
9
              can_be_added_manually,
10
              default_amount,
11
              is_system
12
            )
13
            VALUES
14
              ('PAYOUT', 'Payment from library to patron', 0, NULL, 1)
15
        }
16
    );
17
18
    $dbh->do(qq{
19
        INSERT IGNORE INTO account_offset_types ( type ) VALUES ('PAYOUT');
20
    });
21
22
    SetVersion($DBversion);
23
    print "Upgrade to $DBversion done (Bug 24080 - Add PAYOUT account_debit_type)\n";
24
    print "Upgrade to $DBversion done (Bug 24080 - Add PAYOUT account_offset_type)\n";
25
}

Return to bug 24080