shanxia2.0/docs/sql/migrations/2026-10-25-pl-vehicle-recharge-shanxia.sql

-- 充值类型新增「山峡」；现有 recharge_type VARCHAR(20) 可直接存储 shanxia。
-- 按已有充值类型字典的租户补充选项，可重复执行，不修改历史充值记录。
SET NAMES utf8mb4;

UPDATE `sys_dict_data` AS d
INNER JOIN `sys_dict_type` AS t
  ON t.`tenant_no` = d.`tenant_no` AND t.`dict_type` = d.`dict_type`
SET d.`dict_label` = '山峡', d.`tag_type` = 'success',
    d.`del_flag` = 0, d.`update_by` = 'system', d.`update_time` = NOW()
WHERE t.`dict_type` = 'pl_recharge_type' AND t.`del_flag` = 0
  AND d.`dict_value` = 'shanxia';

INSERT INTO `sys_dict_data`
  (`id`, `dict_label`, `dict_value`, `tag_type`, `dict_type`, `tenant_no`,
   `order_num`, `remark`, `create_by`, `create_dept_id`, `create_time`,
   `update_by`, `update_time`, `del_flag`)
SELECT UUID(), '山峡', 'shanxia', 'success', 'pl_recharge_type', t.`tenant_no`,
       3, NULL, 'system', '', NOW(), 'system', NOW(), 0
FROM (SELECT DISTINCT `tenant_no` FROM `sys_dict_type`
      WHERE `dict_type` = 'pl_recharge_type' AND `del_flag` = 0) AS t
WHERE NOT EXISTS (
  SELECT 1 FROM `sys_dict_data` AS d
  WHERE d.`tenant_no` = t.`tenant_no`
    AND d.`dict_type` = 'pl_recharge_type' AND d.`dict_value` = 'shanxia'
);