-- Migration 024: course_email_rules
-- Per-course override for email event activation. Non-mandatory events only.

CREATE TABLE public.course_email_rules (
  id         serial PRIMARY KEY,
  course_id  integer      NOT NULL REFERENCES public.courses(course_id) ON DELETE CASCADE,
  event_type varchar(50)  NOT NULL,
  active     boolean      NOT NULL DEFAULT true,
  CONSTRAINT uq_course_email_rule UNIQUE (course_id, event_type)
);

GRANT SELECT, INSERT, UPDATE, DELETE ON public.course_email_rules TO "elfi1953_stc-eu";
GRANT USAGE, SELECT ON SEQUENCE public.course_email_rules_id_seq TO "elfi1953_stc-eu";