From cb497aa791144d211a1305f98e0c48d1ae56b7c6 Mon Sep 17 00:00:00 2001 From: Lari Taskula Date: Wed, 1 Apr 2020 17:29:33 +0000 Subject: [PATCH] Bug 25037: Add authorised values to sample data Sponsored-by: The National Library of Finland --- installer/data/mysql/de-DE/mandatory/auth_values.sql | 2 ++ installer/data/mysql/en/mandatory/auth_values.yml | 10 ++++++++++ installer/data/mysql/es-ES/mandatory/auth_values.sql | 2 ++ installer/data/mysql/fr-CA/obligatoire/auth_values.sql | 2 ++ .../mysql/fr-FR/1-Obligatoire/authorised_values.sql | 4 ++++ installer/data/mysql/it-IT/necessari/auth_val.sql | 4 ++++ .../data/mysql/nb-NO/1-Obligatorisk/auth_values.sql | 2 ++ installer/data/mysql/pl-PL/mandatory/auth_values.sql | 2 ++ installer/data/mysql/ru-RU/mandatory/auth_values.sql | 2 ++ installer/data/mysql/uk-UA/mandatory/auth_values.sql | 6 ++++++ 10 files changed, 36 insertions(+) diff --git a/installer/data/mysql/de-DE/mandatory/auth_values.sql b/installer/data/mysql/de-DE/mandatory/auth_values.sql index e1a27977f0..930e587e9b 100644 --- a/installer/data/mysql/de-DE/mandatory/auth_values.sql +++ b/installer/data/mysql/de-DE/mandatory/auth_values.sql @@ -1,3 +1,5 @@ INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','Nein','Nein'); INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Ja','Ja'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Jede Woche'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout'); diff --git a/installer/data/mysql/en/mandatory/auth_values.yml b/installer/data/mysql/en/mandatory/auth_values.yml index 19f73d4f39..17f6622426 100644 --- a/installer/data/mysql/en/mandatory/auth_values.yml +++ b/installer/data/mysql/en/mandatory/auth_values.yml @@ -50,6 +50,16 @@ tables: lib: "Creditcard via SIP2" lib_opac: "Creditcard" + - category: "CHECKOUT_TYPE" + authorised_value: "C" + lib: "Normal checkout" + lib_opac: "Normal checkout" + + - category: "CHECKOUT_TYPE" + authorised_value: "OS" + lib: "On-site checkout" + lib_opac: "On-site checkout" + - authorised_values: translatable: [ lib ] multiline: [] diff --git a/installer/data/mysql/es-ES/mandatory/auth_values.sql b/installer/data/mysql/es-ES/mandatory/auth_values.sql index 26328ef6c1..46b26595dd 100644 --- a/installer/data/mysql/es-ES/mandatory/auth_values.sql +++ b/installer/data/mysql/es-ES/mandatory/auth_values.sql @@ -1,3 +1,5 @@ INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No'); INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Yes','Yes'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout'); diff --git a/installer/data/mysql/fr-CA/obligatoire/auth_values.sql b/installer/data/mysql/fr-CA/obligatoire/auth_values.sql index c92494921f..cc861d8503 100644 --- a/installer/data/mysql/fr-CA/obligatoire/auth_values.sql +++ b/installer/data/mysql/fr-CA/obligatoire/auth_values.sql @@ -1,3 +1,5 @@ INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','Non','Non'); INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Oui','Oui'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Chaque Semaine'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout'); 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 46539144e6..17f757e874 100644 --- a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql +++ b/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql @@ -724,3 +724,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'); + +-- Checkout types +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout'); diff --git a/installer/data/mysql/it-IT/necessari/auth_val.sql b/installer/data/mysql/it-IT/necessari/auth_val.sql index 9fff795732..4fa1bdc799 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'); + +-- Checkout types +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout'); diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/auth_values.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/auth_values.sql index dbcc74f674..2ac677d890 100644 --- a/installer/data/mysql/nb-NO/1-Obligatorisk/auth_values.sql +++ b/installer/data/mysql/nb-NO/1-Obligatorisk/auth_values.sql @@ -1 +1,3 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout'); diff --git a/installer/data/mysql/pl-PL/mandatory/auth_values.sql b/installer/data/mysql/pl-PL/mandatory/auth_values.sql index dbcc74f674..2ac677d890 100644 --- a/installer/data/mysql/pl-PL/mandatory/auth_values.sql +++ b/installer/data/mysql/pl-PL/mandatory/auth_values.sql @@ -1 +1,3 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout'); diff --git a/installer/data/mysql/ru-RU/mandatory/auth_values.sql b/installer/data/mysql/ru-RU/mandatory/auth_values.sql index dbcc74f674..2ac677d890 100644 --- a/installer/data/mysql/ru-RU/mandatory/auth_values.sql +++ b/installer/data/mysql/ru-RU/mandatory/auth_values.sql @@ -1 +1,3 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout'); diff --git a/installer/data/mysql/uk-UA/mandatory/auth_values.sql b/installer/data/mysql/uk-UA/mandatory/auth_values.sql index c7b73d6bf0..dfed602ea8 100644 --- a/installer/data/mysql/uk-UA/mandatory/auth_values.sql +++ b/installer/data/mysql/uk-UA/mandatory/auth_values.sql @@ -10,3 +10,9 @@ INSERT INTO `authorised_values` (category, authorised_value, lib, lib_opac) VALU -- Housebound INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Кожного тижня'); + +-- Checkout types +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) + VALUES ('CHECKOUT_TYPE', 'C', 'Normal checkout', 'Normal checkout'); +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) + VALUES ('CHECKOUT_TYPE', 'OS', 'On-site checkout', 'On-site checkout'); -- 2.17.1