From fc27868f1d51a46583d4c3fc2003b508a784b389 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
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