File: /www/exchange0old/sql/archive/2017-07-26.sql
ALTER TABLE `invoice_additional_documents` ADD `notification_status` ENUM('1','2') NOT NULL DEFAULT '1';
INSERT INTO `mail_management` (`mail_id`, `smtp_host`, `smtp_port`, `smtp_username`, `smtp_password`, `mail_name`, `mail_to`, `mail_from`, `mail_from_name`, `mail_subject`, `mail_type`, `mail_content`, `mail_content_text`, `mail_status`, `modified_at`, `modified_by`) VALUES
(62, 'localhost', '25', 'patrick.reynolds@credebtexchange.com', 'Gz1', 'Post Trade Document', 'treasury@credebtexchange.com', 'support@credebtexchange.com', 'Credebt Exchange Limited', '####### Post Trade Document #######', 1, 'Invoice id - <invoice_id>\r\nDocument name - <document_name>\r\nExpected date - <expected_date>', 'Invoice id - <invoice_id>\r\nDocument name - <document_name>\r\nExpected date - <expected_date>', 1, '2017-07-26 00:00:00', 0);