From 56614596289b37e0e2597aadd9b2deb71be73153 Mon Sep 17 00:00:00 2001 From: Gibheer Date: Tue, 11 Dec 2018 13:24:42 +0100 Subject: add alarm mapping to notifications --- schema/20181210.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'schema') diff --git a/schema/20181210.sql b/schema/20181210.sql index 05236ca..e6be91d 100644 --- a/schema/20181210.sql +++ b/schema/20181210.sql @@ -83,7 +83,8 @@ CREATE TABLE public.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, + mapping_id integer not null references mappings(id), ); -- cgit v1.2.3-70-g09d2