-- Extend generation_runs.kind to allow the new narrate_prep pass.
-- (Migration 0005 added body_md_tts but missed the check constraint.)
-- Postgres doesn't support altering a check constraint in place,
-- so we drop + re-add.
ALTER TABLE generation_runs
    DROP CONSTRAINT generation_runs_kind_check;
ALTER TABLE generation_runs
    ADD CONSTRAINT generation_runs_kind_check
    CHECK (kind = ANY (ARRAY['gen', 'cleanup', 'audit', 'summary', 'embed', 'narrate_prep']));