golang.org/x/build@v0.0.0-20240506185731-218518f32b70/internal/relui/migrations/20210928195553_create_task_logs_table.up.sql (about)

     1  -- Copyright 2021 The Go Authors. All rights reserved.
     2  -- Use of this source code is governed by a BSD-style
     3  -- license that can be found in the LICENSE file.
     4  
     5  CREATE TABLE task_logs (
     6    id SERIAL PRIMARY KEY,
     7    workflow_id uuid NOT NULL,
     8    task_name text NOT NULL,
     9    body text NOT NULL,
    10    created_at timestamp with time zone NOT NULL default current_timestamp,
    11    updated_at timestamp with time zone NOT NULL default current_timestamp,
    12    FOREIGN KEY (workflow_id, task_name) REFERENCES tasks (workflow_id, name)
    13  );