add missing unique constraint

There was a unique constraint missing on the active_checks table.

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);