Lines 8-26
Link Here
|
8 |
SET FOREIGN_KEY_CHECKS=0; |
8 |
SET FOREIGN_KEY_CHECKS=0; |
9 |
insert into message_transports |
9 |
insert into message_transports |
10 |
(message_attribute_id, message_transport_type, is_digest, letter_module, letter_code, branchcode) values |
10 |
(message_attribute_id, message_transport_type, is_digest, letter_module, letter_code, branchcode) values |
11 |
(1, 'email', '0', 'circulation', 'DUE', ''), |
11 |
(1, 'email', 0, 'circulation', 'DUE'), |
12 |
(1, 'email', '1', 'circulation', 'DUEDGST', ''), |
12 |
(1, 'email', 1, 'circulation', 'DUEDGST'), |
13 |
(2, 'email', '0', 'circulation', 'PREDUE', ''), |
13 |
(1, 'sms', 0, 'circulation', 'DUE'), |
14 |
(2, 'email', '1', 'circulation', 'PREDUEDGST',''), |
14 |
(1, 'sms', 1, 'circulation', 'DUEDGST'), |
15 |
(4, 'email', '0', 'reserves', 'HOLD', ''), |
15 |
(2, 'email', 0, 'circulation', 'PREDUE'), |
16 |
(1, 'sms', '0', 'circulation', 'DUE', ''), |
16 |
(2, 'email', 1, 'circulation', 'PREDUEDGST'), |
17 |
(1, 'sms', '1', 'circulation', 'DUEDGST', ''), |
17 |
(2, 'sms', 0, 'circulation', 'PREDUE'), |
18 |
(2, 'sms', '0', 'circulation', 'PREDUE', ''), |
18 |
(2, 'sms', 1, 'circulation', 'PREDUEDGST'), |
19 |
(2, 'sms', '1', 'circulation', 'PREDUEDGST',''), |
19 |
(2, 'phone', 0, 'circulation', 'PREDUE'), |
20 |
(4, 'sms', '0', 'reserves', 'HOLD', ''), |
20 |
(2, 'phone', 1, 'circulation', 'PREDUEDGST'), |
21 |
(5, 'email', '0', 'circulation', 'CHECKIN', ''), |
21 |
(4, 'email', 0, 'reserves', 'HOLD'), |
22 |
(5, 'sms', '0', 'circulation', 'CHECKIN', ''), |
22 |
(4, 'sms', 0, 'reserves', 'HOLD'), |
23 |
(6, 'email', '0', 'circulation', 'CHECKOUT', ''), |
23 |
(4, 'phone', 0, 'reserves', 'HOLD'), |
24 |
(6, 'sms', '0', 'circulation', 'CHECKOUT', ''); |
24 |
(5, 'email', 0, 'circulation', 'CHECKIN'), |
|
|
25 |
(5, 'sms', 0, 'circulation', 'CHECKIN'), |
26 |
(6, 'email', 0, 'circulation', 'CHECKOUT'), |
27 |
(6, 'sms', 0, 'circulation', 'CHECKOUT'); |
25 |
SET FOREIGN_KEY_CHECKS=1; |
28 |
SET FOREIGN_KEY_CHECKS=1; |
26 |
|
29 |
|
27 |
- |
|
|