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