DROP TABLE IF EXISTS `debtor_contacts`;
CREATE TABLE `debtor_contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `debtor_id` int(11) NOT NULL,
  `firstname` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `etr_delivery` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `debtor_contacts` (`debtor_id`, `firstname`, `lastname`, `phone`, `email`, `etr_delivery`)
SELECT `d`.`debtor_id`, `d`.`debtor_contact_first_name`, `d`.`debtor_contact_last_name`, CONCAT(`ad`.`address_phone_country`, `ad`.`address_phone_code`, `ad`.`address_phone`) as `phone`, `ad`.`address_email`, '1' FROM `debtors_detail` `d`
LEFT JOIN `address_details` `ad` ON `d`.`contact_address_id` = `ad`.`address_id`
WHERE `d`.`type` = "debtor"