sql/upgrade_260806/inoutservice.sql

SET FOREIGN_KEY_CHECKS=0;

ALTER TABLE `inoutservice`.`io_park_in_1` DROP INDEX `car_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_1` DROP INDEX `pro_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_1` MODIFY COLUMN `car_in_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '本地上传入场记录id' AFTER `id`;

ALTER TABLE `inoutservice`.`io_park_in_1` ADD UNIQUE INDEX `car_in_id`(`car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_1` ADD INDEX `pro_in_id`(`project_no` ASC, `car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_2` DROP INDEX `car_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_2` DROP INDEX `pro_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_2` ADD UNIQUE INDEX `car_in_id`(`car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_2` ADD INDEX `pro_in_id`(`project_no` ASC, `car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_3` DROP INDEX `car_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_3` DROP INDEX `pro_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_3` ADD UNIQUE INDEX `car_in_id`(`car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_3` ADD INDEX `pro_in_id`(`project_no` ASC, `car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_4` DROP INDEX `car_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_4` DROP INDEX `pro_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_4` ADD UNIQUE INDEX `car_in_id`(`car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_4` ADD INDEX `pro_in_id`(`project_no` ASC, `car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_5` DROP INDEX `car_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_5` DROP INDEX `pro_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_5` ADD UNIQUE INDEX `car_in_id`(`car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_5` ADD INDEX `pro_in_id`(`project_no` ASC, `car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_6` DROP INDEX `car_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_6` DROP INDEX `pro_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_6` ADD UNIQUE INDEX `car_in_id`(`car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_6` ADD INDEX `pro_in_id`(`project_no` ASC, `car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_7` DROP INDEX `car_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_7` DROP INDEX `pro_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_7` ADD UNIQUE INDEX `car_in_id`(`car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_7` ADD INDEX `pro_in_id`(`project_no` ASC, `car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_8` DROP INDEX `car_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_8` DROP INDEX `pro_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_8` ADD UNIQUE INDEX `car_in_id`(`car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_8` ADD INDEX `pro_in_id`(`project_no` ASC, `car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_9` DROP INDEX `car_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_9` DROP INDEX `pro_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_9` ADD UNIQUE INDEX `car_in_id`(`car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_9` ADD INDEX `pro_in_id`(`project_no` ASC, `car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_10` DROP INDEX `car_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_10` DROP INDEX `pro_in_id`;

ALTER TABLE `inoutservice`.`io_park_in_10` ADD UNIQUE INDEX `car_in_id`(`car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_in_10` ADD INDEX `pro_in_id`(`project_no` ASC, `car_in_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_out_1` DROP INDEX `car_out_id`;

ALTER TABLE `inoutservice`.`io_park_out_1` DROP INDEX `pro_out_id`;

ALTER TABLE `inoutservice`.`io_park_out_1` ADD UNIQUE INDEX `car_out_id`(`car_out_id` ASC) USING BTREE;

ALTER TABLE `inoutservice`.`io_park_out_1` ADD INDEX `pro_out_id`(`project_no` ASC, `car_out_id` ASC) USING BTREE;

SET FOREIGN_KEY_CHECKS=1;