From 7c6cd7767b71e11e53c4bcc1fb20112152c1c1d0 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Wed, 2 Oct 2019 15:27:40 +0100 Subject: [PATCH] Bug 23049: Update existing accounttype values --- installer/data/mysql/atomicupdate/bug_23049_debit.perl | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/installer/data/mysql/atomicupdate/bug_23049_debit.perl b/installer/data/mysql/atomicupdate/bug_23049_debit.perl index fbc9d56584..9219a95cb9 100644 --- a/installer/data/mysql/atomicupdate/bug_23049_debit.perl +++ b/installer/data/mysql/atomicupdate/bug_23049_debit.perl @@ -91,6 +91,12 @@ if ( CheckVersion($DBversion) ) { } ); + $dbh->do( + qq{ + UPDATE accountlines SET debit_type = accounttype, accounttype = NULL WHERE accounttype IN (SELECT code from account_debit_types) + } + ); + # Add new permission $dbh->do( q{ -- 2.20.1