1
2
3
4
5
| -- 保留现有电池组表单入口，值统一进入字段定义与电池组当前值模型。
| 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);
|
|
