-- Migration 008: Add result configuration storage for PostgreSQL
-- Adds job result configuration fields to persist result storage settings

-- Add result configuration fields
ALTER TABLE hammerwork_jobs 
ADD COLUMN IF NOT EXISTS result_storage_type VARCHAR(20) DEFAULT 'none';

ALTER TABLE hammerwork_jobs 
ADD COLUMN IF NOT EXISTS result_ttl_seconds BIGINT;

ALTER TABLE hammerwork_jobs 
ADD COLUMN IF NOT EXISTS result_max_size_bytes BIGINT;