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

(-)a/installer/data/mysql/atomicupdate/bug_22435.perl (+8 lines)
Line 0 Link Here
1
$DBversion = 'XXX'; # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do( "INSERT IGNORE INTO account_offset_types () VALUES ( 'CREATE' )" );
4
    $dbh->do( "UPDATE account_offsets SET type = 'CREATE' WHERE type != 'OVERDUE_INCREASE' AND type != 'OVERDUE_DECREASE' AND ( debit_id IS NULL OR credit_id IS NULL)" );
5
6
    # Always end with this (adjust the bug info)
7
    NewVersion( $DBversion, 22435, "Update offsets to CREATE type");
8
}
(-)a/installer/data/mysql/mandatory/account_offset_types.sql (-1 / +1 lines)
Lines 1-4 Link Here
1
INSERT INTO account_offset_types ( type ) VALUES
1
INSERT INTO account_offset_types ( type ) VALUES
2
('CREATE'),
2
('Writeoff'),
3
('Writeoff'),
3
('Payment'),
4
('Payment'),
4
('Purchase'),
5
('Purchase'),
5
- 

Return to bug 22435