@@ -, +, @@ --- installer/data/mysql/atomicupdate/bug_14697.perl | 5 +++++ installer/data/mysql/mandatory/auth_val_cat.sql | 4 ++++ 2 files changed, 9 insertions(+) --- a/installer/data/mysql/atomicupdate/bug_14697.perl +++ a/installer/data/mysql/atomicupdate/bug_14697.perl @@ -34,6 +34,11 @@ if( CheckVersion( $DBversion ) ) { ('ClaimReturnedWarningThreshold', '', '', 'Sets the number of return claims past which the librarian will be warned the patron has many return claims', 'Integer'); }); + $dbh->do(q{ + INSERT IGNORE INTO authorised_value_categories ( category_name ) VALUES + ('RETURN_CLAIM_RESOLUTION'); + }); + $dbh->do(q{ INSERT IGNORE INTO `authorised_values` ( category, authorised_value, lib ) VALUES --- a/installer/data/mysql/mandatory/auth_val_cat.sql +++ a/installer/data/mysql/mandatory/auth_val_cat.sql @@ -61,3 +61,7 @@ INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES -- For Interlibrary loans INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES ('ILLSTATUS'); + +-- For Claims returned +INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES + ('RETURN_CLAIM_RESOLUTION'); --