SET FOREIGN_KEY_CHECKS=0;

ALTER TABLE `xpeng_maintenance`.`xp_task_0` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_1` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_2` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_3` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_4` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_5` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_6` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_7` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_8` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_9` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_10` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_11` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_12` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_13` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_14` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_15` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_16` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_17` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_18` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_19` ADD COLUMN `expired_notice_sent` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否已发送过期通知 0=未发送 1=已发送' AFTER `end_time`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_0` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_0` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_1` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_1` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_2` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_2` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_3` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_3` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_4` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_4` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_5` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_5` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_6` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_6` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_7` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_7` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_8` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_8` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_9` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_9` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_10` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_10` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_11` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_11` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_12` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_12` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_13` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_13` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_14` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_14` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_15` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_15` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_16` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_16` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_17` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_17` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_18` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_18` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_19` MODIFY COLUMN `responsible_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '交警判责现场情况' AFTER `responsibility_judgment`;

ALTER TABLE `xpeng_maintenance`.`xp_task_handle_detail_19` MODIFY COLUMN `disposal_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处置情况描述' AFTER `responsible_image`;

ALTER TABLE `xpeng_maintenance`.`xp_vehicle` MODIFY COLUMN `electronic_id` bigint NULL DEFAULT NULL COMMENT '围栏id' AFTER `policy_information`;

SET FOREIGN_KEY_CHECKS=1;