BEGIN;
SET ROLE capability_role;
CREATE TABLE IF NOT EXISTS capability.health (
  capability_id TEXT PRIMARY KEY,
  state TEXT NOT NULL,
  reason TEXT NOT NULL,
  revision BIGINT NOT NULL,
  recorded_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
  CHECK (revision > 0)
);
RESET ROLE;
COMMIT;