@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_24338.perl | 12 ++++++++++++ installer/data/mysql/en/mandatory/auth_values.sql | 1 + 2 files changed, 13 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_24338.perl --- a/installer/data/mysql/atomicupdate/bug_24338.perl +++ a/installer/data/mysql/atomicupdate/bug_24338.perl @@ -0,0 +1,12 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do(qq{ + INSERT INTO + authorised_values (category,authorised_value,lib, lib_opac) + VALUES + ('PAYMENT_TYPE','CASH','Cash','Cash') + }); + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 24338 - Add 'CASH' to default 'PAYMENT_TYPE')\n"; +} --- a/installer/data/mysql/en/mandatory/auth_values.sql +++ a/installer/data/mysql/en/mandatory/auth_values.sql @@ -1,3 +1,4 @@ INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No'); INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Yes','Yes'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('PAYMENT_TYPE','CASH','Cash','Cash'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week'); --