Site Change Log

-- Site change requests (new submissions from Greg/Mike)
CREATE TABLE IF NOT EXISTS public.changelog_requests (
  id           uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  title        text NOT NULL,
  details      text NOT NULL,
  priority     text NOT NULL DEFAULT 'normal',
  requester    text,
  status       text NOT NULL DEFAULT 'open',
  created_at   timestamptz NOT NULL DEFAULT now()
);
ALTER TABLE public.changelog_requests ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Admin read" ON public.changelog_requests FOR SELECT USING (true);
CREATE POLICY "Admin insert" ON public.changelog_requests FOR INSERT WITH CHECK (true);
CREATE POLICY "Admin update" ON public.changelog_requests FOR UPDATE USING (true);

-- Notes/responses on any change log item (static history or new request)
CREATE TABLE IF NOT EXISTS public.changelog_notes (
  id           uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  request_id   text NOT NULL,
  note         text NOT NULL,
  author       text,
  created_at   timestamptz NOT NULL DEFAULT now()
);
ALTER TABLE public.changelog_notes ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Admin read notes" ON public.changelog_notes FOR SELECT USING (true);
CREATE POLICY "Admin insert notes" ON public.changelog_notes FOR INSERT WITH CHECK (true);