Lines 1-26
Link Here
|
1 |
-- truncate message_transports; |
|
|
2 |
-- message_attribute_id |
3 |
-- message_transport_type |
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', ''), |
12 |
(1, 'email', '1', 'circulation', 'DUEDGST', ''), |
13 |
(2, 'email', '0', 'circulation', 'PREDUE', ''), |
14 |
(2, 'email', '1', 'circulation', 'PREDUEDGST',''), |
15 |
(4, 'email', '0', 'reserves', 'HOLD', ''), |
16 |
(1, 'sms', '0', 'circulation', 'DUE', ''), |
17 |
(1, 'sms', '1', 'circulation', 'DUEDGST', ''), |
18 |
(2, 'sms', '0', 'circulation', 'PREDUE', ''), |
19 |
(2, 'sms', '1', 'circulation', 'PREDUEDGST',''), |
20 |
(4, 'sms', '0', 'reserves', 'HOLD', ''), |
21 |
(5, 'email', '0', 'circulation', 'CHECKIN', ''), |
22 |
(5, 'sms', '0', 'circulation', 'CHECKIN', ''), |
23 |
(6, 'email', '0', 'circulation', 'CHECKOUT', ''), |
24 |
(6, 'sms', '0', 'circulation', 'CHECKOUT', ''); |
25 |
SET FOREIGN_KEY_CHECKS=1; |
26 |
|