Highly ambitious ATProtocol AppView service and sdks
at main 357 B view raw
1-- Add 'cancelled' and 'running' as valid job statuses 2 3-- Drop the old constraint 4ALTER TABLE job_results 5DROP CONSTRAINT IF EXISTS job_results_status_check; 6 7-- Add the new constraint with 'cancelled' and 'running' included 8ALTER TABLE job_results 9ADD CONSTRAINT job_results_status_check 10CHECK (status IN ('completed', 'failed', 'cancelled', 'running'));