From 5ab919812beea8cd4c781755acd0e2dec5366aac Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Fri, 17 Apr 2015 12:47:59 -0400 Subject: [PATCH] Bug 9468: [QA Followup] Signed-off-by: Jonathan Druart Signed-off-by: Tomas Cohen Arazi --- installer/data/mysql/de-DE/optional/auth_val.sql | 7 +++++++ installer/data/mysql/es-ES/optional/auth_val.sql | 7 +++++++ .../data/mysql/fr-FR/1-Obligatoire/authorised_values.sql | 7 +++++++ installer/data/mysql/it-IT/necessari/auth_val.sql | 7 +++++++ installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql | 7 +++++++ installer/data/mysql/pl-PL/optional/auth_val.sql | 7 +++++++ .../authorised_values_[SUGGEST_FORMAT].sql | 6 ++++++ .../authorised_values_[SUGGEST_FORMAT].txt | 1 + .../authorised_values_[SUGGEST_FORMAT].sql | 6 ++++++ .../authorised_values_[SUGGEST_FORMAT].txt | 1 + 10 files changed, 56 insertions(+) create mode 100644 installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST_FORMAT].sql create mode 100644 installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST_FORMAT].txt create mode 100644 installer/data/mysql/uk-UA/authorised_values/authorised_values_[SUGGEST_FORMAT].sql create mode 100644 installer/data/mysql/uk-UA/authorised_values/authorised_values_[SUGGEST_FORMAT].txt diff --git a/installer/data/mysql/de-DE/optional/auth_val.sql b/installer/data/mysql/de-DE/optional/auth_val.sql index 4e0d9cbf7b..240ff1b55f 100644 --- a/installer/data/mysql/de-DE/optional/auth_val.sql +++ b/installer/data/mysql/de-DE/optional/auth_val.sql @@ -76,3 +76,10 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); + +-- Desired formats for requesting new materials +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Book', 'Book'); +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'Large print', 'Large print'); +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'); diff --git a/installer/data/mysql/es-ES/optional/auth_val.sql b/installer/data/mysql/es-ES/optional/auth_val.sql index 71522ae50d..6fe4d43358 100644 --- a/installer/data/mysql/es-ES/optional/auth_val.sql +++ b/installer/data/mysql/es-ES/optional/auth_val.sql @@ -68,3 +68,10 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); + +-- Desired formats for requesting new materials +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Book', 'Book'); +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'Large print', 'Large print'); +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'); 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 4c4ef7e2cd..7115f51d26 100644 --- a/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql +++ b/installer/data/mysql/fr-FR/1-Obligatoire/authorised_values.sql @@ -710,3 +710,10 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('RESTRIC INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); + +-- Desired formats for requesting new materials +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Book', 'Book'); +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'Large print', 'Large print'); +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'); diff --git a/installer/data/mysql/it-IT/necessari/auth_val.sql b/installer/data/mysql/it-IT/necessari/auth_val.sql index c00b24393c..4c8cfb50b0 100644 --- a/installer/data/mysql/it-IT/necessari/auth_val.sql +++ b/installer/data/mysql/it-IT/necessari/auth_val.sql @@ -105,4 +105,11 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_C INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); +-- Desired formats for requesting new materials +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Book', 'Book'); +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'Large print', 'Large print'); +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'); + SET FOREIGN_KEY_CHECKS=1; diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql b/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql index 96894d20e2..8b66ca87a7 100644 --- a/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql +++ b/installer/data/mysql/nb-NO/2-Valgfritt/auth_val.sql @@ -97,3 +97,10 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); + +-- Desired formats for requesting new materials +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Book', 'Book'); +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'Large print', 'Large print'); +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'); diff --git a/installer/data/mysql/pl-PL/optional/auth_val.sql b/installer/data/mysql/pl-PL/optional/auth_val.sql index 0f8ae1c496..f0ea45b37c 100644 --- a/installer/data/mysql/pl-PL/optional/auth_val.sql +++ b/installer/data/mysql/pl-PL/optional/auth_val.sql @@ -76,3 +76,10 @@ INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SIP_MED INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 0, 'No reason provided'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 1, 'Out of stock'); INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('ORDER_CANCELLATION_REASON', 2, 'Restocking'); + +-- Desired formats for requesting new materials +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Book', 'Book'); +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'Large print', 'Large print'); +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'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST_FORMAT].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST_FORMAT].sql new file mode 100644 index 0000000000..507e3c93c3 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST_FORMAT].sql @@ -0,0 +1,6 @@ +-- Desired formats for requesting new materials +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Book', 'Book'); +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'Large print', 'Large print'); +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'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST_FORMAT].txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST_FORMAT].txt new file mode 100644 index 0000000000..23a3e68cdb --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST_FORMAT].txt @@ -0,0 +1 @@ +Desired formats for requesting new materials diff --git a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[SUGGEST_FORMAT].sql b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[SUGGEST_FORMAT].sql new file mode 100644 index 0000000000..507e3c93c3 --- /dev/null +++ b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[SUGGEST_FORMAT].sql @@ -0,0 +1,6 @@ +-- Desired formats for requesting new materials +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'BOOK', 'Book', 'Book'); +INSERT INTO authorised_values (category, authorised_value, lib, lib_opac) VALUES ('SUGGEST_FORMAT', 'LP', 'Large print', 'Large print'); +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'); diff --git a/installer/data/mysql/uk-UA/authorised_values/authorised_values_[SUGGEST_FORMAT].txt b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[SUGGEST_FORMAT].txt new file mode 100644 index 0000000000..23a3e68cdb --- /dev/null +++ b/installer/data/mysql/uk-UA/authorised_values/authorised_values_[SUGGEST_FORMAT].txt @@ -0,0 +1 @@ +Desired formats for requesting new materials -- 2.20.1