aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGibheer <gibheer+git@zero-knowledge.org>2018-11-16 11:16:30 +0100
committerGibheer <gibheer+git@zero-knowledge.org>2018-11-16 11:16:30 +0100
commit6da89f825c2f3b1ffda98e71a37521ae6248420d (patch)
treee15372d40c9b3def1234717ffe92017ac0643a52
parentbfd2b5d324d7348eff22c4a991fa0f21e09360f5 (diff)
add unique index on check_id
-rw-r--r--schema/20181116.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/schema/20181116.sql b/schema/20181116.sql
index cb97acf..48baa8f 100644
--- a/schema/20181116.sql
+++ b/schema/20181116.sql
@@ -57,7 +57,7 @@ CREATE TABLE notifications (
);
CREATE TABLE 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,
cmdline text[] NOT NULL,
next_time timestamp with time zone DEFAULT now() NOT NULL,
states integer[] DEFAULT ARRAY[0] NOT NULL,