JavaProjectRepo/business-css/init_algorithm_models.sql

13 lines
940 B
MySQL
Raw Permalink Normal View History

2026-03-19 11:18:15 +08:00
-- 插入 GPR 算法的默认模型记录
-- 注意:模型路径仅为示例,请根据实际部署路径进行调整
INSERT INTO algorithm_model (algorithm_model_id, algorithm_type, device_type, version_tag, model_path, is_current, created_at, updated_at)
VALUES
(UUID(), 'GPR', 'CylindricalTank', 'v1.0', 'models/gpr/cylindrical_tank_model.pkl', 1, NOW(), NOW()),
(UUID(), 'GPR', 'AnnularTank', 'v1.0', 'models/gpr/annular_tank_model.pkl', 1, NOW(), NOW()),
(UUID(), 'GPR', 'FlatTank', 'v1.0', 'models/gpr/flat_tank_model.pkl', 1, NOW(), NOW()),
(UUID(), 'GPR', 'TubeBundleTank', 'v1.0', 'models/gpr/tube_bundle_tank_model.pkl', 1, NOW(), NOW()),
(UUID(), 'GPR', 'ExtractionColumn', 'v1.0', 'models/gpr/extraction_column_model.pkl', 1, NOW(), NOW()),
(UUID(), 'GPR', 'FluidizedBed', 'v1.0', 'models/gpr/fluidized_bed_model.pkl', 1, NOW(), NOW()),
(UUID(), 'GPR', 'ACFTank', 'v1.0', 'models/gpr/acf_tank_model.pkl', 1, NOW(), NOW());