From 627423044209526108fe2664dbd8f9e5d0b2e033 Mon Sep 17 00:00:00 2001
From: Gibheer <gibheer+git@zero-knowledge.org>
Date: Wed, 12 Dec 2018 13:25:40 +0100
Subject: fix some syntax errors in the schema definition

---
 schema/20181210.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'schema/20181210.sql')

diff --git a/schema/20181210.sql b/schema/20181210.sql
index c807863..9c24197 100644
--- a/schema/20181210.sql
+++ b/schema/20181210.sql
@@ -16,7 +16,7 @@ create table public.mapping_level(
 CREATE TABLE public.notifier (
     id serial NOT NULL primary key,
     name text NOT NULL,
-    settings jsonb not null '{}'::jsonb,
+    settings jsonb not null default '{}'::jsonb
 );
 
 CREATE TABLE public.groups (
@@ -30,7 +30,7 @@ CREATE TABLE public.nodes (
     name text NOT NULL,
     updated timestamp with time zone DEFAULT now() NOT NULL,
     created timestamp with time zone DEFAULT now() NOT NULL,
-    message text NOT NULL,
+    message text NOT NULL
 );
 
 CREATE TABLE public.nodes_groups (
@@ -45,7 +45,7 @@ CREATE TABLE public.commands (
     command text NOT NULL,
     updated timestamp with time zone DEFAULT now() NOT NULL,
     created timestamp with time zone DEFAULT now() NOT NULL,
-    message text NOT NULL,
+    message text NOT NULL
 );
 
 CREATE TABLE public.checks (
@@ -90,7 +90,7 @@ 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
 );
 
 
-- 
cgit v1.2.3-70-g09d2

