-- Standby replication status, shown on /admin/replication. Applied by store/migrate.rs.
-- subject: 'db' for the database snapshot, or a repo id for a replicated repo.
-- last_ok_at is set by the last successful attempt; last_error holds the latest failure and is
-- cleared by a success. last_attempt_at is set by every attempt. refs_sha256 is the refs checksum
-- of the last successful repo push. Timestamps are RFC 3339 UTC stamps from time.rs.

CREATE TABLE replication_status (
    subject         TEXT PRIMARY KEY,
    last_ok_at      TEXT NULL,
    last_error      TEXT NULL,
    last_attempt_at TEXT NULL,
    refs_sha256     TEXT NULL
);