ALTER TABLE `tblstaff` ADD `intro_video_seen` TINYINT(1) NOT NULL DEFAULT '0' AFTER `refresh_permissions`;


UPDATE tblemailtemplates_static SET message = '<span style="font-size: 12pt;">Hi {contact_firstname} {contact_lastname},</span><br/><br/><span style="font-size: 12pt;">Attached is a new estimate for {estimate_client_address_street}. The job is estimated to take {estimate_total_hours} hours which brings the labor total to {labour_total_charge}. The supply total comes to {supply_total_charge}. The taxes come to: {total_tax}. The grand total of your estimate is {estimate_total}.</span><br/><br/><span style="font-size: 12pt;">You can view the detailed estimate at this link: <a href="{estimate_link}">{estimate_number}-{estimate_client_property_street_1}{estimate_client_property_street_2}.pdf.</a></span><br/><br/><span style="font-size: 12pt;">If you have any questions, I\'m here to help!</span><br/><br/><span style="font-size: 12pt;">{email_signature}</span>' WHERE slug IN ('detail-estimate-already-send', 'detail-estimate-send-to-client');

UPDATE tblemailtemplates SET message = '<span style="font-size: 12pt;">Hi {contact_firstname} {contact_lastname},</span><br/><br/><span style="font-size: 12pt;">Attached is a new estimate for {estimate_client_address_street}. The job is estimated to take {estimate_total_hours} hours which brings the labor total to {labour_total_charge}. The supply total comes to {supply_total_charge}. The taxes come to: {total_tax}. The grand total of your estimate is {estimate_total}.</span><br/><br/><span style="font-size: 12pt;">You can view the detailed estimate at this link: <a href="{estimate_link}">{estimate_number}-{estimate_client_property_street_1}{estimate_client_property_street_2}.pdf.</a></span><br/><br/><span style="font-size: 12pt;">If you have any questions, I\'m here to help!</span><br/><br/><span style="font-size: 12pt;">{email_signature}</span>' WHERE slug IN ('detail-estimate-already-send', 'detail-estimate-send-to-client');