From 0dcb453790e4bcba2f79965e0a93f96d52899d5e Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Wed, 24 Oct 2018 19:43:18 +0000 Subject: [PATCH] Bug 21639: Adjust the other languages Signed-off-by: Jonathan Druart --- .../sample_notices_message_transports.sql | 9 ++++--- .../sample_notices_message_transports.sql | 9 ++++--- .../sample_notices_message_transports.sql | 9 ++++--- .../sample_notices_message_transports.sql | 9 ++++--- .../sample_notices_message_transports.sql | 11 ++++---- .../sample_notices_message_transports.sql | 9 ++++--- .../sample_notices_message_transports.sql | 9 ++++--- .../sample_notices_message_transports.sql | 8 ++++-- .../sample_notices_message_transports.sql | 31 ++++++++++++---------- 9 files changed, 65 insertions(+), 39 deletions(-) diff --git a/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql b/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql index ae68378d13..5954bafc7b 100644 --- a/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql +++ b/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql @@ -3,14 +3,17 @@ insert into `message_transports` values (1, 'email', 0, 'circulation', 'DUE'), (1, 'email', 1, 'circulation', 'DUEDGST'), -(2, 'email', 0, 'circulation', 'PREDUE'), -(2, 'email', 1, 'circulation', 'PREDUEDGST'), -(4, 'email', 0, 'reserves', 'HOLD'), (1, 'sms', 0, 'circulation', 'DUE'), (1, 'sms', 1, 'circulation', 'DUEDGST'), +(2, 'email', 0, 'circulation', 'PREDUE'), +(2, 'email', 1, 'circulation', 'PREDUEDGST'), (2, 'sms', 0, 'circulation', 'PREDUE'), (2, 'sms', 1, 'circulation', 'PREDUEDGST'), +(2, 'phone', 0, 'circulation', 'PREDUE'), +(2, 'phone', 1, 'circulation', 'PREDUEDGST'), +(4, 'email', 0, 'reserves', 'HOLD'), (4, 'sms', 0, 'reserves', 'HOLD'), +(4, 'phone', 0, 'reserves', 'HOLD'), (5, 'email', 0, 'circulation', 'CHECKIN'), (5, 'sms', 0, 'circulation', 'CHECKIN'), (6, 'email', 0, 'circulation', 'CHECKOUT'), diff --git a/installer/data/mysql/es-ES/mandatory/sample_notices_message_transports.sql b/installer/data/mysql/es-ES/mandatory/sample_notices_message_transports.sql index ae68378d13..5954bafc7b 100644 --- a/installer/data/mysql/es-ES/mandatory/sample_notices_message_transports.sql +++ b/installer/data/mysql/es-ES/mandatory/sample_notices_message_transports.sql @@ -3,14 +3,17 @@ insert into `message_transports` values (1, 'email', 0, 'circulation', 'DUE'), (1, 'email', 1, 'circulation', 'DUEDGST'), -(2, 'email', 0, 'circulation', 'PREDUE'), -(2, 'email', 1, 'circulation', 'PREDUEDGST'), -(4, 'email', 0, 'reserves', 'HOLD'), (1, 'sms', 0, 'circulation', 'DUE'), (1, 'sms', 1, 'circulation', 'DUEDGST'), +(2, 'email', 0, 'circulation', 'PREDUE'), +(2, 'email', 1, 'circulation', 'PREDUEDGST'), (2, 'sms', 0, 'circulation', 'PREDUE'), (2, 'sms', 1, 'circulation', 'PREDUEDGST'), +(2, 'phone', 0, 'circulation', 'PREDUE'), +(2, 'phone', 1, 'circulation', 'PREDUEDGST'), +(4, 'email', 0, 'reserves', 'HOLD'), (4, 'sms', 0, 'reserves', 'HOLD'), +(4, 'phone', 0, 'reserves', 'HOLD'), (5, 'email', 0, 'circulation', 'CHECKIN'), (5, 'sms', 0, 'circulation', 'CHECKIN'), (6, 'email', 0, 'circulation', 'CHECKOUT'), diff --git a/installer/data/mysql/fr-CA/obligatoire/sample_notices_message_transports.sql b/installer/data/mysql/fr-CA/obligatoire/sample_notices_message_transports.sql index ae68378d13..5954bafc7b 100644 --- a/installer/data/mysql/fr-CA/obligatoire/sample_notices_message_transports.sql +++ b/installer/data/mysql/fr-CA/obligatoire/sample_notices_message_transports.sql @@ -3,14 +3,17 @@ insert into `message_transports` values (1, 'email', 0, 'circulation', 'DUE'), (1, 'email', 1, 'circulation', 'DUEDGST'), -(2, 'email', 0, 'circulation', 'PREDUE'), -(2, 'email', 1, 'circulation', 'PREDUEDGST'), -(4, 'email', 0, 'reserves', 'HOLD'), (1, 'sms', 0, 'circulation', 'DUE'), (1, 'sms', 1, 'circulation', 'DUEDGST'), +(2, 'email', 0, 'circulation', 'PREDUE'), +(2, 'email', 1, 'circulation', 'PREDUEDGST'), (2, 'sms', 0, 'circulation', 'PREDUE'), (2, 'sms', 1, 'circulation', 'PREDUEDGST'), +(2, 'phone', 0, 'circulation', 'PREDUE'), +(2, 'phone', 1, 'circulation', 'PREDUEDGST'), +(4, 'email', 0, 'reserves', 'HOLD'), (4, 'sms', 0, 'reserves', 'HOLD'), +(4, 'phone', 0, 'reserves', 'HOLD'), (5, 'email', 0, 'circulation', 'CHECKIN'), (5, 'sms', 0, 'circulation', 'CHECKIN'), (6, 'email', 0, 'circulation', 'CHECKOUT'), diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_transports.sql b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_transports.sql index ae68378d13..5954bafc7b 100644 --- a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_transports.sql +++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_transports.sql @@ -3,14 +3,17 @@ insert into `message_transports` values (1, 'email', 0, 'circulation', 'DUE'), (1, 'email', 1, 'circulation', 'DUEDGST'), -(2, 'email', 0, 'circulation', 'PREDUE'), -(2, 'email', 1, 'circulation', 'PREDUEDGST'), -(4, 'email', 0, 'reserves', 'HOLD'), (1, 'sms', 0, 'circulation', 'DUE'), (1, 'sms', 1, 'circulation', 'DUEDGST'), +(2, 'email', 0, 'circulation', 'PREDUE'), +(2, 'email', 1, 'circulation', 'PREDUEDGST'), (2, 'sms', 0, 'circulation', 'PREDUE'), (2, 'sms', 1, 'circulation', 'PREDUEDGST'), +(2, 'phone', 0, 'circulation', 'PREDUE'), +(2, 'phone', 1, 'circulation', 'PREDUEDGST'), +(4, 'email', 0, 'reserves', 'HOLD'), (4, 'sms', 0, 'reserves', 'HOLD'), +(4, 'phone', 0, 'reserves', 'HOLD'), (5, 'email', 0, 'circulation', 'CHECKIN'), (5, 'sms', 0, 'circulation', 'CHECKIN'), (6, 'email', 0, 'circulation', 'CHECKOUT'), diff --git a/installer/data/mysql/it-IT/necessari/sample_notices_message_transports.sql b/installer/data/mysql/it-IT/necessari/sample_notices_message_transports.sql index c1b1f29570..dd6a2d8368 100644 --- a/installer/data/mysql/it-IT/necessari/sample_notices_message_transports.sql +++ b/installer/data/mysql/it-IT/necessari/sample_notices_message_transports.sql @@ -5,16 +5,17 @@ insert into `message_transports` values (1, 'email', 0, 'circulation', 'DUE'), (1, 'email', 1, 'circulation', 'DUEDGST'), -(2, 'email', 0, 'circulation', 'PREDUE'), -(2, 'email', 1, 'circulation', 'PREDUEDGST'), -(3, 'email', 0, 'circulation', 'EVENT'), -(4, 'email', 0, 'reserves', 'HOLD'), (1, 'sms', 0, 'circulation', 'DUE'), (1, 'sms', 1, 'circulation', 'DUEDGST'), +(2, 'email', 0, 'circulation', 'PREDUE'), +(2, 'email', 1, 'circulation', 'PREDUEDGST'), (2, 'sms', 0, 'circulation', 'PREDUE'), (2, 'sms', 1, 'circulation', 'PREDUEDGST'), -(3, 'sms', 0, 'circulation', 'EVENT'), +(2, 'phone', 0, 'circulation', 'PREDUE'), +(2, 'phone', 1, 'circulation', 'PREDUEDGST'), +(4, 'email', 0, 'reserves', 'HOLD'), (4, 'sms', 0, 'reserves', 'HOLD'), +(4, 'phone', 0, 'reserves', 'HOLD'), (5, 'email', 0, 'circulation', 'CHECKIN'), (5, 'sms', 0, 'circulation', 'CHECKIN'), (6, 'email', 0, 'circulation', 'CHECKOUT'), diff --git a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_transports.sql b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_transports.sql index ae68378d13..5954bafc7b 100644 --- a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_transports.sql +++ b/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_transports.sql @@ -3,14 +3,17 @@ insert into `message_transports` values (1, 'email', 0, 'circulation', 'DUE'), (1, 'email', 1, 'circulation', 'DUEDGST'), -(2, 'email', 0, 'circulation', 'PREDUE'), -(2, 'email', 1, 'circulation', 'PREDUEDGST'), -(4, 'email', 0, 'reserves', 'HOLD'), (1, 'sms', 0, 'circulation', 'DUE'), (1, 'sms', 1, 'circulation', 'DUEDGST'), +(2, 'email', 0, 'circulation', 'PREDUE'), +(2, 'email', 1, 'circulation', 'PREDUEDGST'), (2, 'sms', 0, 'circulation', 'PREDUE'), (2, 'sms', 1, 'circulation', 'PREDUEDGST'), +(2, 'phone', 0, 'circulation', 'PREDUE'), +(2, 'phone', 1, 'circulation', 'PREDUEDGST'), +(4, 'email', 0, 'reserves', 'HOLD'), (4, 'sms', 0, 'reserves', 'HOLD'), +(4, 'phone', 0, 'reserves', 'HOLD'), (5, 'email', 0, 'circulation', 'CHECKIN'), (5, 'sms', 0, 'circulation', 'CHECKIN'), (6, 'email', 0, 'circulation', 'CHECKOUT'), diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices_message_transports.sql b/installer/data/mysql/pl-PL/mandatory/sample_notices_message_transports.sql index ae68378d13..5954bafc7b 100644 --- a/installer/data/mysql/pl-PL/mandatory/sample_notices_message_transports.sql +++ b/installer/data/mysql/pl-PL/mandatory/sample_notices_message_transports.sql @@ -3,14 +3,17 @@ insert into `message_transports` values (1, 'email', 0, 'circulation', 'DUE'), (1, 'email', 1, 'circulation', 'DUEDGST'), -(2, 'email', 0, 'circulation', 'PREDUE'), -(2, 'email', 1, 'circulation', 'PREDUEDGST'), -(4, 'email', 0, 'reserves', 'HOLD'), (1, 'sms', 0, 'circulation', 'DUE'), (1, 'sms', 1, 'circulation', 'DUEDGST'), +(2, 'email', 0, 'circulation', 'PREDUE'), +(2, 'email', 1, 'circulation', 'PREDUEDGST'), (2, 'sms', 0, 'circulation', 'PREDUE'), (2, 'sms', 1, 'circulation', 'PREDUEDGST'), +(2, 'phone', 0, 'circulation', 'PREDUE'), +(2, 'phone', 1, 'circulation', 'PREDUEDGST'), +(4, 'email', 0, 'reserves', 'HOLD'), (4, 'sms', 0, 'reserves', 'HOLD'), +(4, 'phone', 0, 'reserves', 'HOLD'), (5, 'email', 0, 'circulation', 'CHECKIN'), (5, 'sms', 0, 'circulation', 'CHECKIN'), (6, 'email', 0, 'circulation', 'CHECKOUT'), diff --git a/installer/data/mysql/ru-RU/mandatory/sample_notices_message_transports.sql b/installer/data/mysql/ru-RU/mandatory/sample_notices_message_transports.sql index ade4d03830..5de5c1aa40 100644 --- a/installer/data/mysql/ru-RU/mandatory/sample_notices_message_transports.sql +++ b/installer/data/mysql/ru-RU/mandatory/sample_notices_message_transports.sql @@ -5,13 +5,17 @@ insert into `message_transports` values (1, 'email', 0, 'circulation', 'DUE'), (1, 'email', 1, 'circulation', 'DUEDGST'), -(2, 'email', 0, 'circulation', 'PREDUE'), -(2, 'email', 1, 'circulation', 'PREDUEDGST'), (1, 'sms', 0, 'circulation', 'DUE'), (1, 'sms', 1, 'circulation', 'DUEDGST'), +(2, 'email', 0, 'circulation', 'PREDUE'), +(2, 'email', 1, 'circulation', 'PREDUEDGST'), (2, 'sms', 0, 'circulation', 'PREDUE'), (2, 'sms', 1, 'circulation', 'PREDUEDGST'), +(2, 'phone', 0, 'circulation', 'PREDUE'), +(2, 'phone', 1, 'circulation', 'PREDUEDGST'), +(4, 'email', 0, 'reserves', 'HOLD'), (4, 'sms', 0, 'reserves', 'HOLD'), +(4, 'phone', 0, 'reserves', 'HOLD'), (5, 'email', 0, 'circulation', 'CHECKIN'), (5, 'sms', 0, 'circulation', 'CHECKIN'), (6, 'email', 0, 'circulation', 'CHECKOUT'), diff --git a/installer/data/mysql/uk-UA/mandatory/sample_notices_message_transports.sql b/installer/data/mysql/uk-UA/mandatory/sample_notices_message_transports.sql index 387b181e81..09fbda0d65 100644 --- a/installer/data/mysql/uk-UA/mandatory/sample_notices_message_transports.sql +++ b/installer/data/mysql/uk-UA/mandatory/sample_notices_message_transports.sql @@ -8,19 +8,22 @@ SET FOREIGN_KEY_CHECKS=0; insert into message_transports (message_attribute_id, message_transport_type, is_digest, letter_module, letter_code, branchcode) values - (1, 'email', '0', 'circulation', 'DUE', ''), - (1, 'email', '1', 'circulation', 'DUEDGST', ''), - (2, 'email', '0', 'circulation', 'PREDUE', ''), - (2, 'email', '1', 'circulation', 'PREDUEDGST',''), - (4, 'email', '0', 'reserves', 'HOLD', ''), - (1, 'sms', '0', 'circulation', 'DUE', ''), - (1, 'sms', '1', 'circulation', 'DUEDGST', ''), - (2, 'sms', '0', 'circulation', 'PREDUE', ''), - (2, 'sms', '1', 'circulation', 'PREDUEDGST',''), - (4, 'sms', '0', 'reserves', 'HOLD', ''), - (5, 'email', '0', 'circulation', 'CHECKIN', ''), - (5, 'sms', '0', 'circulation', 'CHECKIN', ''), - (6, 'email', '0', 'circulation', 'CHECKOUT', ''), - (6, 'sms', '0', 'circulation', 'CHECKOUT', ''); +(1, 'email', 0, 'circulation', 'DUE'), +(1, 'email', 1, 'circulation', 'DUEDGST'), +(1, 'sms', 0, 'circulation', 'DUE'), +(1, 'sms', 1, 'circulation', 'DUEDGST'), +(2, 'email', 0, 'circulation', 'PREDUE'), +(2, 'email', 1, 'circulation', 'PREDUEDGST'), +(2, 'sms', 0, 'circulation', 'PREDUE'), +(2, 'sms', 1, 'circulation', 'PREDUEDGST'), +(2, 'phone', 0, 'circulation', 'PREDUE'), +(2, 'phone', 1, 'circulation', 'PREDUEDGST'), +(4, 'email', 0, 'reserves', 'HOLD'), +(4, 'sms', 0, 'reserves', 'HOLD'), +(4, 'phone', 0, 'reserves', 'HOLD'), +(5, 'email', 0, 'circulation', 'CHECKIN'), +(5, 'sms', 0, 'circulation', 'CHECKIN'), +(6, 'email', 0, 'circulation', 'CHECKOUT'), +(6, 'sms', 0, 'circulation', 'CHECKOUT'); SET FOREIGN_KEY_CHECKS=1; -- 2.11.0