create table device_risk
(
    device_id   varchar(64)            not null
        primary key,
    scene_type  varchar(64) default '' not null,
    risk_level  int                    not null,
    create_time datetime               not null,
    update_time datetime               not null
);

alter table device_risk
    add risk_data varchar(1024) null after risk_level;