13 lines
695 B
SQL
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';
|