@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_27779.perl | 8 ++++++++ installer/data/mysql/mandatory/account_credit_types.sql | 2 +- 2 files changed, 9 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_27779.perl --- a/installer/data/mysql/atomicupdate/bug_27779.perl +++ a/installer/data/mysql/atomicupdate/bug_27779.perl @@ -0,0 +1,8 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + + # REFUND + $dbh->do( "UPDATE account_credit_types SET description = 'Refund' WHERE code = 'REFUND'" ); + + NewVersion( $DBversion, 27779, "Simplify credit descriptions"); +} --- a/installer/data/mysql/mandatory/account_credit_types.sql +++ a/installer/data/mysql/mandatory/account_credit_types.sql @@ -5,7 +5,7 @@ INSERT INTO account_credit_types ( code, description, can_be_added_manually, is_ ('FORGIVEN', 'Forgiven', 1, 1), ('CREDIT', 'Credit', 1, 1), ('DISCOUNT', 'A discount applied to a patrons fine', 0, 1), -('REFUND', 'A refund applied to a patrons fine', 0, 1), +('REFUND', 'Refund', 0, 1), ('LOST_FOUND', 'Lost item fee refund', 0, 1), ('PURCHASE', 'Purchase', 0, 1), ('CANCELLATION', 'Cancellation', 0, 1); --