SET FOREIGN_KEY_CHECKS=0;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point` ADD COLUMN `stop_flag` tinyint NULL DEFAULT NULL COMMENT '是否停车 0-否 1-是' AFTER `sort_order`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point` MODIFY COLUMN `point_id` bigint NULL DEFAULT NULL COMMENT '点位ID' AFTER `cruise_plan_id`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point` DROP COLUMN `is_deleted`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point` DROP COLUMN `create_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point` DROP COLUMN `update_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point` DROP COLUMN `create_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point` DROP COLUMN `update_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_0` ADD COLUMN `id` bigint NOT NULL COMMENT '自增id' FIRST;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_0` ADD COLUMN `stop_flag` tinyint NULL DEFAULT NULL COMMENT '是否停车 0-否 1-是' AFTER `sort_order`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_0` MODIFY COLUMN `point_id` bigint NULL DEFAULT NULL COMMENT '点位ID' AFTER `cruise_plan_id`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_0` ADD PRIMARY KEY (`id`) USING BTREE;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_0` DROP COLUMN `is_deleted`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_0` DROP COLUMN `create_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_0` DROP COLUMN `update_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_0` DROP COLUMN `create_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_0` DROP COLUMN `update_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_1` ADD COLUMN `id` bigint NOT NULL COMMENT '自增id' FIRST;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_1` ADD COLUMN `stop_flag` tinyint NULL DEFAULT NULL COMMENT '是否停车 0-否 1-是' AFTER `sort_order`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_1` MODIFY COLUMN `point_id` bigint NULL DEFAULT NULL COMMENT '点位ID' AFTER `cruise_plan_id`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_1` ADD PRIMARY KEY (`id`) USING BTREE;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_1` DROP COLUMN `is_deleted`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_1` DROP COLUMN `create_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_1` DROP COLUMN `update_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_1` DROP COLUMN `create_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_1` DROP COLUMN `update_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_2` ADD COLUMN `id` bigint NOT NULL COMMENT '自增id' FIRST;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_2` ADD COLUMN `stop_flag` tinyint NULL DEFAULT NULL COMMENT '是否停车 0-否 1-是' AFTER `sort_order`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_2` MODIFY COLUMN `point_id` bigint NULL DEFAULT NULL COMMENT '点位ID' AFTER `cruise_plan_id`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_2` ADD PRIMARY KEY (`id`) USING BTREE;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_2` DROP COLUMN `is_deleted`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_2` DROP COLUMN `create_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_2` DROP COLUMN `update_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_2` DROP COLUMN `create_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_2` DROP COLUMN `update_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_3` ADD COLUMN `id` bigint NOT NULL COMMENT '自增id' FIRST;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_3` ADD COLUMN `stop_flag` tinyint NULL DEFAULT NULL COMMENT '是否停车 0-否 1-是' AFTER `sort_order`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_3` MODIFY COLUMN `point_id` bigint NULL DEFAULT NULL COMMENT '点位ID' AFTER `cruise_plan_id`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_3` ADD PRIMARY KEY (`id`) USING BTREE;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_3` DROP COLUMN `is_deleted`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_3` DROP COLUMN `create_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_3` DROP COLUMN `update_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_3` DROP COLUMN `create_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_3` DROP COLUMN `update_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_4` ADD COLUMN `id` bigint NOT NULL COMMENT '自增id' FIRST;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_4` ADD COLUMN `stop_flag` tinyint NULL DEFAULT NULL COMMENT '是否停车 0-否 1-是' AFTER `sort_order`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_4` MODIFY COLUMN `point_id` bigint NULL DEFAULT NULL COMMENT '点位ID' AFTER `cruise_plan_id`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_4` ADD PRIMARY KEY (`id`) USING BTREE;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_4` DROP COLUMN `is_deleted`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_4` DROP COLUMN `create_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_4` DROP COLUMN `update_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_4` DROP COLUMN `create_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_4` DROP COLUMN `update_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_5` ADD COLUMN `id` bigint NOT NULL COMMENT '自增id' FIRST;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_5` ADD COLUMN `stop_flag` tinyint NULL DEFAULT NULL COMMENT '是否停车 0-否 1-是' AFTER `sort_order`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_5` MODIFY COLUMN `point_id` bigint NULL DEFAULT NULL COMMENT '点位ID' AFTER `cruise_plan_id`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_5` ADD PRIMARY KEY (`id`) USING BTREE;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_5` DROP COLUMN `is_deleted`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_5` DROP COLUMN `create_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_5` DROP COLUMN `update_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_5` DROP COLUMN `create_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_5` DROP COLUMN `update_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_6` ADD COLUMN `id` bigint NOT NULL COMMENT '自增id' FIRST;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_6` ADD COLUMN `stop_flag` tinyint NULL DEFAULT NULL COMMENT '是否停车 0-否 1-是' AFTER `sort_order`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_6` MODIFY COLUMN `point_id` bigint NULL DEFAULT NULL COMMENT '点位ID' AFTER `cruise_plan_id`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_6` ADD PRIMARY KEY (`id`) USING BTREE;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_6` DROP COLUMN `is_deleted`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_6` DROP COLUMN `create_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_6` DROP COLUMN `update_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_6` DROP COLUMN `create_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_6` DROP COLUMN `update_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_7` ADD COLUMN `id` bigint NOT NULL COMMENT '自增id' FIRST;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_7` ADD COLUMN `stop_flag` tinyint NULL DEFAULT NULL COMMENT '是否停车 0-否 1-是' AFTER `sort_order`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_7` MODIFY COLUMN `point_id` bigint NULL DEFAULT NULL COMMENT '点位ID' AFTER `cruise_plan_id`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_7` ADD PRIMARY KEY (`id`) USING BTREE;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_7` DROP COLUMN `is_deleted`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_7` DROP COLUMN `create_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_7` DROP COLUMN `update_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_7` DROP COLUMN `create_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_7` DROP COLUMN `update_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_8` ADD COLUMN `id` bigint NOT NULL COMMENT '自增id' FIRST;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_8` ADD COLUMN `stop_flag` tinyint NULL DEFAULT NULL COMMENT '是否停车 0-否 1-是' AFTER `sort_order`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_8` MODIFY COLUMN `point_id` bigint NULL DEFAULT NULL COMMENT '点位ID' AFTER `cruise_plan_id`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_8` ADD PRIMARY KEY (`id`) USING BTREE;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_8` DROP COLUMN `is_deleted`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_8` DROP COLUMN `create_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_8` DROP COLUMN `update_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_8` DROP COLUMN `create_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_8` DROP COLUMN `update_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_9` ADD COLUMN `id` bigint NOT NULL COMMENT '自增id' FIRST;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_9` ADD COLUMN `stop_flag` tinyint NULL DEFAULT NULL COMMENT '是否停车 0-否 1-是' AFTER `sort_order`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_9` MODIFY COLUMN `point_id` bigint NULL DEFAULT NULL COMMENT '点位ID' AFTER `cruise_plan_id`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_9` ADD PRIMARY KEY (`id`) USING BTREE;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_9` DROP COLUMN `is_deleted`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_9` DROP COLUMN `create_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_9` DROP COLUMN `update_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_9` DROP COLUMN `create_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_point_9` DROP COLUMN `update_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_vehicle` DROP PRIMARY KEY;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_vehicle` DROP COLUMN `id`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_vehicle` DROP COLUMN `is_deleted`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_vehicle` DROP COLUMN `create_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_vehicle` DROP COLUMN `update_time`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_vehicle` DROP COLUMN `create_by`;

ALTER TABLE `xpeng_operation`.`xp_cruise_plan_vehicle` DROP COLUMN `update_by`;

ALTER TABLE `xpeng_operation`.`xp_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_operation`.`xp_point` MODIFY COLUMN `parking_point` int NULL DEFAULT 0 COMMENT '0否  1是 收车点位' AFTER `charge_point`;

ALTER TABLE `xpeng_operation`.`xp_region` ADD COLUMN `china` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `lon`;

ALTER TABLE `xpeng_operation`.`xp_trading_strategy_city` MODIFY COLUMN `id` bigint NOT NULL FIRST;

ALTER TABLE `xpeng_operation`.`xp_trading_strategy_city` MODIFY COLUMN `id` bigint NOT NULL AUTO_INCREMENT;

SET FOREIGN_KEY_CHECKS=1;