From 7e1adb40918229c71850a7dccaef2b763358616e 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 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Signed-off-by: Séverine QUEUNE --- 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 fbc9d56..9219a95 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.7.4