INSERT INTO `tblemailtemplates` (`tenant_id`, `emailtemplateid`, `type`, `slug`, `language`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`, `is_tenant_email_config_allowed`, `is_tenant`) VALUES ('1', NULL, 'post-inspection', 'post-inspection-send-to-client', 'english', 'Send Post Inspection to Customer', 'Post Inspection # {post_inspection_number} created', '<span style=\"font-size: 12pt;\">Dear {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">Please find the attached estimate <strong># {post_inspection_number}</strong></span><br /><br /><span style=\"font-size: 12pt;\"><strong>Post inspection status:</strong> {post_inspection_status}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the estimate on the following link: <a href=\"{estimate_link}\">{post_inspection_number}</a></span><br /><br /><span style=\"font-size: 12pt;\">We look forward to your communication.</span><span style=\"font-size: 12pt;\"><br /></span>', '{companyname} | CRM', '', '0', '1', '0', '0', '0');
INSERT INTO `tblemailtemplates` (`tenant_id`, `emailtemplateid`, `type`, `slug`, `language`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`, `is_tenant_email_config_allowed`, `is_tenant`) VALUES ('1', NULL, 'post-inspection', 'post-inspection-already-send', 'english', 'Post inspection Already Sent to Customer', 'Post inspection # {post_inspection_number} ', '<span style=\"font-size: 12pt;\">Dear {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">Thank you for your estimate request.</span><br /><br /><span style=\"font-size: 12pt;\">You can view the estimate on the following link: <a href=\"{estimate_link}\">{post_inspection_number}</a></span><br /><br /><span style=\"font-size: 12pt;\">Please contact us for more information.</span>', '{companyname} | CRM', '', '0', '1', '0', '0', '0');

INSERT INTO `tblemailtemplates_static`(
    `emailtemplateid`,
    `type`,
    `slug`,
    `language`,
    `name`,
    `subject`,
    `message`,
    `fromname`,
    `fromemail`,
    `plaintext`,
    `active`,
    `order`
)
VALUES(
    NULL,
    'post-inspection',
    'post-inspection-send-to-client',
    'english',
    'Send Post Inspection to Customer',
    'Post Inspection # {post_inspection_number} created',
    '<span style=\"font-size: 12pt;\">Dear {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">Please find the attached estimate <strong># {post_inspection_number}</strong></span><br /><br /><span style=\"font-size: 12pt;\"><strong>Post inspection status:</strong> {post_inspection_status}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the estimate on the following link: <a href=\"{estimate_link}\">{post_inspection_number}</a></span><br /><br /><span style=\"font-size: 12pt;\">We look forward to your communication.</span><span style=\"font-size: 12pt;\"><br /></span>',
    '{companyname} | CRM',
    '',
    '0',
    '1',
    '0'
)

INSERT INTO `tblemailtemplates_static`(
    `emailtemplateid`,
    `type`,
    `slug`,
    `language`,
    `name`,
    `subject`,
    `message`,
    `fromname`,
    `fromemail`,
    `plaintext`,
    `active`,
    `order`
)
VALUES(
    NULL,
    'post-inspection',
    'post-inspection-already-send',
    'english',
    'Post inspection Already Sent to Customer',
    'Post inspection # {post_inspection_number} ',
    '<span style=\"font-size: 12pt;\">Dear {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">Thank you for your estimate request.</span><br /><br /><span style=\"font-size: 12pt;\">You can view the estimate on the following link: <a href=\"{estimate_link}\">{post_inspection_number}</a></span><br /><br /><span style=\"font-size: 12pt;\">Please contact us for more information.</span>',
    '{companyname} | CRM',
    '',
    '0',
    '1',
    '0'
)


ALTER TABLE `tblcontacts` ADD `post_inspection_emails` TINYINT(1) NOT NULL DEFAULT '1' AFTER `ticket_emails`;