blob: 297a3e714d450a6b374882292fd2b3b99a9866d1 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
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;
|
