From f759b2f9931d2f2b9d80a32dda0dd04c0de00d5e Mon Sep 17 00:00:00 2001 From: Gibheer Date: Fri, 16 Nov 2018 20:08:12 +0100 Subject: remove unique constraint on notifications That constraint would hinder the addition of multiple notifications, so it needs to be removed. --- schema/20181116.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/schema/20181116.sql b/schema/20181116.sql index 48baa8f..fcf14b8 100644 --- a/schema/20181116.sql +++ b/schema/20181116.sql @@ -49,7 +49,7 @@ CREATE TABLE checks ( CREATE TABLE notifications ( id bigserial NOT NULL primary key, - check_id bigint not null unique references checks(id) on delete cascade, + check_id bigint not null references checks(id) on delete cascade, states integer[] not null, output text, inserted timestamp with time zone DEFAULT now() NOT NULL, -- cgit v1.2.3-70-g09d2