From a26edd62d2e6299319102b23bd50f43cff90106d Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Fri, 21 Aug 2020 06:58:04 -0400 Subject: [PATCH] Bug 25534: (QA follow-up) Add default values for new AV category Signed-off-by: Katrin Fischer --- installer/data/mysql/de-DE/optional/auth_val.sql | 8 ++++++++ installer/data/mysql/en/optional/auth_val.yml | 9 +++++++++ installer/data/mysql/fr-CA/facultatif/auth_val.sql | 4 ++++ installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql | 4 ++++ installer/data/mysql/it-IT/necessari/auth_val.sql | 4 ++++ installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql | 4 ++++ installer/data/mysql/pl-PL/optional/auth_val.sql | 4 ++++ .../authorised_values/authorised_values_[HOLD_CANCELLATION].sql | 2 ++ .../authorised_values/authorised_values_[HOLD_CANCELLATION].txt | 1 + .../authorised_values/authorised_values_[HOLD_CANCELLATION].sql | 2 ++ .../authorised_values/authorised_values_[HOLD_CANCELLATION].txt | 1 + 11 files changed, 43 insertions(+) create mode 100644 installer/data/mysql/ru-RU/authorised_values/authorised_values_[HOLD_CANCELLATION].sql create mode 100644 installer/data/mysql/ru-RU/authorised_values/authorised_values_[HOLD_CANCELLATION].txt create mode 100644 installer/data/mysql/uk-UA/authorised_values/authorised_values_[HOLD_CANCELLATION].sql create mode 100644 installer/data/mysql/uk-UA/authorised_values/authorised_values_[HOLD_CANCELLATION].txt diff --git a/installer/data/mysql/de-DE/optional/auth_val.sql b/installer/data/mysql/de-DE/optional/auth_val.sql index 26cef2d7c4..2416ef9859 100644 --- a/installer/data/mysql/de-DE/optional/auth_val.sql +++ b/installer/data/mysql/de-DE/optional/auth_val.sql @@ -84,3 +84,11 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_C -- return claims INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Von Benutzer/in zurückgegeben'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'In Bibliothek gefunden'); + +-- hold cancellation +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','NOT_FOUND','Item could not be located on shelves'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','DAMAGED','Item was found to be too damaged to fill hold'); + +-- hold cancellation +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','NOT_FOUND','Item could not be located on shelves'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','DAMAGED','Item was found to be too damaged to fill hold'); diff --git a/installer/data/mysql/en/optional/auth_val.yml b/installer/data/mysql/en/optional/auth_val.yml index bd03b11970..de8baf3903 100644 --- a/installer/data/mysql/en/optional/auth_val.yml +++ b/installer/data/mysql/en/optional/auth_val.yml @@ -291,3 +291,12 @@ tables: - category: "RETURN_CLAIM_RESOLUTION" authorised_value: "FOUND_IN_LIB" lib: "Found in library" + + # hold cancellations + - category: "HOLD_CANCELLATION" + authorised_value: "NOT_FOUND" + lib: "Item could not be located on shelves" + + - category: "HOLD_CANCELLATION" + authorised_value: "DAMAGED" + lib: "Item was found to be too damaged to fill hold" diff --git a/installer/data/mysql/fr-CA/facultatif/auth_val.sql b/installer/data/mysql/fr-CA/facultatif/auth_val.sql index 76ca84cf72..fa668ca90f 100644 --- a/installer/data/mysql/fr-CA/facultatif/auth_val.sql +++ b/installer/data/mysql/fr-CA/facultatif/auth_val.sql @@ -86,3 +86,7 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED -- return claims INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library'); + +-- hold cancellation +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','NOT_FOUND','Item could not be located on shelves'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','DAMAGED','Item was found to be too damaged to fill hold'); diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql b/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql index 67ed530385..fc4c180cdc 100644 --- a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql +++ b/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql @@ -723,3 +723,7 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_F -- return claims INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library'); + ++-- hold cancellation ++INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','NOT_FOUND','Item could not be located on shelves'); ++INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','DAMAGED','Item was found to be too damaged to fill hold'); diff --git a/installer/data/mysql/it-IT/necessari/auth_val.sql b/installer/data/mysql/it-IT/necessari/auth_val.sql index 9fff795732..8cc702ef14 100644 --- a/installer/data/mysql/it-IT/necessari/auth_val.sql +++ b/installer/data/mysql/it-IT/necessari/auth_val.sql @@ -119,3 +119,7 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_F -- return claims INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library'); + +-- hold cancellation +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','NOT_FOUND','Item could not be located on shelves'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','DAMAGED','Item was found to be too damaged to fill hold'); diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql b/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql index b69b79294d..0901965d5e 100644 --- a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql +++ b/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql @@ -105,3 +105,7 @@ INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES -- return claims INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library'); + +-- hold cancellation +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','NOT_FOUND','Item could not be located on shelves'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','DAMAGED','Item was found to be too damaged to fill hold'); diff --git a/installer/data/mysql/pl-PL/optional/auth_val.sql b/installer/data/mysql/pl-PL/optional/auth_val.sql index bb32e3207a..9678df47df 100644 --- a/installer/data/mysql/pl-PL/optional/auth_val.sql +++ b/installer/data/mysql/pl-PL/optional/auth_val.sql @@ -84,3 +84,7 @@ INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES -- return claims INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'RET_BY_PATRON', 'Returned by patron'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RETURN_CLAIM_RESOLUTION', 'FOUND_IN_LIB', 'Found in library'); + +-- hold cancellation +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','NOT_FOUND','Item could not be located on shelves'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','DAMAGED','Item was found to be too damaged to fill hold'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[HOLD_CANCELLATION].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[HOLD_CANCELLATION].sql new file mode 100644 index 0000000000..8ee4a73c4a --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[HOLD_CANCELLATION].sql @@ -0,0 +1,2 @@ +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','NOT_FOUND','Item could not be located on shelves'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','DAMAGED','Item was found to be too damaged to fill hold'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[HOLD_CANCELLATION].txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[HOLD_CANCELLATION].txt new file mode 100644 index 0000000000..cfaa359a37 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[HOLD_CANCELLATION].txt @@ -0,0 +1 @@ +HOLD_CANCELLATION diff --git a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[HOLD_CANCELLATION].sql b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[HOLD_CANCELLATION].sql new file mode 100644 index 0000000000..8ee4a73c4a --- /dev/null +++ b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[HOLD_CANCELLATION].sql @@ -0,0 +1,2 @@ +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','NOT_FOUND','Item could not be located on shelves'); +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HOLD_CANCELLATION','DAMAGED','Item was found to be too damaged to fill hold'); diff --git a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[HOLD_CANCELLATION].txt b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[HOLD_CANCELLATION].txt new file mode 100644 index 0000000000..cfaa359a37 --- /dev/null +++ b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[HOLD_CANCELLATION].txt @@ -0,0 +1 @@ +HOLD_CANCELLATION -- 2.11.0