diff options
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/20181210.sql | 4 |
1 files changed, 1 insertions, 3 deletions
diff --git a/schema/20181210.sql b/schema/20181210.sql index 9c24197..7d344b0 100644 --- a/schema/20181210.sql +++ b/schema/20181210.sql @@ -63,7 +63,7 @@ CREATE TABLE public.checks ( ); CREATE TABLE public.active_checks ( - check_id bigint NOT NULL references checks(id) on delete cascade, + check_id bigint NOT NULL unique references checks(id) on delete cascade, mapping_id int not null references mappings(id), cmdline text[] NOT NULL, next_time timestamp with time zone DEFAULT now() NOT NULL, @@ -94,8 +94,6 @@ CREATE TABLE public.notifications ( ); -CREATE INDEX ON public.active_checks USING btree (check_id); - CREATE INDEX ON public.active_checks USING btree (next_time) WHERE enabled; CREATE INDEX ON public.checks USING btree (command_id); |