From fa05045d31c05c8928020f05f1d281901d983b2b Mon Sep 17 00:00:00 2001
From: Gibheer <gibheer+git@zero-knowledge.org>
Date: Thu, 2 Dec 2021 17:54:14 +0100
Subject: cmd/monfront - import monfront from separate repository

This is the import from the separate monfront repository. The history
could not be imported, but this should suffice.
---
 schema/20190812.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 schema/20190812.sql

(limited to 'schema/20190812.sql')

diff --git a/schema/20190812.sql b/schema/20190812.sql
new file mode 100644
index 0000000..297a3e7
--- /dev/null
+++ b/schema/20190812.sql
@@ -0,0 +1,14 @@
+create table checkers(
+  id serial not null primary key,
+  name text not null unique,
+  description text
+);
+
+insert into checkers(name, description) values ('moncheck', 'moncheck provides a nagios compatible API to run checks. It calls binaries, which control the alarm state by their exit code.');
+
+alter table checks add checker_id integer not null default 1
+  references checkers(id) on delete cascade;
+alter table checks alter checker_id drop default;
+alter table active_checks add checker_id integer not null default 1
+  references checkers(id) on delete cascade;
+alter table active_checks alter checker_id drop default;
-- 
cgit v1.3

