13 lines
538 B
SQL
13 lines
538 B
SQL
|
-- Channel Monitor V2 is designed around fixed UI buckets; refresh passive
|
||
|
|
-- aggregation every 5 minutes and recompute the trailing bucket for each range.
|
||
|
|
-- Only migrate the untouched factory row. A row with a newer version or an
|
||
|
|
-- updater identity reflects an operator choice and must retain its 60-second
|
||
|
|
-- interval (or any other valid setting).
|
||
|
|
UPDATE channel_monitor_v2_config
|
||
|
|
SET refresh_interval_seconds = 300,
|
||
|
|
updated_at = NOW()
|
||
|
|
WHERE id = 1
|
||
|
|
AND version = 1
|
||
|
|
AND updated_by IS NULL
|
||
|
|
AND refresh_interval_seconds = 60;
|