playlet/sql/central/central_update_20240109.sql

alter table device
    modify idfa varchar(255) null comment 'apple用户设备的唯一标识符';

alter table device
    add idfv varchar(255) null comment 'apple应用程序开发商的唯一标识符' after imei;

alter table device
    add machine_id varchar(255) null comment '机器唯一标识符' after idfv;

alter table device_detail
    modify idfa varchar(255) null comment 'apple用户设备的唯一标识符';

alter table device_detail
    add idfv varchar(255) null comment 'apple应用程序开发商的唯一标识符' after imei;

alter table device_detail
    add machine_id varchar(255) null comment '机器唯一标识符' after idfv;

alter table device_detail_update
    modify idfa varchar(255) null comment 'apple用户设备的唯一标识符';

alter table device_detail_update
    add idfv varchar(255) null comment 'apple应用程序开发商的唯一标识符' after imei;

alter table device_detail_update
    add machine_id varchar(255) null comment '机器唯一标识符' after idfv;


alter table blocked_device
    modify idfa varchar(255) null comment 'apple用户设备的唯一标识符';

alter table blocked_device
    add idfv varchar(255) null comment 'apple应用程序开发商的唯一标识符' after imei;

alter table blocked_device
    add machine_id varchar(255) null comment '机器唯一标识符' after idfv;

alter table blocked_device_update
    modify idfa varchar(255) null comment 'apple用户设备的唯一标识符';

alter table blocked_device_update
    add idfv varchar(255) null comment 'apple应用程序开发商的唯一标识符' after imei;

alter table blocked_device_update
    add machine_id varchar(255) null comment '机器唯一标识符' after idfv;