ALTER TABLE `tbltenant_files` ADD `original_file_name` VARCHAR(191) NULL DEFAULT NULL AFTER `filename`, ADD `file_size` VARCHAR(191) NULL DEFAULT NULL AFTER `original_file_name`;

ALTER TABLE `tblactivity_log` ADD `tenant_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '1' AFTER `id`;

UPDATE `tblemailtemplates_static` SET `name` = 'Send PRO+ Estimate to Customer' WHERE `tblemailtemplates_static`.`emailtemplateid` = 2004;
UPDATE `tblemailtemplates_static` SET `name` = 'PRO+ Estimate Already Sent to Customer' WHERE `tblemailtemplates_static`.`emailtemplateid` = 2005;
UPDATE `tblemailtemplates_static` SET `subject` = 'PRO+ Estimate # {estimate_number} created' WHERE `tblemailtemplates_static`.`emailtemplateid` = 2004;
UPDATE `tblemailtemplates_static` SET `subject` = 'PRO+ Estimate # {estimate_number} ' WHERE `tblemailtemplates_static`.`emailtemplateid` = 2005;
UPDATE `tblemailtemplates_static` SET `message` = '<span style=\"font-size: 12pt;\">Dear {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">Please find the attached PRO+ Estimate <strong># {estimate_number}</strong></span><br /><br /><span style=\"font-size: 12pt;\"><strong>PRO+ Estimate status:</strong> {estimate_status}</span><br /><br /><span style=\"font-size: 12pt;\">You can view the PRO+ Estimate on the following link: <a href=\"{estimate_link}\">{estimate_number}</a></span><br /><br /><span style=\"font-size: 12pt;\">We look forward to your communication.</span><span style=\"font-size: 12pt;\"><br /></span>' WHERE `tblemailtemplates_static`.`emailtemplateid` = 2004;
UPDATE `tblemailtemplates_static` SET `message` = '<span style=\"font-size: 12pt;\">Dear {contact_firstname} {contact_lastname}</span><br /><br /><span style=\"font-size: 12pt;\">Thank you for your PRO+ Estimate request.</span><br /><br /><span style=\"font-size: 12pt;\">You can view the PRO+ Estimate on the following link: <a href=\"{estimate_link}\">{estimate_number}</a></span><br /><br /><span style=\"font-size: 12pt;\">Please contact us for more information.</span>' WHERE `tblemailtemplates_static`.`emailtemplateid` = 2005;