sql/upgrade_260806/cardservice.sql

SET FOREIGN_KEY_CHECKS=0;

ALTER TABLE `cardservice`.`card_black_sheet` ADD INDEX `IX_projectNo_parkId`(`project_no` ASC, `park_id` ASC) USING BTREE;

ALTER TABLE `cardservice`.`card_long_lease_apply` ADD INDEX `IX_projectNo_parkId`(`project_no` ASC, `park_id` ASC) USING BTREE;

ALTER TABLE `cardservice`.`card_long_lease_apply_approve_record` ADD INDEX `IX_projectNo_parkId`(`project_no` ASC, `park_id` ASC) USING BTREE;

ALTER TABLE `cardservice`.`card_long_lease_apply_approve_record` ADD INDEX `IX_projectNo_applyId`(`project_no` ASC, `apply_id` ASC) USING BTREE;

ALTER TABLE `cardservice`.`card_long_lease_apply_car` ADD INDEX `IX_applyId`(`apply_id` ASC) USING BTREE;

ALTER TABLE `cardservice`.`card_long_lease_apply_file` ADD INDEX `IX_applyId`(`apply_id` ASC) USING BTREE;

ALTER TABLE `cardservice`.`card_long_lease_info` ADD INDEX `IX_Customer_no`(`customer_no` ASC) USING BTREE;

ALTER TABLE `cardservice`.`card_long_lease_member_relation` ADD INDEX `IX_memberId`(`member_id` ASC) USING BTREE;

ALTER TABLE `cardservice`.`card_long_lease_pay_order_record` ADD INDEX `IX_paymentOrderId`(`payment_order_id` ASC) USING BTREE;

ALTER TABLE `cardservice`.`card_long_lease_plate_relation` ADD INDEX `IX_projectNo_parkId`(`project_no` ASC, `park_id` ASC) USING BTREE;

ALTER TABLE `cardservice`.`card_type_enterprise_temp_standard_detail` MODIFY COLUMN `model_value` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '模版配置value' AFTER `model_key`;

ALTER TABLE `cardservice`.`card_type_info` ADD INDEX `IX_projectNo`(`project_no` ASC) USING BTREE;

ALTER TABLE `cardservice`.`card_type_info` ADD INDEX `IX_parkId_code`(`park_id` ASC, `card_type_code` ASC) USING BTREE;

SET FOREIGN_KEY_CHECKS=1;