diff options
| author | Gibheer <gibheer+git@zero-knowledge.org> | 2018-11-16 20:08:12 +0100 |
|---|---|---|
| committer | Gibheer <gibheer+git@zero-knowledge.org> | 2018-11-16 20:08:12 +0100 |
| commit | f759b2f9931d2f2b9d80a32dda0dd04c0de00d5e (patch) | |
| tree | eaabcd021d2b6c90735cdcee18b68fc9db1cf64f /schema | |
| parent | 6da89f825c2f3b1ffda98e71a37521ae6248420d (diff) | |
remove unique constraint on notifications
That constraint would hinder the addition of multiple notifications, so
it needs to be removed.
Diffstat (limited to 'schema')
| -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 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, |