INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 1, "active": true, "language": "es", "mandatory": true, "event_type": "ENROLLMENT_ACTIVE", "name_field": "student_name", "email_field": "student_email", "template_key": "ENROLLMENT_ACTIVE_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 2, "active": true, "language": "es", "mandatory": true, "event_type": "ENROLLMENT_ACTIVE", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "ENROLLMENT_ACTIVE_TUTOR"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 3, "active": true, "language": "es", "mandatory": true, "event_type": "ENROLLMENT_PENDING", "name_field": "student_name", "email_field": "student_email", "template_key": "ENROLLMENT_PENDING_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 4, "active": true, "language": "es", "mandatory": true, "event_type": "ENROLLMENT_PENDING", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "ENROLLMENT_PENDING_TUTOR"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 5, "active": true, "language": "es", "mandatory": true, "event_type": "ENROLLMENT_REJECTED", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "ENROLLMENT_REJECTED_TUTOR"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 6, "active": true, "language": "es", "mandatory": false, "event_type": "GUEST_PROMOTED", "name_field": "student_name", "email_field": "student_email", "template_key": "GUEST_PROMOTED_PARTNER"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 7, "active": true, "language": "es", "mandatory": false, "event_type": "CLASS_REMINDER", "name_field": "student_name", "email_field": "student_email", "template_key": "CLASS_REMINDER_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 8, "active": true, "language": "es", "mandatory": true, "event_type": "STUDENT_CONFLICT", "name_field": "admin_name", "email_field": "admin_email", "template_key": "STUDENT_CONFLICT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 9, "active": true, "language": "es", "mandatory": true, "event_type": "TUTOR_REGISTERED", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "TUTOR_REGISTERED"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 10, "active": true, "language": "en", "mandatory": true, "event_type": "ENROLLMENT_ACTIVE", "name_field": "student_name", "email_field": "student_email", "template_key": "ENROLLMENT_ACTIVE_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 11, "active": true, "language": "en", "mandatory": true, "event_type": "ENROLLMENT_ACTIVE", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "ENROLLMENT_ACTIVE_TUTOR"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 12, "active": true, "language": "en", "mandatory": true, "event_type": "ENROLLMENT_PENDING", "name_field": "student_name", "email_field": "student_email", "template_key": "ENROLLMENT_PENDING_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 13, "active": true, "language": "en", "mandatory": true, "event_type": "ENROLLMENT_PENDING", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "ENROLLMENT_PENDING_TUTOR"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 14, "active": true, "language": "en", "mandatory": true, "event_type": "ENROLLMENT_REJECTED", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "ENROLLMENT_REJECTED_TUTOR"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 15, "active": true, "language": "en", "mandatory": false, "event_type": "GUEST_PROMOTED", "name_field": "student_name", "email_field": "student_email", "template_key": "GUEST_PROMOTED_PARTNER"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 16, "active": true, "language": "en", "mandatory": false, "event_type": "CLASS_REMINDER", "name_field": "student_name", "email_field": "student_email", "template_key": "CLASS_REMINDER_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 17, "active": true, "language": "en", "mandatory": true, "event_type": "STUDENT_CONFLICT", "name_field": "admin_name", "email_field": "admin_email", "template_key": "STUDENT_CONFLICT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 18, "active": true, "language": "en", "mandatory": true, "event_type": "TUTOR_REGISTERED", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "TUTOR_REGISTERED"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 19, "active": true, "language": "fr", "mandatory": true, "event_type": "ENROLLMENT_ACTIVE", "name_field": "student_name", "email_field": "student_email", "template_key": "ENROLLMENT_ACTIVE_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 20, "active": true, "language": "fr", "mandatory": true, "event_type": "ENROLLMENT_ACTIVE", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "ENROLLMENT_ACTIVE_TUTOR"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 21, "active": true, "language": "fr", "mandatory": true, "event_type": "ENROLLMENT_PENDING", "name_field": "student_name", "email_field": "student_email", "template_key": "ENROLLMENT_PENDING_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 22, "active": true, "language": "fr", "mandatory": true, "event_type": "ENROLLMENT_PENDING", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "ENROLLMENT_PENDING_TUTOR"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 23, "active": true, "language": "fr", "mandatory": true, "event_type": "ENROLLMENT_REJECTED", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "ENROLLMENT_REJECTED_TUTOR"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 24, "active": true, "language": "fr", "mandatory": false, "event_type": "GUEST_PROMOTED", "name_field": "student_name", "email_field": "student_email", "template_key": "GUEST_PROMOTED_PARTNER"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 25, "active": true, "language": "fr", "mandatory": false, "event_type": "CLASS_REMINDER", "name_field": "student_name", "email_field": "student_email", "template_key": "CLASS_REMINDER_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 26, "active": true, "language": "fr", "mandatory": true, "event_type": "STUDENT_CONFLICT", "name_field": "admin_name", "email_field": "admin_email", "template_key": "STUDENT_CONFLICT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 27, "active": true, "language": "fr", "mandatory": true, "event_type": "TUTOR_REGISTERED", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "TUTOR_REGISTERED"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 28, "active": true, "language": "it", "mandatory": true, "event_type": "ENROLLMENT_ACTIVE", "name_field": "student_name", "email_field": "student_email", "template_key": "ENROLLMENT_ACTIVE_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 29, "active": true, "language": "it", "mandatory": true, "event_type": "ENROLLMENT_ACTIVE", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "ENROLLMENT_ACTIVE_TUTOR"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 30, "active": true, "language": "it", "mandatory": true, "event_type": "ENROLLMENT_PENDING", "name_field": "student_name", "email_field": "student_email", "template_key": "ENROLLMENT_PENDING_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 31, "active": true, "language": "it", "mandatory": true, "event_type": "ENROLLMENT_PENDING", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "ENROLLMENT_PENDING_TUTOR"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 32, "active": true, "language": "it", "mandatory": true, "event_type": "ENROLLMENT_REJECTED", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "ENROLLMENT_REJECTED_TUTOR"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 33, "active": true, "language": "it", "mandatory": false, "event_type": "GUEST_PROMOTED", "name_field": "student_name", "email_field": "student_email", "template_key": "GUEST_PROMOTED_PARTNER"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 34, "active": true, "language": "it", "mandatory": false, "event_type": "CLASS_REMINDER", "name_field": "student_name", "email_field": "student_email", "template_key": "CLASS_REMINDER_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 35, "active": true, "language": "it", "mandatory": true, "event_type": "STUDENT_CONFLICT", "name_field": "admin_name", "email_field": "admin_email", "template_key": "STUDENT_CONFLICT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 36, "active": true, "language": "it", "mandatory": true, "event_type": "TUTOR_REGISTERED", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "TUTOR_REGISTERED"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 38, "active": true, "language": "es", "mandatory": false, "event_type": "SESSION_CANCELLED", "name_field": "student_name", "email_field": "student_email", "template_key": "SESSION_CANCELLED_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 39, "active": true, "language": "en", "mandatory": false, "event_type": "SESSION_CANCELLED", "name_field": "student_name", "email_field": "student_email", "template_key": "SESSION_CANCELLED_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 40, "active": true, "language": "fr", "mandatory": false, "event_type": "SESSION_CANCELLED", "name_field": "student_name", "email_field": "student_email", "template_key": "SESSION_CANCELLED_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 41, "active": true, "language": "it", "mandatory": false, "event_type": "SESSION_CANCELLED", "name_field": "student_name", "email_field": "student_email", "template_key": "SESSION_CANCELLED_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 42, "active": true, "language": "es", "mandatory": false, "event_type": "TUTOR_PREP_REMINDER", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "TUTOR_PREP_REMINDER"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 43, "active": true, "language": "fr", "mandatory": false, "event_type": "TUTOR_PREP_REMINDER", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "TUTOR_PREP_REMINDER"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 44, "active": true, "language": "en", "mandatory": false, "event_type": "TUTOR_PREP_REMINDER", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "TUTOR_PREP_REMINDER"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 45, "active": true, "language": "it", "mandatory": false, "event_type": "TUTOR_PREP_REMINDER", "name_field": "tutor_name", "email_field": "tutor_email", "template_key": "TUTOR_PREP_REMINDER"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 46, "active": true, "language": "es", "mandatory": false, "event_type": "STUDENT_LEVEL_CHECK", "name_field": "student_name", "email_field": "student_email", "template_key": "STUDENT_LEVEL_CHECK"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 47, "active": true, "language": "fr", "mandatory": false, "event_type": "STUDENT_LEVEL_CHECK", "name_field": "student_name", "email_field": "student_email", "template_key": "STUDENT_LEVEL_CHECK"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 48, "active": true, "language": "en", "mandatory": false, "event_type": "STUDENT_LEVEL_CHECK", "name_field": "student_name", "email_field": "student_email", "template_key": "STUDENT_LEVEL_CHECK"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 49, "active": true, "language": "it", "mandatory": false, "event_type": "STUDENT_LEVEL_CHECK", "name_field": "student_name", "email_field": "student_email", "template_key": "STUDENT_LEVEL_CHECK"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 50, "active": true, "language": "es", "mandatory": false, "event_type": "SESSION_REMINDER", "name_field": "student_name", "email_field": "student_email", "template_key": "SESSION_REMINDER_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 51, "active": true, "language": "en", "mandatory": false, "event_type": "SESSION_REMINDER", "name_field": "student_name", "email_field": "student_email", "template_key": "SESSION_REMINDER_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 52, "active": true, "language": "fr", "mandatory": false, "event_type": "SESSION_REMINDER", "name_field": "student_name", "email_field": "student_email", "template_key": "SESSION_REMINDER_STUDENT"}') ON CONFLICT DO NOTHING;
INSERT INTO public.email_dispatch_rules
SELECT * FROM jsonb_populate_record(NULL::public.email_dispatch_rules, '{"id": 53, "active": true, "language": "it", "mandatory": false, "event_type": "SESSION_REMINDER", "name_field": "student_name", "email_field": "student_email", "template_key": "SESSION_REMINDER_STUDENT"}') ON CONFLICT DO NOTHING;