fix some syntax errors in the schema definition

1 files changed, 4 insertions, 4 deletions

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
 );