text: -- truncate message_transports;
  --  message_attribute_id
  --  message_transport_type
  --  is_digest     (default '0')
  --  letter_module (default '')
  --  letter_code   (default '')
  --  branchcode    (default '')
  SET FOREIGN_KEY_CHECKS=0;
  insert into message_transports
   (message_attribute_id, message_transport_type, is_digest, letter_module, letter_code, branchcode) values
   (1,                   'email',                 '0',       'circulation', 'DUE',       ''),
   (1,                   'email',                 '1',       'circulation', 'DUEDGST',   ''),
   (2,                   'email',                 '0',       'circulation', 'PREDUE',    ''),
   (2,                   'email',                 '1',       'circulation', 'PREDUEDGST',''),
   (4,                   'email',                 '0',       'reserves',    'HOLD',      ''),
   (1,                   'sms',                   '0',       'circulation', 'DUE',       ''),
   (1,                   'sms',                   '1',       'circulation', 'DUEDGST',   ''),
   (2,                   'sms',                   '0',       'circulation', 'PREDUE',    ''),
   (2,                   'sms',                   '1',       'circulation', 'PREDUEDGST',''),
   (4,                   'sms',                   '0',       'reserves',    'HOLD',      ''),
   (5,                   'email',                 '0',       'circulation', 'CHECKIN',   ''),
   (5,                   'sms',                   '0',       'circulation', 'CHECKIN',   ''),
   (6,                   'email',                 '0',       'circulation', 'CHECKOUT',  ''),
   (6,                   'sms',                   '0',       'circulation', 'CHECKOUT',  '');
  SET FOREIGN_KEY_CHECKS=1;
  
  