app

Local-first trade for farms and co-ops
git clone https://radroots.dev/git/app.git
Log | Files | Refs | README | LICENSE

0019_relay_ingest_freshness.sql (720B)

      1 CREATE TABLE app_relay_ingest_freshness (
      2     scope_key TEXT NOT NULL,
      3     relay_url TEXT NOT NULL,
      4     state TEXT NOT NULL CHECK (state IN ('fresh', 'stale', 'failed')),
      5     cursor_since_unix_seconds INTEGER,
      6     last_event_created_at_unix_seconds INTEGER,
      7     last_fetch_started_at TEXT NOT NULL,
      8     last_fetch_started_unix_seconds INTEGER NOT NULL,
      9     last_fetch_completed_at TEXT,
     10     last_fetch_completed_unix_seconds INTEGER,
     11     last_success_at TEXT,
     12     last_success_unix_seconds INTEGER,
     13     last_error_message TEXT,
     14     updated_at TEXT NOT NULL,
     15     PRIMARY KEY(scope_key, relay_url)
     16 );
     17 
     18 CREATE INDEX idx_app_relay_ingest_freshness_scope_state
     19     ON app_relay_ingest_freshness(scope_key, state, relay_url);