ALTER TABLE `xp_task_0` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_1` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_2` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_3` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_4` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_5` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_6` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_7` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_8` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_9` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_10` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_11` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_12` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_13` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_14` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_15` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_16` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_17` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_18` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_19` ADD COLUMN `task_source` tinyint(1) NULL DEFAULT 1 COMMENT '任务来源 1-运维APP 2-管理后台' AFTER `will_timeout_notice_sent`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `vehicle_inspection` tinyint(1) NULL DEFAULT 1 COMMENT '车辆日常检测是否启用 0否1是' AFTER `id`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `vehicle_inspection_frequency` int NULL DEFAULT NULL COMMENT '车辆日常监测 频次' AFTER `vehicle_inspection`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `vehicle_inspection_time` time NULL DEFAULT NULL COMMENT '车辆日常检测 任务下放时间' AFTER `vehicle_inspection_frequency`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `vehicle_inspection_level` int NULL DEFAULT 0 COMMENT '车辆日常监测 紧急程度 0=P0 1=P1 2=P2 3=P3' AFTER `vehicle_inspection_time`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `vehicle_collection` tinyint(1) NULL DEFAULT 1 COMMENT '车辆收车是否启用 0否1是' AFTER `vehicle_inspection_level`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `vehicle_collection_time` time NULL DEFAULT NULL COMMENT '车辆收车每日时间' AFTER `vehicle_collection`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `maintenance_cycle` tinyint(1) NULL DEFAULT 1 COMMENT '车辆保养周期是否启用' AFTER `vehicle_collection_time`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `maintenance_cycle_time` int NULL DEFAULT NULL COMMENT '车辆保养周期 保养周期X' AFTER `maintenance_cycle`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `maintenance_cycle_time_type` int NULL DEFAULT 1 COMMENT '车辆保养周期 保养周期X 1=天 2=月' AFTER `maintenance_cycle_time`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `maintenance_cycle_task_time` time NULL DEFAULT NULL COMMENT '车辆保养周期 任务下放时间' AFTER `maintenance_cycle_time_type`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `maintenance_cycle_level` int NULL DEFAULT NULL COMMENT '车辆保养周期 紧急程度 0=P0 1=P1 2=P2 3=P3' AFTER `maintenance_cycle_task_time`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `charging_strategy` tinyint NULL DEFAULT NULL COMMENT '充电策略是否启用 0否1是' AFTER `maintenance_cycle_level`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `charging_strategy_batteryl` decimal(10, 2) NULL DEFAULT NULL COMMENT '充电策略 电量低于XX 不可接新单并发起充电任务' AFTER `charging_strategy`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `charging_strategy_level` int NULL DEFAULT NULL COMMENT '充电策略 紧急程度 0=P0 1=P1 2=P2 3=P3' AFTER `charging_strategy_batteryl`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `vehicle_clean_time` time NULL DEFAULT NULL COMMENT '车身清洁保养任务下放时间' AFTER `charging_strategy_level`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `vehicle_clean_cycle` int NULL DEFAULT NULL COMMENT '车身清洁保养周期X' AFTER `vehicle_clean_time`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `vehicle_clean_time_type` int NULL DEFAULT NULL COMMENT '车身清洁保养周期X 1=天 2=月' AFTER `vehicle_clean_cycle`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `vehicle_clean_level` int NULL DEFAULT NULL COMMENT '车身清洁任务紧急程度0=P0 1=P1 2=P2 3=P3' AFTER `vehicle_clean_time_type`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `routine_maintenance_cycle` int NULL DEFAULT NULL COMMENT '日常整备保养周期X' AFTER `vehicle_clean_level`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `routine_maintenance_time` time NULL DEFAULT NULL COMMENT '日常整备保养任务下放时间' AFTER `routine_maintenance_cycle`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `routine_maintenance_time_type` int NULL DEFAULT NULL COMMENT '日常整备保养周期X 1=天 2=月' AFTER `routine_maintenance_time`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `routine_maintenance_level` int NULL DEFAULT NULL COMMENT '日常整备 紧急程度0=P0 1=P1 2=P2 3=P3' AFTER `routine_maintenance_time_type`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `insurance` tinyint(1) NULL DEFAULT NULL COMMENT '年检/保险策略 是否启用 0否1是' AFTER `routine_maintenance_level`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `insurance_expires` int NULL DEFAULT NULL COMMENT '年检/保险策略 保险到期X天 下发任务' AFTER `insurance`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `insurance_inspection_expires` int NULL DEFAULT NULL COMMENT '年检/保险策略 年检到期X天 下发任务' AFTER `insurance_expires`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `operation_qualification_expires` int NULL DEFAULT NULL COMMENT '网约车运营资质到期X天 下发任务' AFTER `insurance_inspection_expires`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `insurance_level` int NULL DEFAULT NULL COMMENT '年检/保险策略 紧急程度 0=P0 1=P1 2=P2 3=P3' AFTER `operation_qualification_expires`; ALTER TABLE `xp_task_rule` MODIFY COLUMN `processing_time_limit` int NULL DEFAULT NULL COMMENT '任务处理时限(分钟)' AFTER `insurance_level`;