Attachment 102420 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), 9.05 KB, created by Lari Taskula on 2020-04-05 20:19:35 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Lari Taskula

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

Size: 9.05 KB

patch

obsolete

>From b9e0fee13797d067bb1b6844f922b320d81247ef 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   |  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

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