shanxia2.0/docs/sql/migrations/2026-09-16-pl-vehicle-fuel-tons-and-category.sql

-- 加油登记：新增加油/吨；类别注释补充山峡（码值 shanxia_factory）
-- 1176 升 = 1 吨；fuel_tons 保留 3 位小数

SET NAMES utf8mb4;

ALTER TABLE `pl_vehicle_fuel_register`
  ADD COLUMN `fuel_tons` decimal(10,3) DEFAULT NULL COMMENT '加油/吨（升÷1176，3位小数）' AFTER `fuel_liters`;

-- 回填已有数据
UPDATE `pl_vehicle_fuel_register`
SET `fuel_tons` = ROUND(`fuel_liters` / 1176, 3)
WHERE `fuel_liters` IS NOT NULL AND `fuel_tons` IS NULL;

ALTER TABLE `pl_vehicle_fuel_register`
  MODIFY COLUMN `fuel_category` varchar(20) NOT NULL
  COMMENT '加油类别 bailian-百链 gas_station-加油站 shanxia_factory-山峡';