@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_22435.perl | 1 + 1 file changed, 1 insertion(+) --- a/installer/data/mysql/atomicupdate/bug_22435.perl +++ a/installer/data/mysql/atomicupdate/bug_22435.perl @@ -2,6 +2,7 @@ $DBversion = 'XXX'; # will be replaced by the RM if( CheckVersion( $DBversion ) ) { $dbh->do( "INSERT IGNORE INTO account_offset_types ( type ) VALUES ( 'CREATE' ), ( 'APPLY' )" ); $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)" ); + $dbh->do( "UPDATE account_offsets SET type = 'APPLY' WHERE type != 'OVERDUE_INCREASE' AND type != 'OVERDUE_DECREASE' AND type != 'CREATE'" ); NewVersion( $DBversion, 22435, "Update offsets to CREATE type"); } --