@@ -, +, @@ --- installer/data/mysql/en/optional/auth_val.sql | 4 ++-- installer/data/mysql/updatedatabase.pl | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) --- a/installer/data/mysql/en/optional/auth_val.sql +++ a/installer/data/mysql/en/optional/auth_val.sql @@ -72,6 +72,6 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MEDIA_TYPE', '010', 'Book with audio tape'); -- order cancellation reasons -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason'); -INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Sold out'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -9763,8 +9763,8 @@ $DBversion = "3.19.00.XXX"; if(CheckVersion($DBversion)) { $dbh->do(q{ INSERT INTO authorised_values (category, authorised_value, lib) VALUES - ('ORDER_CANCELLATION_REASON', 0, 'No reason'), - ('ORDER_CANCELLATION_REASON', 1, 'Sold out'), + ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'), + ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'), ('ORDER_CANCELLATION_REASON', 2, 'Restocking') }); --