-- 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.

CREATE TABLE task_logs (
  id SERIAL PRIMARY KEY,
  workflow_id uuid NOT NULL,
  task_name text NOT NULL,
  body text NOT NULL,
  created_at timestamp with time zone NOT NULL default current_timestamp,
  updated_at timestamp with time zone NOT NULL default current_timestamp,
  FOREIGN KEY (workflow_id, task_name) REFERENCES tasks (workflow_id, name)
);