-- Copyright 2021 The Go Authors. All rights reserved.
-- Use of this source code is governed by a BSD-style
-- license that can be found in the LICENSE file.

BEGIN;

ALTER TABLE workflows
    ADD COLUMN finished bool NOT NULL DEFAULT false;

CREATE INDEX workflows_finished_ix ON workflows (finished) WHERE finished = false;

ALTER TABLE workflows
    ADD COLUMN output jsonb NOT NULL DEFAULT jsonb_build_object();

ALTER TABLE workflows
    ADD COLUMN error text NOT NULL DEFAULT '';

UPDATE workflows
SET finished = true
WHERE workflows.id NOT IN (
    SELECT DISTINCT tasks.workflow_id
    FROM tasks
    WHERE finished = false
);

COMMIT;