Attachment 102414 Details for Bug 25037 – Bug 25037: Add authorised values to sample data

[patch] Bug 25037: Add authorised values to sample data

Bug-25037-Add-authorised-values-to-sample-data.patch (text/plain), 7.75 KB, created by Lari Taskula on 2020-04-05 19:31:20 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Lari Taskula

Created: 2020-04-05 19:31:20 UTC

Size: 7.75 KB

patch

obsolete

>From 50992fb4204c49d39217e30b31a3b2a056eaa026 Mon Sep 17 00:00:00 2001
>From: Lari Taskula <lari.taskula@hypernova.fi>
>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         | 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

Actions: View | Diff | Splinter Review

Attachments on bug 25037: 102259 | 102260 | 102261 | 102262 | 102263 | 102264 | 102265 | 102266 | 102267 | 102268 | 102269 | 102272 | 102413 | 102414 | 102415 | 102416 | 102417 | 102418 | 102419 | 102420 | 102421 | 102422 | 102423 | 102424 | 102586 | 102587 | 102588 | 102589 | 102590 | 102591 | 102592 | 102593 | 102594 | 102595 | 102596 | 102597 | 102598 | 102599 | 102655 | 102656 | 102657 | 102658 | 102659 | 102660 | 102661 | 102662 | 102663 | 102664 | 102665 | 102666 | 102675 | 102676 | 104267 | 104268 | 105638 | 105780 | 105781 | 105782 | 105783 | 105784