@@ -, +, @@ --- ...dd_HOLD_CANCELLATION-RECALLED_authorised_value.pl | 12 ++++++++++++ installer/data/mysql/en/optional/auth_val.yml | 4 ++++ 2 files changed, 16 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_31391_-_add_HOLD_CANCELLATION-RECALLED_authorised_value.pl --- a/installer/data/mysql/atomicupdate/bug_31391_-_add_HOLD_CANCELLATION-RECALLED_authorised_value.pl +++ a/installer/data/mysql/atomicupdate/bug_31391_-_add_HOLD_CANCELLATION-RECALLED_authorised_value.pl @@ -0,0 +1,12 @@ +use Modern::Perl; + +return { + bug_number => "31391", + description => "Add new RECALLED value to HOLD_CANCELLATION authorised value category", + up => sub { + my ($args) = @_; + my ($dbh, $out) = @$args{qw(dbh out)}; + + $dbh->do(q{ INSERT IGNORE INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','RECALLED','Hold was converted to a recall') }); + }, +}; --- a/installer/data/mysql/en/optional/auth_val.yml +++ a/installer/data/mysql/en/optional/auth_val.yml @@ -321,6 +321,10 @@ tables: authorised_value: "DAMAGED" lib: "Item was found to be too damaged to fill hold" + - category: "HOLD_CANCELLATION" + authorised_value: "RECALLED" + lib: "Hold was converted to a recall" + # article request cancellations - category: "AR_CANCELLATION" authorised_value: "NOT_FOUND" --