From fa05045d31c05c8928020f05f1d281901d983b2b Mon Sep 17 00:00:00 2001 From: Gibheer 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.2.3-70-g09d2