From f3439e2612b7dc00700b7a088518f7fb48419888 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Wed, 17 Mar 2021 17:48:04 +0000 Subject: [PATCH] Bug 22435: Add 'APPLY' to account_offset_types --- installer/data/mysql/atomicupdate/bug_22435.perl | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_22435.perl b/installer/data/mysql/atomicupdate/bug_22435.perl index 3839c23002..1b14a0903d 100644 --- a/installer/data/mysql/atomicupdate/bug_22435.perl +++ b/installer/data/mysql/atomicupdate/bug_22435.perl @@ -1,8 +1,7 @@ $DBversion = 'XXX'; # will be replaced by the RM if( CheckVersion( $DBversion ) ) { - $dbh->do( "INSERT IGNORE INTO account_offset_types () VALUES ( 'CREATE' )" ); + $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)" ); - # Always end with this (adjust the bug info) NewVersion( $DBversion, 22435, "Update offsets to CREATE type"); } -- 2.20.1