From df38c00feb4eb34bb131ea97bdf46d2110714ae2 Mon Sep 17 00:00:00 2001 From: Alex Sassmannshausen Date: Tue, 8 Nov 2016 15:15:22 +0100 Subject: [PATCH] Bug 17576: Add housebound mandatory auth_values. * installer/data/mysql/de-DE/mandatory/auth_values.sql: Add values. * installer/data/mysql/es-ES/mandatory/auth_values.sql: Add values. * installer/data/mysql/fr-CA/obligatoire/auth_values.sql: Add values. * installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql: Add values. * installer/data/mysql/it-IT/necessari/auth_val.sql: Add values. * installer/data/mysql/nb-NO/1-Obligatorisk/auth_values.sql: New file. * installer/data/mysql/pl-PL/mandatory/auth_values.sql: New file. * installer/data/mysql/ru-RU/mandatory/auth_values.sql: New file. * installer/data/mysql/uk-UA/mandatory/auth_values.sql: New file. Signed-off-by: Jonathan Druart --- installer/data/mysql/de-DE/mandatory/auth_values.sql | 1 + installer/data/mysql/es-ES/mandatory/auth_values.sql | 1 + installer/data/mysql/fr-CA/obligatoire/auth_values.sql | 1 + installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql | 3 +++ installer/data/mysql/it-IT/necessari/auth_val.sql | 4 ++++ 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 | 1 + 9 files changed, 14 insertions(+) create mode 100644 installer/data/mysql/nb-NO/1-Obligatorisk/auth_values.sql create mode 100644 installer/data/mysql/pl-PL/mandatory/auth_values.sql create mode 100644 installer/data/mysql/ru-RU/mandatory/auth_values.sql create mode 100644 installer/data/mysql/uk-UA/mandatory/auth_values.sql diff --git a/installer/data/mysql/de-DE/mandatory/auth_values.sql b/installer/data/mysql/de-DE/mandatory/auth_values.sql index 8a728e4..e1a2797 100644 --- a/installer/data/mysql/de-DE/mandatory/auth_values.sql +++ b/installer/data/mysql/de-DE/mandatory/auth_values.sql @@ -1,2 +1,3 @@ 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'); diff --git a/installer/data/mysql/es-ES/mandatory/auth_values.sql b/installer/data/mysql/es-ES/mandatory/auth_values.sql index d7fb280..26328ef 100644 --- a/installer/data/mysql/es-ES/mandatory/auth_values.sql +++ b/installer/data/mysql/es-ES/mandatory/auth_values.sql @@ -1,2 +1,3 @@ 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'); diff --git a/installer/data/mysql/fr-CA/obligatoire/auth_values.sql b/installer/data/mysql/fr-CA/obligatoire/auth_values.sql index 123d4e7..c924949 100644 --- a/installer/data/mysql/fr-CA/obligatoire/auth_values.sql +++ b/installer/data/mysql/fr-CA/obligatoire/auth_values.sql @@ -1,2 +1,3 @@ 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'); 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 7115f51..b8ffb32 100644 --- a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql +++ b/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql @@ -717,3 +717,6 @@ INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'EBOOK', 'EBook', 'Ebook'); INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'AUDIOBOOK', 'Audiobook', 'Audiobook'); INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD'); + +-- Housebound +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Chaque Semaine'); diff --git a/installer/data/mysql/it-IT/necessari/auth_val.sql b/installer/data/mysql/it-IT/necessari/auth_val.sql index 3a065f1..765c85a 100644 --- a/installer/data/mysql/it-IT/necessari/auth_val.sql +++ b/installer/data/mysql/it-IT/necessari/auth_val.sql @@ -115,3 +115,7 @@ INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'DVD', 'DVD', 'DVD'); SET FOREIGN_KEY_CHECKS=1; + +-- Housebound +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week'); + diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/auth_values.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/auth_values.sql new file mode 100644 index 0000000..dbcc74f --- /dev/null +++ b/installer/data/mysql/nb-NO/1-Obligatorisk/auth_values.sql @@ -0,0 +1 @@ +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week'); diff --git a/installer/data/mysql/pl-PL/mandatory/auth_values.sql b/installer/data/mysql/pl-PL/mandatory/auth_values.sql new file mode 100644 index 0000000..dbcc74f --- /dev/null +++ b/installer/data/mysql/pl-PL/mandatory/auth_values.sql @@ -0,0 +1 @@ +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week'); diff --git a/installer/data/mysql/ru-RU/mandatory/auth_values.sql b/installer/data/mysql/ru-RU/mandatory/auth_values.sql new file mode 100644 index 0000000..dbcc74f --- /dev/null +++ b/installer/data/mysql/ru-RU/mandatory/auth_values.sql @@ -0,0 +1 @@ +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week'); diff --git a/installer/data/mysql/uk-UA/mandatory/auth_values.sql b/installer/data/mysql/uk-UA/mandatory/auth_values.sql new file mode 100644 index 0000000..dbcc74f --- /dev/null +++ b/installer/data/mysql/uk-UA/mandatory/auth_values.sql @@ -0,0 +1 @@ +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('HSBND_FREQ','EW','Every week'); -- 2.1.4