create table account_detail
(
    id          bigint auto_increment
        primary key,
    ssid        varchar(64) not null comment 'ssid',
    type        varchar(64) null comment '类型',
    value       bigint      null comment '积分',
    create_time datetime    null comment '创建时间'
)
    comment '账户明细表';

create index idx_create_time_type
    on account_detail (create_time, type);

create index idx_ssid
    on account_detail (ssid);