Lines 1-24
Link Here
|
1 |
SET FOREIGN_KEY_CHECKS=0; |
|
|
2 |
|
3 |
insert into `message_transports` |
4 |
(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`) |
5 |
values |
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'); |
23 |
|
24 |
SET FOREIGN_KEY_CHECKS=1; |