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

(-)a/installer/data/mysql/account_credit_types.sql (+1 lines)
Lines 3-6 INSERT INTO account_credit_types ( code, description, can_be_added_manually, is_ Link Here
3
('WRITEOFF', 'Writeoff', 0, 1),
3
('WRITEOFF', 'Writeoff', 0, 1),
4
('FORGIVEN', 'Forgiven', 1, 1),
4
('FORGIVEN', 'Forgiven', 1, 1),
5
('CREDIT', 'Credit', 1, 1),
5
('CREDIT', 'Credit', 1, 1),
6
('REFUND', 'A refund applied to a patrons fine', 0, 1),
6
('LOST_RETURN', 'Lost item fee refund', 0, 1);
7
('LOST_RETURN', 'Lost item fee refund', 0, 1);
(-)a/installer/data/mysql/account_offset_types.sql (-1 / +2 lines)
Lines 17-20 INSERT INTO account_offset_types ( type ) VALUES Link Here
17
('OVERDUE'),
17
('OVERDUE'),
18
('Void Payment'),
18
('Void Payment'),
19
('Credit Applied'),
19
('Credit Applied'),
20
('PAYOUT');
20
('PAYOUT'),
21
('REFUND');
(-)a/installer/data/mysql/atomicupdate/bug_23442.perl (-1 / +19 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_credit_types (code, description, can_be_added_manually, is_system)
7
            VALUES
8
              ('REFUND', 'A refund applied to a patrons fine', 0, 1)
9
        }
10
    );
11
12
    $dbh->do(qq{
13
        INSERT IGNORE INTO account_offset_types ( type ) VALUES ('REFUND');
14
    });
15
16
    SetVersion($DBversion);
17
    print "Upgrade to $DBversion done (Bug 23442 - Add REFUND to account_credit_types)\n";
18
    print "Upgrade to $DBversion done (Bug 23442 - Add REFUND to account_offset_types)\n";
19
}

Return to bug 23442