INSERT INTO `tblemailtemplates_static` (`type`, `slug`, `language`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`) VALUES ('lead', 'lead-from-cp-club', 'english', 'Lead from Contractor+ Club', 'New lead/estimate request from {lead_name}', '<span style="font-size: 12pt;">Hi {staff_firstname},</span><br/><br/><span style="font-size: 12pt;">You just got a new lead from {lead_name}.</span><br/><span style="font-size: 12pt;">Phone: {lead_phonenumber}</span><br/><span style="font-size: 12pt;">Email: {lead_email}</span><br/><span style="font-size: 12pt;">Address: {lead_address}</span><br/><br/><span style="font-size: 12pt;">Description:</span><br/><span style="font-size: 12pt;">{lead_description}</span><br/><br/><span style="font-size: 12pt;">This lead is now available in your leads dashboard inside the Contractor+ App.</span><br/><br/><span style="font-size: 12pt;">Make sure you call them fast to increase the chances of getting the job!</span><br/><br/><br/><span style="font-size: 12pt;">Regards,</span><br/><br/><span style="font-size: 12pt;">Lead Generation Team</span><br/><span style="font-size: 12pt;">Contractor+</span>', ' ', NULL, '0', '1', '0');
INSERT INTO `tblemailtemplates` (`tenant_id`, `type`, `slug`, `language`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`) SELECT id, 'lead', 'lead-from-cp-club', 'english', 'Lead from Contractor+ Club', 'New lead/estimate request from {lead_name}', '<span style="font-size: 12pt;">Hi {staff_firstname},</span><br/><br/><span style="font-size: 12pt;">You just got a new lead from {lead_name}.</span><br/><span style="font-size: 12pt;">Phone: {lead_phonenumber}</span><br/><span style="font-size: 12pt;">Email: {lead_email}</span><br/><span style="font-size: 12pt;">Address: {lead_address}</span><br/><br/><span style="font-size: 12pt;">Description:</span><br/><span style="font-size: 12pt;">{lead_description}</span><br/><br/><span style="font-size: 12pt;">This lead is now available in your leads dashboard inside the Contractor+ App.</span><br/><br/><span style="font-size: 12pt;">Make sure you call them fast to increase the chances of getting the job!</span><br/><br/><br/><span style="font-size: 12pt;">Regards,</span><br/><br/><span style="font-size: 12pt;">Lead Generation Team</span><br/><span style="font-size: 12pt;">Contractor+</span>', ' ', NULL, '0', '1', '0' FROM tbltenants;