add missing table to database schema

The checks_notify table was missing and needs to be added. As this is
still alpha software, there is no need for a migration step yet.

1 files changed, 9 insertions, 2 deletions

diff --git a/schema/20181116.sql b/schema/20181116.sql
index fcf14b8..ed347a5 100644
--- a/schema/20181116.sql
+++ b/schema/20181116.sql
@@ -53,7 +53,8 @@ CREATE TABLE notifications (
     states integer[] not null,
     output text,
     inserted timestamp with time zone DEFAULT now() NOT NULL,
-    sent timestamp with time zone
+    sent timestamp with time zone,
+    check_host text not null
 );
 
 CREATE TABLE active_checks (
@@ -63,10 +64,16 @@ CREATE TABLE active_checks (
     states integer[] DEFAULT ARRAY[0] NOT NULL,
     intval interval NOT NULL,
     enabled boolean NOT NULL,
-    notify boolean NOT NULL,
     notice text
 );
 
+create table checks_notify(
+  check_id bigint not null references checks(id) on delete cascade,
+  notifier_id int not null references notifier(id) on delete cascade,
+  enabled bool not null default true,
+  unique(check_id, notifier_id)
+);
+
 CREATE INDEX ON active_checks(next_time) WHERE enabled;
 CREATE INDEX ON checks(updated, last_refresh nulls first);
 CREATE INDEX ON checks(node_id);