-- 保留现有电池组表单入口，值统一进入字段定义与电池组当前值模型。
INSERT INTO t_battery_group_field (field_name, field_type, create_by)
SELECT name, 'text', 'system' FROM
(SELECT 'Z' name UNION ALL SELECT 'H' UNION ALL SELECT 'F' UNION ALL SELECT 'A' UNION ALL SELECT 'B') specs
WHERE NOT EXISTS (SELECT 1 FROM t_battery_group_field field WHERE field.field_name=specs.name AND field.del_flag=0);