CREATE USER failover_log_user WITH PASSWORD 'failover_log_password';

CREATE TABLE public.failovers
(
  id bigserial NOT NULL PRIMARY KEY,
  applied timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  reason varchar,
  exit_code integer,
  results text,
  script text,
  cluster_name varchar
);
GRANT SELECT, INSERT ON TABLE public.failovers TO failover_log_user;
GRANT SELECT, UPDATE ON TABLE public.failovers_id_seq TO failover_log_user;
