-- Ensure no NULLs exist and enforce NOT NULL with default on Performance.overtimeMinutes

-- Backfill any existing NULL values to 0
UPDATE "Performance"
SET "overtimeMinutes" = 0
WHERE "overtimeMinutes" IS NULL;

-- Ensure a default of 0
ALTER TABLE "Performance"
ALTER COLUMN "overtimeMinutes" SET DEFAULT 0;

-- Enforce NOT NULL constraint
ALTER TABLE "Performance"
ALTER COLUMN "overtimeMinutes" SET NOT NULL;
