1 files changed, 14 insertions, 0 deletions
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;