1 truncate message_transports;
3 insert into `message_transports`
4 (`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`)
6 (1, 'email', 0, 'circulation', 'DUE'),
7 (1, 'email', 1, 'circulation', 'DUEDGST'),
8 (1, 'sms', 0, 'circulation', 'DUE'),
9 (1, 'sms', 1, 'circulation', 'DUEDGST'),
10 (2, 'email', 0, 'circulation', 'PREDUE'),
11 (2, 'email', 1, 'circulation', 'PREDUEDGST'),
12 (2, 'sms', 0, 'circulation', 'PREDUE'),
13 (2, 'sms', 1, 'circulation', 'PREDUEDGST'),
14 (2, 'phone', 0, 'circulation', 'PREDUE'),
15 (2, 'phone', 1, 'circulation', 'PREDUEDGST'),
16 (4, 'email', 0, 'reserves', 'HOLD'),
17 (4, 'sms', 0, 'reserves', 'HOLD'),
18 (4, 'phone', 0, 'reserves', 'HOLD'),
19 (5, 'email', 0, 'circulation', 'CHECKIN'),
20 (5, 'sms', 0, 'circulation', 'CHECKIN'),
21 (6, 'email', 0, 'circulation', 'CHECKOUT'),
22 (6, 'sms', 0, 'circulation', 'CHECKOUT');