diff options
| author | Gibheer <gibheer+git@zero-knowledge.org> | 2018-12-11 13:24:42 +0100 |
|---|---|---|
| committer | Gibheer <gibheer+git@zero-knowledge.org> | 2018-12-11 13:24:42 +0100 |
| commit | 56614596289b37e0e2597aadd9b2deb71be73153 (patch) | |
| tree | 09d55c0c4854081412db9dcf768484aebaf573cd /schema | |
| parent | 02925bc33574fe9fe9669fc7afb797d1fc293583 (diff) | |
add alarm mapping to notifications
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/20181210.sql | 3 |
1 files changed, 2 insertions, 1 deletions
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), ); |