3 files changed, 18 insertions, 0 deletions
diff --git a/schema/20190528.sql b/schema/20190528.sql
new file mode 100644
index 0000000..f4d6934
--- /dev/null
+++ b/schema/20190528.sql
@@ -0,0 +1 @@
+alter table active_checks add state_since timestamp with time zone default now() not null;
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;
diff --git a/schema/20190910.sql b/schema/20190910.sql
new file mode 100644
index 0000000..3e452c4
--- /dev/null
+++ b/schema/20190910.sql
@@ -0,0 +1,3 @@
+-- add check instance name field
+alter table checks add name text not null default 'none';
+alter table checks alter name drop default;