-- Adds the remaining editable email types. Existing administrator-edited
-- templates are deliberately left unchanged.
INSERT INTO email_templates (template_key,display_name,subject_template,body_template,enabled) VALUES
('meeting_reminder','Meeting reminder','Reminder – {{meeting_title}} on {{meeting_date}}','<p>Dear {{name}},</p><p>This is a reminder that {{meeting_title}} is on {{meeting_date}} at {{meeting_time}} at {{venue_name}}.</p>',1),
('booking_code','Booking code','Your booking code – {{booking_reference}}','<p>Dear {{name}},</p><p>Your new booking code is <strong>{{booking_code}}</strong>.</p>',1),
('place_confirmed','Waiting-list place confirmed','Your place is confirmed – {{booking_reference}}','<p>Dear {{name}},</p><p>Your place for {{meeting_title}} on {{meeting_date}} is now confirmed.</p>',1)
ON DUPLICATE KEY UPDATE display_name=VALUES(display_name);