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 |
- |