From 12651dffcf732bd7113a434b34e8685ae17036f4 Mon Sep 17 00:00:00 2001 From: puzhibing <393733352@qq.com> Date: 星期六, 07 三月 2026 21:02:03 +0800 Subject: [PATCH] 同步数据库增量脚本 --- sql/增量sql/xprt_maintenance.sql | 522 +++---------------------------- sql/增量sql/xprt_account.sql | 176 ---------- sql/增量sql/xprt_order.sql | 208 +++--------- 3 files changed, 113 insertions(+), 793 deletions(-) diff --git "a/sql/\345\242\236\351\207\217sql/xprt_account.sql" "b/sql/\345\242\236\351\207\217sql/xprt_account.sql" index fb47be9..007a4c7 100644 --- "a/sql/\345\242\236\351\207\217sql/xprt_account.sql" +++ "b/sql/\345\242\236\351\207\217sql/xprt_account.sql" @@ -1,175 +1 @@ -SET FOREIGN_KEY_CHECKS=0; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_0` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_1` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_2` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_3` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_4` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_5` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_6` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_7` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_8` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_9` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_10` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_11` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_12` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_13` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_14` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_15` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_16` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_17` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_18` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_app_user_coupon_19` MODIFY COLUMN `activity_id` bigint NULL DEFAULT NULL COMMENT '活动id' AFTER `coupon_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user` ADD COLUMN `sex` tinyint(1) NULL DEFAULT 1 COMMENT '性别 1-男 2-女' AFTER `avatar`; - -ALTER TABLE `xpeng_account`.`xp_operations_user` ADD COLUMN `device_type` tinyint(1) NULL DEFAULT NULL COMMENT '登录设备类型 1-安卓 2-iOS' AFTER `training_graduation_certificate`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `notification_content`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_0` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_0` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_0` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_1` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_1` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_1` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_2` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_2` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_2` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_3` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_3` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_3` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_4` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_4` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_4` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_5` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_5` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_5` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_6` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_6` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_6` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_7` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_7` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_7` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_8` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_8` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_8` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_9` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_9` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_9` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_10` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_10` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_10` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_11` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_11` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_11` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_12` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_12` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_12` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_13` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_13` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_13` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_14` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_14` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_14` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_15` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_15` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_15` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_16` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_16` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_16` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_17` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_17` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_17` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_18` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_18` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_18` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_19` ADD COLUMN `read_status` tinyint(1) NULL DEFAULT 0 COMMENT '已读状态 0-未读 1-已读' AFTER `data_id`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_19` ADD COLUMN `notification_ext` json NULL COMMENT '消息推送ext' AFTER `update_by`; - -ALTER TABLE `xpeng_account`.`xp_operations_user_notification_19` MODIFY COLUMN `notification_type` int NOT NULL DEFAULT 1 COMMENT '通知类型 1=新增事故，2=事故即将超时提示，3=事故超时提示，4=排班信息变动，5=事故状态变更，6=新增任务，7=任务过期提示，8=版本更新提示，9=变更协议政策内容，10=变更协议内容并需用户授权，11=打卡成功通知' AFTER `id`; - -SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file +ALTER TABLE `xp_operations_user` MODIFY COLUMN `remarks` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注' AFTER `phone_number`; \ No newline at end of file diff --git "a/sql/\345\242\236\351\207\217sql/xprt_maintenance.sql" "b/sql/\345\242\236\351\207\217sql/xprt_maintenance.sql" index 377e906..0afc893 100644 --- "a/sql/\345\242\236\351\207\217sql/xprt_maintenance.sql" +++ "b/sql/\345\242\236\351\207\217sql/xprt_maintenance.sql" @@ -1,521 +1,121 @@ -SET FOREIGN_KEY_CHECKS=0; +ALTER TABLE `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_clock_in` MODIFY COLUMN `clock_out_result` int NULL DEFAULT 1 COMMENT '下班打卡结果 1=正常 2=早退 3=缺卡' AFTER `update_by`; +ALTER TABLE `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_clock_in_0` MODIFY COLUMN `clock_in_lat` double(20, 10) NOT NULL COMMENT '上班打卡纬度' AFTER `clock_in_lon`; +ALTER TABLE `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_clock_in_0` MODIFY COLUMN `clock_out_result` int NULL DEFAULT 1 COMMENT '下班打卡结果 1=正常 2=迟到 3=缺卡' AFTER `update_by`; +ALTER TABLE `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_clock_in_0` MODIFY COLUMN `clock_out_lon` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡经度' AFTER `clock_out_result`; +ALTER TABLE `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_clock_in_0` MODIFY COLUMN `clock_out_lat` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡纬度' AFTER `clock_out_lon`; +ALTER TABLE `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_clock_in_1` MODIFY COLUMN `clock_in_lat` double(20, 10) NOT NULL COMMENT '上班打卡纬度' AFTER `clock_in_lon`; +ALTER TABLE `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_clock_in_1` MODIFY COLUMN `clock_out_result` int NULL DEFAULT 1 COMMENT '下班打卡结果 1=正常 2=迟到 3=缺卡' AFTER `update_by`; +ALTER TABLE `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_clock_in_1` MODIFY COLUMN `clock_out_lon` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡经度' AFTER `clock_out_result`; +ALTER TABLE `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_clock_in_1` MODIFY COLUMN `clock_out_lat` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡纬度' AFTER `clock_out_lon`; +ALTER TABLE `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_clock_in_2` MODIFY COLUMN `clock_out_result` int NULL DEFAULT 1 COMMENT '下班打卡结果 1=正常 2=迟到 3=缺卡' AFTER `update_by`; +ALTER TABLE `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_clock_in_2` MODIFY COLUMN `clock_out_lon` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡经度' AFTER `clock_out_result`; +ALTER TABLE `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_clock_in_2` MODIFY COLUMN `clock_out_lat` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡纬度' AFTER `clock_out_lon`; +ALTER TABLE `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_clock_in_3` MODIFY COLUMN `clock_in_lat` double(20, 10) NOT NULL COMMENT '上班打卡纬度' AFTER `clock_in_lon`; +ALTER TABLE `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_clock_in_3` MODIFY COLUMN `clock_out_result` int NULL DEFAULT 1 COMMENT '下班打卡结果 1=正常 2=迟到 3=缺卡' AFTER `update_by`; +ALTER TABLE `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_clock_in_3` MODIFY COLUMN `clock_out_lon` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡经度' AFTER `clock_out_result`; +ALTER TABLE `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_clock_in_3` MODIFY COLUMN `clock_out_lat` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡纬度' AFTER `clock_out_lon`; +ALTER TABLE `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_clock_in_4` MODIFY COLUMN `clock_in_lat` double(20, 10) NOT NULL COMMENT '上班打卡纬度' AFTER `clock_in_lon`; +ALTER TABLE `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_clock_in_4` MODIFY COLUMN `clock_out_result` int NULL DEFAULT 1 COMMENT '下班打卡结果 1=正常 2=迟到 3=缺卡' AFTER `update_by`; +ALTER TABLE `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_clock_in_4` MODIFY COLUMN `clock_out_lon` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡经度' AFTER `clock_out_result`; +ALTER TABLE `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_clock_in_4` MODIFY COLUMN `clock_out_lat` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡纬度' AFTER `clock_out_lon`; +ALTER TABLE `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_clock_in_5` MODIFY COLUMN `clock_in_lat` double(20, 10) NOT NULL COMMENT '上班打卡纬度' AFTER `clock_in_lon`; +ALTER TABLE `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_clock_in_5` MODIFY COLUMN `clock_out_result` int NULL DEFAULT 1 COMMENT '下班打卡结果 1=正常 2=迟到 3=缺卡' AFTER `update_by`; +ALTER TABLE `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_clock_in_5` MODIFY COLUMN `clock_out_lon` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡经度' AFTER `clock_out_result`; +ALTER TABLE `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_clock_in_5` MODIFY COLUMN `clock_out_lat` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡纬度' AFTER `clock_out_lon`; +ALTER TABLE `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_clock_in_6` MODIFY COLUMN `clock_in_lat` double(20, 10) NOT NULL COMMENT '上班打卡纬度' AFTER `clock_in_lon`; +ALTER TABLE `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_clock_in_6` MODIFY COLUMN `clock_out_result` int NULL DEFAULT 1 COMMENT '下班打卡结果 1=正常 2=迟到 3=缺卡' AFTER `update_by`; +ALTER TABLE `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_clock_in_6` MODIFY COLUMN `clock_out_lon` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡经度' AFTER `clock_out_result`; +ALTER TABLE `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_clock_in_6` MODIFY COLUMN `clock_out_lat` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡纬度' AFTER `clock_out_lon`; +ALTER TABLE `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_clock_in_7` MODIFY COLUMN `clock_in_lat` double(20, 10) NOT NULL COMMENT '上班打卡纬度' AFTER `clock_in_lon`; +ALTER TABLE `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_clock_in_7` MODIFY COLUMN `clock_out_result` int NULL DEFAULT 1 COMMENT '下班打卡结果 1=正常 2=迟到 3=缺卡' AFTER `update_by`; +ALTER TABLE `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_clock_in_7` MODIFY COLUMN `clock_out_lon` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡经度' AFTER `clock_out_result`; +ALTER TABLE `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_clock_in_7` MODIFY COLUMN `clock_out_lat` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡纬度' AFTER `clock_out_lon`; +ALTER TABLE `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_clock_in_8` MODIFY COLUMN `clock_in_lat` double(20, 10) NOT NULL COMMENT '上班打卡纬度' AFTER `clock_in_lon`; +ALTER TABLE `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_clock_in_8` MODIFY COLUMN `clock_out_result` int NULL DEFAULT 1 COMMENT '下班打卡结果 1=正常 2=迟到 3=缺卡' AFTER `update_by`; +ALTER TABLE `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_clock_in_8` MODIFY COLUMN `clock_out_lon` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡经度' AFTER `clock_out_result`; +ALTER TABLE `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_clock_in_8` MODIFY COLUMN `clock_out_lat` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡纬度' AFTER `clock_out_lon`; +ALTER TABLE `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_clock_in_9` MODIFY COLUMN `clock_in_lat` double(20, 10) NOT NULL COMMENT '上班打卡纬度' AFTER `clock_in_lon`; +ALTER TABLE `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_clock_in_9` MODIFY COLUMN `clock_out_result` int NULL DEFAULT 1 COMMENT '下班打卡结果 1=正常 2=迟到 3=缺卡' AFTER `update_by`; +ALTER TABLE `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_clock_in_9` MODIFY COLUMN `clock_out_lon` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡经度' AFTER `clock_out_result`; +ALTER TABLE `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_clock_in_9` MODIFY COLUMN `clock_out_lat` double(20, 10) NULL DEFAULT NULL COMMENT '下班打卡纬度' AFTER `clock_out_lon`; +ALTER TABLE `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` ADD COLUMN `belong_user_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '任务归属人员ids' AFTER `end_time`; +ALTER TABLE `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` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; +ALTER TABLE `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` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务归属人ids，当任务通过后台分配指定角色或有处理人执行达到现场之后，该字段存储为单个指定处理人id' AFTER `vehicle_lat`; +ALTER TABLE `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_0` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; +ALTER TABLE `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_0` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; +ALTER TABLE `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_0` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; +ALTER TABLE `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_0` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; +ALTER TABLE `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_0` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; +ALTER TABLE `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_0` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; +ALTER TABLE `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_1` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; +ALTER TABLE `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_1` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; +ALTER TABLE `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_1` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; +ALTER TABLE `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_1` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; +ALTER TABLE `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_1` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; +ALTER TABLE `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_1` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; +ALTER TABLE `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_2` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; +ALTER TABLE `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_2` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; +ALTER TABLE `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_2` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; +ALTER TABLE `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_2` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; +ALTER TABLE `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_task_2` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_2` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_3` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_3` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_3` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_3` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_3` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_3` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_4` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_4` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_4` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_4` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_4` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_4` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_5` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_5` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_5` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_5` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_5` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_5` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_6` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_6` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_6` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_6` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_6` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_6` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_7` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_7` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_7` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_7` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_7` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_7` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_8` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_8` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_8` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_8` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_8` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_8` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_9` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_9` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_9` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_9` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_9` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_9` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_10` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_10` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_10` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_10` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_10` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_10` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_11` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_11` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_11` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_11` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_11` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_11` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_12` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_12` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_12` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_12` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_12` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_12` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_13` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_13` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_13` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_13` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_13` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_13` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_14` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_14` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_14` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_14` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_14` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_14` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_15` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_15` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_15` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_15` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_15` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_15` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_16` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_16` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_16` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_16` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_16` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_16` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_17` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_17` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_17` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_17` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_17` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_17` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_18` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_18` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_18` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_18` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_18` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_18` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_19` MODIFY COLUMN `task_image` json NULL COMMENT '任务图片' AFTER `task_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_19` MODIFY COLUMN `vehicle_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '未获取到车辆当前位置' COMMENT '车辆位置' AFTER `task_image`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_19` MODIFY COLUMN `vehicle_lon` decimal(10, 6) NOT NULL DEFAULT 104.060000 COMMENT '车辆经度' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_19` MODIFY COLUMN `vehicle_lat` decimal(10, 6) NOT NULL DEFAULT 30.590000 COMMENT '车辆纬度' AFTER `vehicle_lon`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_19` MODIFY COLUMN `handle_user_id` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '处理人id' AFTER `vehicle_lat`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_19` MODIFY COLUMN `end_time` datetime NULL DEFAULT NULL COMMENT '任务处理时限' AFTER `status`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_rule` ADD COLUMN `vehicle_clean_cycle` int NOT NULL COMMENT '车身清洁保养周期X' AFTER `vehicle_clean_time`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_rule` ADD COLUMN `routine_maintenance_cycle` int NOT NULL COMMENT '日常整备保养周期X' AFTER `vehicle_clean_level`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_rule` MODIFY COLUMN `vehicle_inspection_time` time NOT NULL COMMENT '车辆日常检测 任务下放时间' AFTER `vehicle_inspection_frequency`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_rule` MODIFY COLUMN `vehicle_collection_time` time NOT NULL COMMENT '车辆收车每日时间' AFTER `vehicle_collection`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_rule` MODIFY COLUMN `maintenance_cycle_task_time` time NOT NULL COMMENT '车辆保养周期 任务下放时间' AFTER `maintenance_cycle_time_type`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_rule` MODIFY COLUMN `vehicle_clean_time` time NOT NULL COMMENT '车身清洁保养任务下放时间' AFTER `charging_strategy_level`; - -ALTER TABLE `xpeng_maintenance`.`xp_task_rule` MODIFY COLUMN `routine_maintenance_time` time NOT NULL COMMENT '日常整备保养任务下放时间' AFTER `routine_maintenance_cycle`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle` MODIFY COLUMN `vehicle_pictures` json NULL COMMENT '车辆图片' AFTER `vehicle_color`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_clean_0` MODIFY COLUMN `id` bigint NOT NULL FIRST; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_clean_1` MODIFY COLUMN `id` bigint NOT NULL FIRST; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_clean_2` MODIFY COLUMN `id` bigint NOT NULL FIRST; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_clean_3` MODIFY COLUMN `id` bigint NOT NULL FIRST; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_clean_4` MODIFY COLUMN `id` bigint NOT NULL FIRST; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_clean_5` MODIFY COLUMN `id` bigint NOT NULL FIRST; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_clean_6` MODIFY COLUMN `id` bigint NOT NULL FIRST; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_clean_7` MODIFY COLUMN `id` bigint NOT NULL FIRST; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_clean_8` MODIFY COLUMN `id` bigint NOT NULL FIRST; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_clean_9` MODIFY COLUMN `id` bigint NOT NULL FIRST; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection` MODIFY COLUMN `sensor_cleaning_picture` json NULL COMMENT '传感器清洁检测图' AFTER `sensor_cleaning`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection` MODIFY COLUMN `interactive_screen_picture` json NULL COMMENT '交互屏检测图' AFTER `interactive_screen`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection` MODIFY COLUMN `help_button_picture` json NULL COMMENT '求助按钮图' AFTER `help_button`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection` MODIFY COLUMN `payment_function_picture` json NULL COMMENT '支付功能图' AFTER `payment_function`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection` MODIFY COLUMN `system_check_picture` json NULL COMMENT '系统检查图' AFTER `system_check`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_0` MODIFY COLUMN `sensor_cleaning_picture` json NULL COMMENT '传感器清洁检测图' AFTER `sensor_cleaning`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_0` MODIFY COLUMN `interactive_screen_picture` json NULL COMMENT '交互屏检测图' AFTER `interactive_screen`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_0` MODIFY COLUMN `help_button_picture` json NULL COMMENT '求助按钮图' AFTER `help_button`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_0` MODIFY COLUMN `payment_function_picture` json NULL COMMENT '支付功能图' AFTER `payment_function`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_0` MODIFY COLUMN `system_check_picture` json NULL COMMENT '系统检查图' AFTER `system_check`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_1` MODIFY COLUMN `sensor_cleaning_picture` json NULL COMMENT '传感器清洁检测图' AFTER `sensor_cleaning`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_1` MODIFY COLUMN `interactive_screen_picture` json NULL COMMENT '交互屏检测图' AFTER `interactive_screen`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_1` MODIFY COLUMN `help_button_picture` json NULL COMMENT '求助按钮图' AFTER `help_button`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_1` MODIFY COLUMN `payment_function_picture` json NULL COMMENT '支付功能图' AFTER `payment_function`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_1` MODIFY COLUMN `system_check_picture` json NULL COMMENT '系统检查图' AFTER `system_check`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_2` MODIFY COLUMN `sensor_cleaning_picture` json NULL COMMENT '传感器清洁检测图' AFTER `sensor_cleaning`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_2` MODIFY COLUMN `interactive_screen_picture` json NULL COMMENT '交互屏检测图' AFTER `interactive_screen`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_2` MODIFY COLUMN `help_button_picture` json NULL COMMENT '求助按钮图' AFTER `help_button`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_2` MODIFY COLUMN `payment_function_picture` json NULL COMMENT '支付功能图' AFTER `payment_function`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_2` MODIFY COLUMN `system_check_picture` json NULL COMMENT '系统检查图' AFTER `system_check`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_3` MODIFY COLUMN `sensor_cleaning_picture` json NULL COMMENT '传感器清洁检测图' AFTER `sensor_cleaning`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_3` MODIFY COLUMN `interactive_screen_picture` json NULL COMMENT '交互屏检测图' AFTER `interactive_screen`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_3` MODIFY COLUMN `help_button_picture` json NULL COMMENT '求助按钮图' AFTER `help_button`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_3` MODIFY COLUMN `payment_function_picture` json NULL COMMENT '支付功能图' AFTER `payment_function`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_3` MODIFY COLUMN `system_check_picture` json NULL COMMENT '系统检查图' AFTER `system_check`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_4` MODIFY COLUMN `sensor_cleaning_picture` json NULL COMMENT '传感器清洁检测图' AFTER `sensor_cleaning`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_4` MODIFY COLUMN `interactive_screen_picture` json NULL COMMENT '交互屏检测图' AFTER `interactive_screen`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_4` MODIFY COLUMN `help_button_picture` json NULL COMMENT '求助按钮图' AFTER `help_button`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_4` MODIFY COLUMN `payment_function_picture` json NULL COMMENT '支付功能图' AFTER `payment_function`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_4` MODIFY COLUMN `system_check_picture` json NULL COMMENT '系统检查图' AFTER `system_check`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_5` MODIFY COLUMN `sensor_cleaning_picture` json NULL COMMENT '传感器清洁检测图' AFTER `sensor_cleaning`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_5` MODIFY COLUMN `interactive_screen_picture` json NULL COMMENT '交互屏检测图' AFTER `interactive_screen`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_5` MODIFY COLUMN `help_button_picture` json NULL COMMENT '求助按钮图' AFTER `help_button`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_5` MODIFY COLUMN `payment_function_picture` json NULL COMMENT '支付功能图' AFTER `payment_function`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_5` MODIFY COLUMN `system_check_picture` json NULL COMMENT '系统检查图' AFTER `system_check`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_6` MODIFY COLUMN `sensor_cleaning_picture` json NULL COMMENT '传感器清洁检测图' AFTER `sensor_cleaning`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_6` MODIFY COLUMN `interactive_screen_picture` json NULL COMMENT '交互屏检测图' AFTER `interactive_screen`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_6` MODIFY COLUMN `help_button_picture` json NULL COMMENT '求助按钮图' AFTER `help_button`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_6` MODIFY COLUMN `payment_function_picture` json NULL COMMENT '支付功能图' AFTER `payment_function`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_6` MODIFY COLUMN `system_check_picture` json NULL COMMENT '系统检查图' AFTER `system_check`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_7` MODIFY COLUMN `sensor_cleaning_picture` json NULL COMMENT '传感器清洁检测图' AFTER `sensor_cleaning`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_7` MODIFY COLUMN `interactive_screen_picture` json NULL COMMENT '交互屏检测图' AFTER `interactive_screen`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_7` MODIFY COLUMN `help_button_picture` json NULL COMMENT '求助按钮图' AFTER `help_button`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_7` MODIFY COLUMN `payment_function_picture` json NULL COMMENT '支付功能图' AFTER `payment_function`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_7` MODIFY COLUMN `system_check_picture` json NULL COMMENT '系统检查图' AFTER `system_check`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_8` MODIFY COLUMN `sensor_cleaning_picture` json NULL COMMENT '传感器清洁检测图' AFTER `sensor_cleaning`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_8` MODIFY COLUMN `interactive_screen_picture` json NULL COMMENT '交互屏检测图' AFTER `interactive_screen`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_8` MODIFY COLUMN `help_button_picture` json NULL COMMENT '求助按钮图' AFTER `help_button`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_8` MODIFY COLUMN `payment_function_picture` json NULL COMMENT '支付功能图' AFTER `payment_function`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_8` MODIFY COLUMN `system_check_picture` json NULL COMMENT '系统检查图' AFTER `system_check`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_9` MODIFY COLUMN `sensor_cleaning_picture` json NULL COMMENT '传感器清洁检测图' AFTER `sensor_cleaning`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_9` MODIFY COLUMN `interactive_screen_picture` json NULL COMMENT '交互屏检测图' AFTER `interactive_screen`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_9` MODIFY COLUMN `help_button_picture` json NULL COMMENT '求助按钮图' AFTER `help_button`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_9` MODIFY COLUMN `payment_function_picture` json NULL COMMENT '支付功能图' AFTER `payment_function`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_detection_9` MODIFY COLUMN `system_check_picture` json NULL COMMENT '系统检查图' AFTER `system_check`; - -ALTER TABLE `xpeng_maintenance`.`xp_vehicle_repair_3` MODIFY COLUMN `repair_money_detail` json NULL COMMENT '维修费用明细' AFTER `repair_money`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order` MODIFY COLUMN `problem_image` json NULL COMMENT '图片' AFTER `problem_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order` MODIFY COLUMN `feedback_user_phone` int NOT NULL COMMENT '反馈用户手机号' AFTER `problem_image`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_0` ADD COLUMN `create_by_id` bigint NOT NULL COMMENT '创建人id' AFTER `handle_user_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_0` MODIFY COLUMN `problem_image` json NULL COMMENT '图片' AFTER `problem_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_1` ADD COLUMN `create_by_id` bigint NOT NULL COMMENT '创建人id' AFTER `handle_user_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_1` MODIFY COLUMN `problem_image` json NULL COMMENT '图片' AFTER `problem_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_2` ADD COLUMN `create_by_id` bigint NOT NULL COMMENT '创建人id' AFTER `handle_user_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_2` MODIFY COLUMN `problem_image` json NULL COMMENT '图片' AFTER `problem_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_3` ADD COLUMN `create_by_id` bigint NOT NULL COMMENT '创建人id' AFTER `handle_user_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_3` MODIFY COLUMN `problem_image` json NULL COMMENT '图片' AFTER `problem_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_4` ADD COLUMN `create_by_id` bigint NOT NULL COMMENT '创建人id' AFTER `handle_user_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_4` MODIFY COLUMN `problem_image` json NULL COMMENT '图片' AFTER `problem_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_5` ADD COLUMN `create_by_id` bigint NOT NULL COMMENT '创建人id' AFTER `handle_user_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_5` MODIFY COLUMN `problem_image` json NULL COMMENT '图片' AFTER `problem_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_6` ADD COLUMN `create_by_id` bigint NOT NULL COMMENT '创建人id' AFTER `handle_user_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_6` MODIFY COLUMN `problem_image` json NULL COMMENT '图片' AFTER `problem_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_7` ADD COLUMN `create_by_id` bigint NOT NULL COMMENT '创建人id' AFTER `handle_user_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_7` MODIFY COLUMN `problem_image` json NULL COMMENT '图片' AFTER `problem_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_8` ADD COLUMN `create_by_id` bigint NOT NULL COMMENT '创建人id' AFTER `handle_user_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_8` MODIFY COLUMN `problem_image` json NULL COMMENT '图片' AFTER `problem_description`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_9` ADD COLUMN `create_by_id` bigint NOT NULL COMMENT '创建人id' AFTER `handle_user_id`; - -ALTER TABLE `xpeng_maintenance`.`xp_work_order_9` MODIFY COLUMN `problem_image` json NULL COMMENT '图片' AFTER `problem_description`; - -SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file +ALTER TABLE `xp_vehicle` MODIFY COLUMN `electronic_id` bigint NULL DEFAULT NULL COMMENT '围栏id' AFTER `policy_information`; diff --git "a/sql/\345\242\236\351\207\217sql/xprt_order.sql" "b/sql/\345\242\236\351\207\217sql/xprt_order.sql" index 9968194..c4cd944 100644 --- "a/sql/\345\242\236\351\207\217sql/xprt_order.sql" +++ "b/sql/\345\242\236\351\207\217sql/xprt_order.sql" @@ -1,207 +1,101 @@ -SET FOREIGN_KEY_CHECKS=0; +ALTER TABLE `xp_cruise_order` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_0` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_1` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_0` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_2` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_0` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_3` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_1` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_4` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_1` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_5` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_2` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_6` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_2` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_7` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_3` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_8` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_3` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_9` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_4` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_10` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_4` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_11` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_5` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_12` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_5` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_13` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_6` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_14` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_6` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_15` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_7` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_16` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_7` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_17` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_8` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_18` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_8` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_19` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_9` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_20` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_9` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_21` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_10` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_22` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_10` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_23` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_11` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_24` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_11` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_25` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_12` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_26` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_12` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_27` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_13` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_28` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_13` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_29` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_14` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_30` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_14` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_31` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_15` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_32` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_15` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_33` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_16` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_34` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_16` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_35` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_17` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_36` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_17` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_37` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_18` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_38` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_18` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_39` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_19` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_40` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_19` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_41` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_20` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_42` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_20` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_43` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_21` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_44` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_21` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_45` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_22` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_46` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_22` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; +ALTER TABLE `xp_cruise_order_47` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_23` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; +ALTER TABLE `xp_cruise_order_48` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; -ALTER TABLE `xpeng_order`.`xp_cruise_order_23` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_24` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_24` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_25` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_25` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_26` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_26` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_27` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_27` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_28` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_28` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_29` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_29` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_30` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_30` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_31` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_31` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_32` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_32` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_33` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_33` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_34` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_34` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_35` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_35` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_36` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_36` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_37` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_37` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_38` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_38` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_39` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_39` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_40` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_40` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_41` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_41` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_42` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_42` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_43` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_43` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_44` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_44` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_45` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_45` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_46` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_46` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_47` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_47` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_48` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_48` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_49` ADD COLUMN `fleet_id` bigint NULL DEFAULT NULL COMMENT '车队ID' AFTER `vehicle_id`; - -ALTER TABLE `xpeng_order`.`xp_cruise_order_49` ADD COLUMN `order_reverse` int NULL DEFAULT NULL COMMENT '1正方 2反方' AFTER `update_by`; - -SET FOREIGN_KEY_CHECKS=1; \ No newline at end of file +ALTER TABLE `xp_cruise_order_49` MODIFY COLUMN `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL FIRST; \ No newline at end of file -- Gitblit v1.7.1