shanxia2.0/docs/sql/migrations/2026-09-05-pl-vehicle-disburse-soft-delete-release-apply-id.sql

-- 软删发放/处理记录时须释放 uk_apply_id（置 NULL），否则撤销后再发放会撞唯一键。
-- 本脚本清理历史脏数据：已软删但仍占用 apply_id 的行。
-- 执行前请确认库名；可先 SELECT 核对影响行数。

UPDATE pl_vehicle_recharge_record
SET apply_id = NULL
WHERE del_flag = 1
  AND apply_id IS NOT NULL;

UPDATE pl_vehicle_urea_disburse
SET apply_id = NULL
WHERE del_flag = 1
  AND apply_id IS NOT NULL;

UPDATE pl_vehicle_maintenance_process
SET apply_id = NULL
WHERE del_flag = 1
  AND apply_id IS NOT NULL;