Files

13 lines
695 B
SQL

-- A task waiting on an operator decision is waiting_approval; the kind of
-- approval is derived from what it waits on (a plan or a review gate).
-- +goose Up
UPDATE tasks SET status = 'waiting_approval' WHERE status = 'waiting_human';
UPDATE transitions SET from_status = 'waiting_approval' WHERE from_status = 'waiting_human';
UPDATE transitions SET to_status = 'waiting_approval' WHERE to_status = 'waiting_human';
-- +goose Down
UPDATE tasks SET status = 'waiting_human' WHERE status = 'waiting_approval';
UPDATE transitions SET from_status = 'waiting_human' WHERE from_status = 'waiting_approval';
UPDATE transitions SET to_status = 'waiting_human' WHERE to_status = 'waiting_approval';