-- Add subject field to handover_requests
ALTER TABLE handover_requests ADD COLUMN subject VARCHAR(255) AFTER request_number;

-- Add refined testing fields to handover_tests
ALTER TABLE handover_tests ADD COLUMN module_name VARCHAR(100) AFTER handover_id;
ALTER TABLE handover_tests ADD COLUMN test_scenario TEXT AFTER module_name;
ALTER TABLE handover_tests ADD COLUMN status VARCHAR(50) AFTER test_result;