← back to Lawyer Directory Builder

migrations/011_contact_crawled_at.sql

8 lines

-- Track per-firm contact-page crawl attempts so reruns can skip already-attempted firms.
ALTER TABLE organizations
  ADD COLUMN IF NOT EXISTS contact_crawled_at TIMESTAMPTZ;

CREATE INDEX IF NOT EXISTS idx_orgs_contact_crawled_at
  ON organizations (contact_crawled_at)
  WHERE type = 'law_firm' AND website ~ '^https?://';