seecoder-devcloud/web/src/main/resources/sql/pipeline_history.sql

create table if not exists devcloud.pipeline_history
(
    id          int auto_increment
        primary key,
    pipeline_id int                                 null,
    start_time  timestamp default CURRENT_TIMESTAMP not null,
    user_id     int                                 null,
    result      varchar(15)                         null,
    details     text                                null,
    constraint pipeline_history_pipeline_id_fk
        foreign key (pipeline_id) references devcloud.pipeline (id),
    constraint pipeline_history_user_id_fk
        foreign key (user_id) references devcloud.user (id)
);