alter table device_detail
    add client_id varchar(255) null after machine_id;

alter table device_detail
    add client_type varchar(64) null after client_id;