-- Add WeekType enum and column to EngagementWeek
DO $$
BEGIN
  IF NOT EXISTS (SELECT 1 FROM pg_type WHERE typname = 'WeekType') THEN
    CREATE TYPE "WeekType" AS ENUM ('REHEARSAL', 'PERFORMANCE');
  END IF;
END $$;

ALTER TABLE "EngagementWeek"
  ADD COLUMN IF NOT EXISTS "weekType" "WeekType" NOT NULL DEFAULT 'REHEARSAL';
