app

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

0003_account_surface_activation.sql (356B)

      1 CREATE TABLE account_surface_activations (
      2     account_id TEXT PRIMARY KEY NOT NULL,
      3     selected_surface TEXT NOT NULL CHECK (selected_surface IN ('personal', 'farmer')),
      4     farmer_farm_id TEXT,
      5     updated_at TEXT NOT NULL
      6 );
      7 
      8 CREATE INDEX idx_account_surface_activations_updated_at
      9     ON account_surface_activations(updated_at DESC, account_id DESC);