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

(-)a/installer/data/mysql/ru-RU/mandatory/sample_notices_message_transports.sql (-2 lines)
Lines 1-5 Link Here
1
truncate message_transports;
2
3
insert into `message_transports`
1
insert into `message_transports`
4
(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
2
(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
5
values
3
values
(-)a/installer/data/mysql/uk-UA/mandatory/sample_notices_message_transports.sql (-13 / +3 lines)
Lines 1-13 Link Here
1
-- truncate message_transports;
1
insert into `message_transports`
2
--  message_attribute_id
2
(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
3
--  message_transport_type
3
values
4
--  is_digest     (default '0')
5
--  letter_module (default '')
6
--  letter_code   (default '')
7
--  branchcode    (default '')
8
SET FOREIGN_KEY_CHECKS=0;
9
insert into message_transports
10
 (message_attribute_id, message_transport_type, is_digest, letter_module, letter_code, branchcode) values
11
(1, 'email', 0, 'circulation', 'DUE'),
4
(1, 'email', 0, 'circulation', 'DUE'),
12
(1, 'email', 1, 'circulation', 'DUEDGST'),
5
(1, 'email', 1, 'circulation', 'DUEDGST'),
13
(1, 'sms',   0, 'circulation', 'DUE'),
6
(1, 'sms',   0, 'circulation', 'DUE'),
Lines 25-29 insert into message_transports Link Here
25
(5, 'sms',   0, 'circulation', 'CHECKIN'),
18
(5, 'sms',   0, 'circulation', 'CHECKIN'),
26
(6, 'email', 0, 'circulation', 'CHECKOUT'),
19
(6, 'email', 0, 'circulation', 'CHECKOUT'),
27
(6, 'sms',   0, 'circulation', 'CHECKOUT');
20
(6, 'sms',   0, 'circulation', 'CHECKOUT');
28
SET FOREIGN_KEY_CHECKS=1;
29
30
- 

Return to bug 21639