From ca243d7ef0085559500dbc251b83bb4dc170544d 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 --- installer/data/mysql/de-DE/mandatory/auth_values.sql | 1 + installer/data/mysql/en/mandatory/auth_values.yml | 5 +++++ installer/data/mysql/es-ES/mandatory/auth_values.sql | 1 + installer/data/mysql/fr-CA/obligatoire/auth_values.sql | 1 + .../data/mysql/fr-FR/1-Obligatoire/authorised_values.sql | 3 +++ installer/data/mysql/it-IT/necessari/auth_val.sql | 3 +++ installer/data/mysql/nb-NO/1-Obligatorisk/auth_values.sql | 1 + installer/data/mysql/pl-PL/mandatory/auth_values.sql | 1 + installer/data/mysql/ru-RU/mandatory/auth_values.sql | 1 + installer/data/mysql/uk-UA/mandatory/auth_values.sql | 4 ++++ 10 files changed, 21 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..8625a0c059 100644 --- a/installer/data/mysql/de-DE/mandatory/auth_values.sql +++ b/installer/data/mysql/de-DE/mandatory/auth_values.sql @@ -1,3 +1,4 @@ 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', 'ONSITE', '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..530eb666e5 100644 --- a/installer/data/mysql/en/mandatory/auth_values.yml +++ b/installer/data/mysql/en/mandatory/auth_values.yml @@ -50,6 +50,11 @@ tables: lib: "Creditcard via SIP2" lib_opac: "Creditcard" + - category: "CHECKOUT_TYPE" + authorised_value: "ONSITE" + 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..b25bb55d1e 100644 --- a/installer/data/mysql/es-ES/mandatory/auth_values.sql +++ b/installer/data/mysql/es-ES/mandatory/auth_values.sql @@ -1,3 +1,4 @@ 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', 'ONSITE', '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..4b85bdd2da 100644 --- a/installer/data/mysql/fr-CA/obligatoire/auth_values.sql +++ b/installer/data/mysql/fr-CA/obligatoire/auth_values.sql @@ -1,3 +1,4 @@ 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', 'ONSITE', '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..26db5db0bc 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,6 @@ 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'); + +-- Circulation types +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'ONSITE', '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..4113ef6cf3 100644 --- a/installer/data/mysql/it-IT/necessari/auth_val.sql +++ b/installer/data/mysql/it-IT/necessari/auth_val.sql @@ -119,3 +119,6 @@ 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'); + +-- Circulation types +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('CHECKOUT_TYPE', 'ONSITE', '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..4c2c704269 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,2 @@ 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', 'ONSITE', '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..4c2c704269 100644 --- a/installer/data/mysql/pl-PL/mandatory/auth_values.sql +++ b/installer/data/mysql/pl-PL/mandatory/auth_values.sql @@ -1 +1,2 @@ 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', 'ONSITE', '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..4c2c704269 100644 --- a/installer/data/mysql/ru-RU/mandatory/auth_values.sql +++ b/installer/data/mysql/ru-RU/mandatory/auth_values.sql @@ -1 +1,2 @@ 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', 'ONSITE', '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..ffd2463559 100644 --- a/installer/data/mysql/uk-UA/mandatory/auth_values.sql +++ b/installer/data/mysql/uk-UA/mandatory/auth_values.sql @@ -10,3 +10,7 @@ INSERT INTO `authorised_values` (category, authorised_value, lib, lib_opac) VALU -- Housebound INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Кожного тижня'); + +-- Circulation type +INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) + VALUES ('CHECKOUT_TYPE', 'ONSITE', 'On-site checkout', 'On-site checkout'); -- 2.17.1