diff options
| author | Gibheer <gibheer+git@zero-knowledge.org> | 2018-11-16 11:16:30 +0100 |
|---|---|---|
| committer | Gibheer <gibheer+git@zero-knowledge.org> | 2018-11-16 11:16:30 +0100 |
| commit | 6da89f825c2f3b1ffda98e71a37521ae6248420d (patch) | |
| tree | e15372d40c9b3def1234717ffe92017ac0643a52 | |
| parent | bfd2b5d324d7348eff22c4a991fa0f21e09360f5 (diff) | |
add unique index on check_id
| -rw-r--r-- | schema/20181116.sql | 2 |
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, |