smon/sql/00014.sql
2024-05-25 14:26:12 +02:00

5 lines
236 B
SQL

ALTER TABLE datapoint ADD COLUMN nodata_problem_seconds INT4 NOT NULL DEFAULT 0;
ALTER TABLE datapoint ADD COLUMN nodata_is_problem BOOL NOT NULL DEFAULT false;
CREATE INDEX datapoint_last_value_idx ON public.datapoint ("last_value");