CREATE TYPE notification_type AS ENUM('NTFY', 'PUSHOVER', 'HTTP', 'EMAIL');

CREATE TABLE public.notification (
	id serial4 NOT NULL,
	service notification_type DEFAULT 'NTFY' NOT NULL,
	"configuration" jsonb DEFAULT '{}'::jsonb NOT NULL,
	prio int4 DEFAULT 0 NOT NULL,
	CONSTRAINT notification_pk PRIMARY KEY (id),
	CONSTRAINT notification_unique UNIQUE (prio)
);