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

(-)a/installer/data/mysql/account_credit_types.sql (+2 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
('DISCOUNT', 'A discount applied to a patrons fine', 0, 1),
7
('REFUND', 'A refund applied to a patrons fine', 0, 1),
6
('LOST_RETURN', 'Lost item fee refund', 0, 1);
8
('LOST_RETURN', 'Lost item fee refund', 0, 1);
(-)a/installer/data/mysql/account_offset_types.sql (-1 / +3 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
('DISOUNT'),
22
('REFUND');
(-)a/installer/data/mysql/atomicupdate/bug_23442.perl (-1 / +20 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
              ('DISCOUNT', 'A discount applied to a patrons fine', 0, 1),
9
              ('REFUND', 'A refund applied to a patrons fine', 0, 1)
10
        }
11
    );
12
13
    $dbh->do(qq{
14
        INSERT IGNORE INTO account_offset_types ( type ) VALUES ('DISCOUNT'), ('REFUND');
15
    });
16
17
    SetVersion($DBversion);
18
    print "Upgrade to $DBversion done (Bug 23442 - Add REFUND and DISCOUNT account_credit_types)\n";
19
    print "Upgrade to $DBversion done (Bug 23442 - Add REFUNDED and DISCOUNTED account_offset_types)\n";
20
}

Return to bug 23442