From f759b2f9931d2f2b9d80a32dda0dd04c0de00d5e Mon Sep 17 00:00:00 2001
From: Gibheer <gibheer+git@zero-knowledge.org>
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