From 63c5700a7e261e004018debc431bd9c59a3c5de8 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Wed, 21 Feb 2018 07:04:22 -0500 Subject: [PATCH] Bug 18790: Add new account offsets to atomic update --- installer/data/mysql/atomicupdate/bug_18786.perl | 3 +++ 1 file changed, 3 insertions(+) diff --git a/installer/data/mysql/atomicupdate/bug_18786.perl b/installer/data/mysql/atomicupdate/bug_18786.perl index 7617bc5..a9b704b 100644 --- a/installer/data/mysql/atomicupdate/bug_18786.perl +++ b/installer/data/mysql/atomicupdate/bug_18786.perl @@ -5,6 +5,9 @@ if( CheckVersion( $DBversion ) ) { $dbh->do( "ALTER TABLE accountlines ADD `payment_type` varchar(80) default NULL AFTER accounttype" ); } + $dbh->do( q{INSERT IGNORE INTO account_offset_types ( type ) VALUES ('Fine'), ('Void Payment')} ); + SetVersion( $DBversion ); print "Upgrade to $DBversion done (Bug 18786 - Add ability to create custom payment types)\n"; } + -- 2.10.2