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