app

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

0004_account_farm_setup.sql (1038B)

      1 CREATE TABLE account_farm_setups (
      2     account_id TEXT PRIMARY KEY NOT NULL,
      3     farm_name TEXT NOT NULL,
      4     location_or_service_area TEXT NOT NULL,
      5     pickup_enabled INTEGER NOT NULL CHECK (pickup_enabled IN (0, 1)),
      6     delivery_enabled INTEGER NOT NULL CHECK (delivery_enabled IN (0, 1)),
      7     shipping_enabled INTEGER NOT NULL CHECK (shipping_enabled IN (0, 1)),
      8     saved_farm_id TEXT,
      9     saved_farm_display_name TEXT,
     10     saved_farm_readiness TEXT CHECK (
     11         saved_farm_readiness IS NULL
     12         OR saved_farm_readiness IN ('incomplete', 'ready')
     13     ),
     14     updated_at TEXT NOT NULL,
     15     CHECK (
     16         (
     17             saved_farm_id IS NULL
     18             AND saved_farm_display_name IS NULL
     19             AND saved_farm_readiness IS NULL
     20         )
     21         OR (
     22             saved_farm_id IS NOT NULL
     23             AND saved_farm_display_name IS NOT NULL
     24             AND saved_farm_readiness IS NOT NULL
     25         )
     26     )
     27 );
     28 
     29 CREATE INDEX idx_account_farm_setups_updated_at
     30     ON account_farm_setups(updated_at DESC, account_id DESC);