Bug 21639: Adjust the other languages

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>

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 ae68378..5954baf 100644 (file)
--- 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 ae68378..5954baf 100644 (file)
--- 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 ae68378..5954baf 100644 (file)
--- 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 ae68378..5954baf 100644 (file)
--- 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 c1b1f29..dd6a2d8 100644 (file)
--- 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 ae68378..5954baf 100644 (file)
--- 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 ae68378..5954baf 100644 (file)
--- 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 ade4d03..5de5c1a 100644 (file)
--- 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 387b181..09fbda0 100644 (file)
--- 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;