-- Applies the requested booking-confirmation design and adds an editable
-- summons/invitation email template.
UPDATE email_templates
SET subject_template='{{lodge_name}} booking confirmation – {{meeting_date}}',
    body_template='<div style="margin:0;padding:24px;background:#122849;font-family:Georgia,serif;color:#17130f"><div style="max-width:656px;margin:0 auto;background:#fffdf8;border-top:5px solid #990033;padding:28px"><h2 style="margin:18px 0;color:#12305b">Booking confirmation</h2><p>Dear {{name}},</p><p>Your attendance has been recorded for <strong>{{meeting_date}}</strong>.</p><p><strong>Reference:</strong> {{booking_reference}}<br><strong>Booking &amp; Cancellation code:</strong> {{booking_code}}</p><p><strong>Total due:</strong> {{total_charge}}</p><p>{{payment_details}}<br><strong>Payment reference:</strong> {{booking_reference}}</p><p>Please keep your booking &amp; cancellation code safe.</p><hr style="border:0;border-top:1px solid #999;margin:20px 0"><p style="color:#756b60">{{lodge_name}}</p></div></div>'
WHERE template_key='booking_confirmation';

INSERT INTO email_templates(template_key,display_name,subject_template,body_template,enabled) VALUES
('summons_email','Summons or invitation email','{{meeting_title}} – {{document_name}}','<div style="margin:0;padding:24px;background:#122849;font-family:Georgia,serif;color:#17130f"><div style="max-width:656px;margin:0 auto;background:#fffdf8;border-top:5px solid #990033;padding:28px"><h2 style="color:#12305b">{{meeting_title}}</h2><p><strong>{{meeting_date}} at {{meeting_time}}</strong><br>{{venue_name}}</p><p>Your {{document_name}} is available using the button below.</p><p><a href="{{document_url}}" style="display:inline-block;background:#12305b;color:#fff;text-decoration:none;padding:12px 18px;border-radius:4px">View {{document_name}}</a></p><hr style="border:0;border-top:1px solid #999;margin:20px 0"><p style="color:#756b60">{{lodge_name}}</p></div></div>',1)
ON DUPLICATE KEY UPDATE display_name=VALUES(display_name),subject_template=VALUES(subject_template),body_template=VALUES(body_template),enabled=1;