-- 开发库全量清理：保留电池组、电池号、共享字段和测试类型
-- 执行前请先停止 Spring Boot 后端和模拟器

SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE TABLE t_test_sample_measurement;
TRUNCATE TABLE t_test_sample;
TRUNCATE TABLE t_test_collector_sample;
TRUNCATE TABLE t_channel_snapshot;
TRUNCATE TABLE t_device_run_event;
TRUNCATE TABLE t_test_exception;
TRUNCATE TABLE t_protocol_message;
# TRUNCATE TABLE t_test_result;
# TRUNCATE TABLE t_test_field_snapshot;
# TRUNCATE TABLE t_test_collector_channel;
TRUNCATE TABLE t_test_battery_field;
TRUNCATE TABLE t_test_channel_binding;
TRUNCATE TABLE t_test_battery;
TRUNCATE TABLE t_test_plan_step;
TRUNCATE TABLE t_test_warning_threshold;
TRUNCATE TABLE t_test_audit;
TRUNCATE TABLE t_test;

TRUNCATE TABLE t_detection_channel;
TRUNCATE TABLE t_detection_cabinet;
TRUNCATE TABLE t_collector;
TRUNCATE TABLE t_device_adapter;

SET FOREIGN_KEY_CHECKS = 1;