emoon-backend/script/sql/mysql-bak-2025-09-26/sj_retry_summary.sql

create table sj_retry_summary
(
    id            bigint unsigned auto_increment comment '主键'
        primary key,
    namespace_id  varchar(64) default '764d604ec6fc45f68cd92514c40e9e1a' not null comment '命名空间id',
    group_name    varchar(64) default ''                                 not null comment '组名称',
    scene_name    varchar(50) default ''                                 not null comment '场景名称',
    trigger_at    datetime    default CURRENT_TIMESTAMP                  not null comment '统计时间',
    running_num   int         default 0                                  not null comment '重试中-日志数量',
    finish_num    int         default 0                                  not null comment '重试完成-日志数量',
    max_count_num int         default 0                                  not null comment '重试到达最大次数-日志数量',
    suspend_num   int         default 0                                  not null comment '暂停重试-日志数量',
    create_dt     datetime    default CURRENT_TIMESTAMP                  not null comment '创建时间',
    update_dt     datetime    default CURRENT_TIMESTAMP                  not null on update CURRENT_TIMESTAMP comment '修改时间',
    constraint uk_scene_name_trigger_at
        unique (namespace_id, group_name, scene_name, trigger_at)
)
    comment 'DashBoard_Retry';

create index idx_trigger_at
    on sj_retry_summary (trigger_at);