From b6c3c084cd76f463aa991f60376ece63d1423e57 Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Tue, 29 Oct 2019 15:57:06 -0300 Subject: [PATCH] Bug 14697: (QA follow-up) Add missing AV category Signed-off-by: Tomas Cohen Arazi Signed-off-by: Andrew Fuerste-Henry Signed-off-by: Lisette Scheer --- installer/data/mysql/atomicupdate/bug_14697.perl | 5 +++++ installer/data/mysql/mandatory/auth_val_cat.sql | 4 ++++ 2 files changed, 9 insertions(+) diff --git a/installer/data/mysql/atomicupdate/bug_14697.perl b/installer/data/mysql/atomicupdate/bug_14697.perl index e9d8f11946..5fadaf6078 100644 --- a/installer/data/mysql/atomicupdate/bug_14697.perl +++ b/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 diff --git a/installer/data/mysql/mandatory/auth_val_cat.sql b/installer/data/mysql/mandatory/auth_val_cat.sql index f39bf93502..cca989c9df 100644 --- a/installer/data/mysql/mandatory/auth_val_cat.sql +++ b/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'); -- 2.21.0 (Apple Git-122)