-- Migration to remove technician, startTime, endTime, workDescription fields from scenes table
-- Run this migration to update the database schema

-- Remove the fields from the scenes table
ALTER TABLE scenes 
DROP COLUMN technician,
DROP COLUMN startTime,
DROP COLUMN endTime,
DROP COLUMN workDescription;

-- Note: contractId is already nullable, so no changes needed for that field
