Attachment #95793 for bug #24080

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

Lines 6-11 INSERT INTO account_debit_types ( code, description, can_be_added_manually, defa Link Here

(-)a/installer/data/mysql/account_debit_types.sql (+1 lines)
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),

Lines 16-19 INSERT INTO account_offset_types ( type ) VALUES Link Here

(-)a/installer/data/mysql/account_offset_types.sql (-1 / +2 lines)
16	('OVERDUE_DECREASE'),	16	('OVERDUE_DECREASE'),
17	('OVERDUE'),	17	('OVERDUE'),
18	('Void Payment'),	18	('Void Payment'),
19	('Credit Applied');	19	('Credit Applied'),
		20	('PAYOUT');




$DBversion = 'XXX';    # will be replaced by the RM
if ( CheckVersion($DBversion) ) {

    $dbh->do(
        qq{
            INSERT IGNORE INTO account_debit_types (
              code,
              description,
              can_be_added_manually,
              default_amount,
              is_system
            )
            VALUES
              ('PAYOUT', 'Payment from library to patron', 0, NULL, 1)
        }
    );

    $dbh->do(qq{
        INSERT IGNORE INTO account_offset_types ( type ) VALUES ('PAYOUT');
    });

    SetVersion($DBversion);
    print "Upgrade to $DBversion done (Bug 24080 - Add PAYOUT account_debit_type)\n";
    print "Upgrade to $DBversion done (Bug 24080 - Add PAYOUT account_offset_type)\n";
}

Return to bug 24080

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_24080.perl (-1 / +25 lines)
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	}