INSERT INTO tblsms_templates_static (type, template) 
VALUES('job_booking_confirmation',"Hi {client_first_name}, You're booking is confirmed with {companyname} for {client_address_street} at {start_time} on {visit_date}. Regards, {companyname}");


INSERT INTO tblsms_templates (tenant_id, type,template,created_on,updated_on )
SELECT t.id,s.type,s.template,UTC_TIMESTAMP(),UTC_TIMESTAMP()
FROM tbltenants t
JOIN tblsms_templates_static s ON 1 = 1 AND s.type ='job_booking_confirmation';
