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

(-)a/installer/data/mysql/account_credit_types.sql (+2 lines)
Lines 6-8 INSERT INTO account_credit_types ( code, description, can_be_added_manually, is_ Link Here
6
('DISCOUNT', 'A discount applied to a patrons fine', 0, 1),
6
('DISCOUNT', 'A discount applied to a patrons fine', 0, 1),
7
('REFUND', 'A refund applied to a patrons fine', 0, 1),
7
('REFUND', 'A refund applied to a patrons fine', 0, 1),
8
('LOST_RETURN', 'Lost item fee refund', 0, 1);
8
('LOST_RETURN', 'Lost item fee refund', 0, 1);
9
10
INSERT INTO authorised_values (category,authorised_value,lib) VALUES ('PAYMENT_TYPE','CASH','Cash');
(-)a/installer/data/mysql/atomicupdate/bug_23354.perl (-1 / +11 lines)
Lines 5-10 if( CheckVersion( $DBversion ) ) { Link Here
5
        INSERT IGNORE INTO account_offset_types ( type ) VALUES ( 'Purchase' );
5
        INSERT IGNORE INTO account_offset_types ( type ) VALUES ( 'Purchase' );
6
    });
6
    });
7
7
8
    my $sth = $dbh->prepare(q{
9
        SELECT COUNT(*) FROM authorised_values WHERE category = 'PAYMENT_TYPE' AND authorised_value = 'CASH'
10
    });
11
    $sth->execute;
12
    my $already_exists = $sth->fetchrow;
13
    if ( not $already_exists ) {
14
        $dbh->do(q{
15
           INSERT INTO authorised_values (category,authorised_value,lib) VALUES ('PAYMENT_TYPE','CASH','Cash')
16
        });
17
    }
18
8
    # Updating field in account_debit_types
19
    # Updating field in account_debit_types
9
    unless ( column_exists('account_debit_types', 'can_be_invoiced') ) {
20
    unless ( column_exists('account_debit_types', 'can_be_invoiced') ) {
10
        $dbh->do(
21
        $dbh->do(
11
- 

Return to bug 23354