View | Details | Raw Unified | Return to bug 21639
Collapse All | Expand All

(-)a/installer/data/mysql/de-DE/mandatory/sample_notices_message_transports.sql (-3 / +6 lines)
Lines 3-16 insert into `message_transports` Link Here
3
values
3
values
4
(1, 'email', 0, 'circulation', 'DUE'),
4
(1, 'email', 0, 'circulation', 'DUE'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
6
(2, 'email', 0, 'circulation', 'PREDUE'),
7
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
8
(4, 'email', 0, 'reserves',    'HOLD'),
9
(1, 'sms',   0, 'circulation', 'DUE'),
6
(1, 'sms',   0, 'circulation', 'DUE'),
10
(1, 'sms',   1, 'circulation', 'DUEDGST'),
7
(1, 'sms',   1, 'circulation', 'DUEDGST'),
8
(2, 'email', 0, 'circulation', 'PREDUE'),
9
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
11
(2, 'sms',   0, 'circulation', 'PREDUE'),
10
(2, 'sms',   0, 'circulation', 'PREDUE'),
12
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
11
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
12
(2, 'phone', 0, 'circulation', 'PREDUE'),
13
(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
14
(4, 'email', 0, 'reserves',    'HOLD'),
13
(4, 'sms',   0, 'reserves',    'HOLD'),
15
(4, 'sms',   0, 'reserves',    'HOLD'),
16
(4, 'phone', 0, 'reserves',    'HOLD'),
14
(5, 'email', 0, 'circulation', 'CHECKIN'),
17
(5, 'email', 0, 'circulation', 'CHECKIN'),
15
(5, 'sms',   0, 'circulation', 'CHECKIN'),
18
(5, 'sms',   0, 'circulation', 'CHECKIN'),
16
(6, 'email', 0, 'circulation', 'CHECKOUT'),
19
(6, 'email', 0, 'circulation', 'CHECKOUT'),
(-)a/installer/data/mysql/es-ES/mandatory/sample_notices_message_transports.sql (-3 / +6 lines)
Lines 3-16 insert into `message_transports` Link Here
3
values
3
values
4
(1, 'email', 0, 'circulation', 'DUE'),
4
(1, 'email', 0, 'circulation', 'DUE'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
6
(2, 'email', 0, 'circulation', 'PREDUE'),
7
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
8
(4, 'email', 0, 'reserves',    'HOLD'),
9
(1, 'sms',   0, 'circulation', 'DUE'),
6
(1, 'sms',   0, 'circulation', 'DUE'),
10
(1, 'sms',   1, 'circulation', 'DUEDGST'),
7
(1, 'sms',   1, 'circulation', 'DUEDGST'),
8
(2, 'email', 0, 'circulation', 'PREDUE'),
9
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
11
(2, 'sms',   0, 'circulation', 'PREDUE'),
10
(2, 'sms',   0, 'circulation', 'PREDUE'),
12
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
11
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
12
(2, 'phone', 0, 'circulation', 'PREDUE'),
13
(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
14
(4, 'email', 0, 'reserves',    'HOLD'),
13
(4, 'sms',   0, 'reserves',    'HOLD'),
15
(4, 'sms',   0, 'reserves',    'HOLD'),
16
(4, 'phone', 0, 'reserves',    'HOLD'),
14
(5, 'email', 0, 'circulation', 'CHECKIN'),
17
(5, 'email', 0, 'circulation', 'CHECKIN'),
15
(5, 'sms',   0, 'circulation', 'CHECKIN'),
18
(5, 'sms',   0, 'circulation', 'CHECKIN'),
16
(6, 'email', 0, 'circulation', 'CHECKOUT'),
19
(6, 'email', 0, 'circulation', 'CHECKOUT'),
(-)a/installer/data/mysql/fr-CA/obligatoire/sample_notices_message_transports.sql (-3 / +6 lines)
Lines 3-16 insert into `message_transports` Link Here
3
values
3
values
4
(1, 'email', 0, 'circulation', 'DUE'),
4
(1, 'email', 0, 'circulation', 'DUE'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
6
(2, 'email', 0, 'circulation', 'PREDUE'),
7
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
8
(4, 'email', 0, 'reserves',    'HOLD'),
9
(1, 'sms',   0, 'circulation', 'DUE'),
6
(1, 'sms',   0, 'circulation', 'DUE'),
10
(1, 'sms',   1, 'circulation', 'DUEDGST'),
7
(1, 'sms',   1, 'circulation', 'DUEDGST'),
8
(2, 'email', 0, 'circulation', 'PREDUE'),
9
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
11
(2, 'sms',   0, 'circulation', 'PREDUE'),
10
(2, 'sms',   0, 'circulation', 'PREDUE'),
12
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
11
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
12
(2, 'phone', 0, 'circulation', 'PREDUE'),
13
(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
14
(4, 'email', 0, 'reserves',    'HOLD'),
13
(4, 'sms',   0, 'reserves',    'HOLD'),
15
(4, 'sms',   0, 'reserves',    'HOLD'),
16
(4, 'phone', 0, 'reserves',    'HOLD'),
14
(5, 'email', 0, 'circulation', 'CHECKIN'),
17
(5, 'email', 0, 'circulation', 'CHECKIN'),
15
(5, 'sms',   0, 'circulation', 'CHECKIN'),
18
(5, 'sms',   0, 'circulation', 'CHECKIN'),
16
(6, 'email', 0, 'circulation', 'CHECKOUT'),
19
(6, 'email', 0, 'circulation', 'CHECKOUT'),
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices_message_transports.sql (-3 / +6 lines)
Lines 3-16 insert into `message_transports` Link Here
3
values
3
values
4
(1, 'email', 0, 'circulation', 'DUE'),
4
(1, 'email', 0, 'circulation', 'DUE'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
6
(2, 'email', 0, 'circulation', 'PREDUE'),
7
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
8
(4, 'email', 0, 'reserves',    'HOLD'),
9
(1, 'sms',   0, 'circulation', 'DUE'),
6
(1, 'sms',   0, 'circulation', 'DUE'),
10
(1, 'sms',   1, 'circulation', 'DUEDGST'),
7
(1, 'sms',   1, 'circulation', 'DUEDGST'),
8
(2, 'email', 0, 'circulation', 'PREDUE'),
9
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
11
(2, 'sms',   0, 'circulation', 'PREDUE'),
10
(2, 'sms',   0, 'circulation', 'PREDUE'),
12
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
11
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
12
(2, 'phone', 0, 'circulation', 'PREDUE'),
13
(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
14
(4, 'email', 0, 'reserves',    'HOLD'),
13
(4, 'sms',   0, 'reserves',    'HOLD'),
15
(4, 'sms',   0, 'reserves',    'HOLD'),
16
(4, 'phone', 0, 'reserves',    'HOLD'),
14
(5, 'email', 0, 'circulation', 'CHECKIN'),
17
(5, 'email', 0, 'circulation', 'CHECKIN'),
15
(5, 'sms',   0, 'circulation', 'CHECKIN'),
18
(5, 'sms',   0, 'circulation', 'CHECKIN'),
16
(6, 'email', 0, 'circulation', 'CHECKOUT'),
19
(6, 'email', 0, 'circulation', 'CHECKOUT'),
(-)a/installer/data/mysql/it-IT/necessari/sample_notices_message_transports.sql (-5 / +6 lines)
Lines 5-20 insert into `message_transports` Link Here
5
values
5
values
6
(1, 'email', 0, 'circulation', 'DUE'),
6
(1, 'email', 0, 'circulation', 'DUE'),
7
(1, 'email', 1, 'circulation', 'DUEDGST'),
7
(1, 'email', 1, 'circulation', 'DUEDGST'),
8
(2, 'email', 0, 'circulation', 'PREDUE'),
9
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
10
(3, 'email', 0, 'circulation', 'EVENT'),
11
(4, 'email', 0, 'reserves',    'HOLD'),
12
(1, 'sms',   0, 'circulation', 'DUE'),
8
(1, 'sms',   0, 'circulation', 'DUE'),
13
(1, 'sms',   1, 'circulation', 'DUEDGST'),
9
(1, 'sms',   1, 'circulation', 'DUEDGST'),
10
(2, 'email', 0, 'circulation', 'PREDUE'),
11
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
14
(2, 'sms',   0, 'circulation', 'PREDUE'),
12
(2, 'sms',   0, 'circulation', 'PREDUE'),
15
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
13
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
16
(3, 'sms',   0, 'circulation', 'EVENT'),
14
(2, 'phone', 0, 'circulation', 'PREDUE'),
15
(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
16
(4, 'email', 0, 'reserves',    'HOLD'),
17
(4, 'sms',   0, 'reserves',    'HOLD'),
17
(4, 'sms',   0, 'reserves',    'HOLD'),
18
(4, 'phone', 0, 'reserves',    'HOLD'),
18
(5, 'email', 0, 'circulation', 'CHECKIN'),
19
(5, 'email', 0, 'circulation', 'CHECKIN'),
19
(5, 'sms',   0, 'circulation', 'CHECKIN'),
20
(5, 'sms',   0, 'circulation', 'CHECKIN'),
20
(6, 'email', 0, 'circulation', 'CHECKOUT'),
21
(6, 'email', 0, 'circulation', 'CHECKOUT'),
(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/sample_notices_message_transports.sql (-3 / +6 lines)
Lines 3-16 insert into `message_transports` Link Here
3
values
3
values
4
(1, 'email', 0, 'circulation', 'DUE'),
4
(1, 'email', 0, 'circulation', 'DUE'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
6
(2, 'email', 0, 'circulation', 'PREDUE'),
7
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
8
(4, 'email', 0, 'reserves',    'HOLD'),
9
(1, 'sms',   0, 'circulation', 'DUE'),
6
(1, 'sms',   0, 'circulation', 'DUE'),
10
(1, 'sms',   1, 'circulation', 'DUEDGST'),
7
(1, 'sms',   1, 'circulation', 'DUEDGST'),
8
(2, 'email', 0, 'circulation', 'PREDUE'),
9
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
11
(2, 'sms',   0, 'circulation', 'PREDUE'),
10
(2, 'sms',   0, 'circulation', 'PREDUE'),
12
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
11
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
12
(2, 'phone', 0, 'circulation', 'PREDUE'),
13
(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
14
(4, 'email', 0, 'reserves',    'HOLD'),
13
(4, 'sms',   0, 'reserves',    'HOLD'),
15
(4, 'sms',   0, 'reserves',    'HOLD'),
16
(4, 'phone', 0, 'reserves',    'HOLD'),
14
(5, 'email', 0, 'circulation', 'CHECKIN'),
17
(5, 'email', 0, 'circulation', 'CHECKIN'),
15
(5, 'sms',   0, 'circulation', 'CHECKIN'),
18
(5, 'sms',   0, 'circulation', 'CHECKIN'),
16
(6, 'email', 0, 'circulation', 'CHECKOUT'),
19
(6, 'email', 0, 'circulation', 'CHECKOUT'),
(-)a/installer/data/mysql/pl-PL/mandatory/sample_notices_message_transports.sql (-3 / +6 lines)
Lines 3-16 insert into `message_transports` Link Here
3
values
3
values
4
(1, 'email', 0, 'circulation', 'DUE'),
4
(1, 'email', 0, 'circulation', 'DUE'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
6
(2, 'email', 0, 'circulation', 'PREDUE'),
7
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
8
(4, 'email', 0, 'reserves',    'HOLD'),
9
(1, 'sms',   0, 'circulation', 'DUE'),
6
(1, 'sms',   0, 'circulation', 'DUE'),
10
(1, 'sms',   1, 'circulation', 'DUEDGST'),
7
(1, 'sms',   1, 'circulation', 'DUEDGST'),
8
(2, 'email', 0, 'circulation', 'PREDUE'),
9
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
11
(2, 'sms',   0, 'circulation', 'PREDUE'),
10
(2, 'sms',   0, 'circulation', 'PREDUE'),
12
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
11
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
12
(2, 'phone', 0, 'circulation', 'PREDUE'),
13
(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
14
(4, 'email', 0, 'reserves',    'HOLD'),
13
(4, 'sms',   0, 'reserves',    'HOLD'),
15
(4, 'sms',   0, 'reserves',    'HOLD'),
16
(4, 'phone', 0, 'reserves',    'HOLD'),
14
(5, 'email', 0, 'circulation', 'CHECKIN'),
17
(5, 'email', 0, 'circulation', 'CHECKIN'),
15
(5, 'sms',   0, 'circulation', 'CHECKIN'),
18
(5, 'sms',   0, 'circulation', 'CHECKIN'),
16
(6, 'email', 0, 'circulation', 'CHECKOUT'),
19
(6, 'email', 0, 'circulation', 'CHECKOUT'),
(-)a/installer/data/mysql/ru-RU/mandatory/sample_notices_message_transports.sql (-2 / +6 lines)
Lines 5-17 insert into `message_transports` Link Here
5
values
5
values
6
(1, 'email', 0, 'circulation', 'DUE'),
6
(1, 'email', 0, 'circulation', 'DUE'),
7
(1, 'email', 1, 'circulation', 'DUEDGST'),
7
(1, 'email', 1, 'circulation', 'DUEDGST'),
8
(2, 'email', 0, 'circulation', 'PREDUE'),
9
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
10
(1, 'sms',   0, 'circulation', 'DUE'),
8
(1, 'sms',   0, 'circulation', 'DUE'),
11
(1, 'sms',   1, 'circulation', 'DUEDGST'),
9
(1, 'sms',   1, 'circulation', 'DUEDGST'),
10
(2, 'email', 0, 'circulation', 'PREDUE'),
11
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
12
(2, 'sms',   0, 'circulation', 'PREDUE'),
12
(2, 'sms',   0, 'circulation', 'PREDUE'),
13
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
13
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
14
(2, 'phone', 0, 'circulation', 'PREDUE'),
15
(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
16
(4, 'email', 0, 'reserves',    'HOLD'),
14
(4, 'sms',   0, 'reserves',    'HOLD'),
17
(4, 'sms',   0, 'reserves',    'HOLD'),
18
(4, 'phone', 0, 'reserves',    'HOLD'),
15
(5, 'email', 0, 'circulation', 'CHECKIN'),
19
(5, 'email', 0, 'circulation', 'CHECKIN'),
16
(5, 'sms',   0, 'circulation', 'CHECKIN'),
20
(5, 'sms',   0, 'circulation', 'CHECKIN'),
17
(6, 'email', 0, 'circulation', 'CHECKOUT'),
21
(6, 'email', 0, 'circulation', 'CHECKOUT'),
(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices_message_transports.sql (-15 / +17 lines)
Lines 8-26 Link Here
8
SET FOREIGN_KEY_CHECKS=0;
8
SET FOREIGN_KEY_CHECKS=0;
9
insert into message_transports
9
insert into message_transports
10
 (message_attribute_id, message_transport_type, is_digest, letter_module, letter_code, branchcode) values
10
 (message_attribute_id, message_transport_type, is_digest, letter_module, letter_code, branchcode) values
11
 (1,                   'email',                 '0',       'circulation', 'DUE',       ''),
11
(1, 'email', 0, 'circulation', 'DUE'),
12
 (1,                   'email',                 '1',       'circulation', 'DUEDGST',   ''),
12
(1, 'email', 1, 'circulation', 'DUEDGST'),
13
 (2,                   'email',                 '0',       'circulation', 'PREDUE',    ''),
13
(1, 'sms',   0, 'circulation', 'DUE'),
14
 (2,                   'email',                 '1',       'circulation', 'PREDUEDGST',''),
14
(1, 'sms',   1, 'circulation', 'DUEDGST'),
15
 (4,                   'email',                 '0',       'reserves',    'HOLD',      ''),
15
(2, 'email', 0, 'circulation', 'PREDUE'),
16
 (1,                   'sms',                   '0',       'circulation', 'DUE',       ''),
16
(2, 'email', 1, 'circulation', 'PREDUEDGST'),
17
 (1,                   'sms',                   '1',       'circulation', 'DUEDGST',   ''),
17
(2, 'sms',   0, 'circulation', 'PREDUE'),
18
 (2,                   'sms',                   '0',       'circulation', 'PREDUE',    ''),
18
(2, 'sms',   1, 'circulation', 'PREDUEDGST'),
19
 (2,                   'sms',                   '1',       'circulation', 'PREDUEDGST',''),
19
(2, 'phone', 0, 'circulation', 'PREDUE'),
20
 (4,                   'sms',                   '0',       'reserves',    'HOLD',      ''),
20
(2, 'phone', 1, 'circulation', 'PREDUEDGST'),
21
 (5,                   'email',                 '0',       'circulation', 'CHECKIN',   ''),
21
(4, 'email', 0, 'reserves',    'HOLD'),
22
 (5,                   'sms',                   '0',       'circulation', 'CHECKIN',   ''),
22
(4, 'sms',   0, 'reserves',    'HOLD'),
23
 (6,                   'email',                 '0',       'circulation', 'CHECKOUT',  ''),
23
(4, 'phone', 0, 'reserves',    'HOLD'),
24
 (6,                   'sms',                   '0',       'circulation', 'CHECKOUT',  '');
24
(5, 'email', 0, 'circulation', 'CHECKIN'),
25
(5, 'sms',   0, 'circulation', 'CHECKIN'),
26
(6, 'email', 0, 'circulation', 'CHECKOUT'),
27
(6, 'sms',   0, 'circulation', 'CHECKOUT');
25
SET FOREIGN_KEY_CHECKS=1;
28
SET FOREIGN_KEY_CHECKS=1;
26
29
27
- 

Return to bug 21639