graphicek/server/database/migrations/1775671533180_sensor_values...

4 lines
270 B
MySQL
Raw Permalink Normal View History

2026-04-08 20:07:25 +02:00
CREATE INDEX IF NOT EXISTS idx_sensor_values_timestamp ON sensor_values (timestamp);
CREATE INDEX IF NOT EXISTS idx_sensor_values_sensor ON sensor_values (sensor_id);
CREATE INDEX IF NOT EXISTS idx_sensor_values_sensor_timestamp ON sensor_values (sensor_id, timestamp);