playlet/sql/central/central_update_20240805.sql

alter table user
    add register_device_id varchar(64) null after update_time;

alter table user
    add present_device_id varchar(64) null after register_device_id;

alter table user
    add last_login_time datetime null after present_device_id;


alter table device_detail
    add company varchar(64) null after user_agent;

alter table device_detail
    add advertiser_id varchar(64) null after company;

alter table device_detail
    add gid varchar(64) null after advertiser_id;

alter table device_detail
    add aid varchar(64) null after gid;

alter table device_detail
    add cid varchar(64) null after aid;

alter table device_detail
    add attributed_time datetime null after cid;