From fc27868f1d51a46583d4c3fc2003b508a784b389 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 13 Apr 2018 13:15:57 -0300 Subject: [PATCH] Bug 18786: Add PAYMENT_TYPE to the AV categories --- installer/data/mysql/atomicupdate/bug_18786.perl | 2 ++ 1 file changed, 2 insertions(+) diff --git a/installer/data/mysql/atomicupdate/bug_18786.perl b/installer/data/mysql/atomicupdate/bug_18786.perl index 7617bc5a4f..4d06f6ce80 100644 --- a/installer/data/mysql/atomicupdate/bug_18786.perl +++ b/installer/data/mysql/atomicupdate/bug_18786.perl @@ -5,6 +5,8 @@ if( CheckVersion( $DBversion ) ) { $dbh->do( "ALTER TABLE accountlines ADD `payment_type` varchar(80) default NULL AFTER accounttype" ); } + $dbh->do(q{INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES ('PAYMENT_TYPE')}); + SetVersion( $DBversion ); print "Upgrade to $DBversion done (Bug 18786 - Add ability to create custom payment types)\n"; } -- 2.11.0