← back to Lawyer Directory Builder

migrations/018_site_intel.sql

13 lines

-- Cache real-site content extracted at mockup-gen time, so re-renders skip the fetch.
ALTER TABLE organizations
  ADD COLUMN IF NOT EXISTS site_intel_title       TEXT,
  ADD COLUMN IF NOT EXISTS site_intel_h1          TEXT,
  ADD COLUMN IF NOT EXISTS site_intel_meta_desc   TEXT,
  ADD COLUMN IF NOT EXISTS site_intel_body        TEXT,
  ADD COLUMN IF NOT EXISTS site_intel_practice    TEXT[],
  ADD COLUMN IF NOT EXISTS site_intel_attorneys   TEXT[],
  ADD COLUMN IF NOT EXISTS site_intel_at          TIMESTAMPTZ;

CREATE INDEX IF NOT EXISTS idx_org_site_intel_pending ON organizations (id)
  WHERE type='law_firm' AND website IS NOT NULL AND site_intel_at IS NULL;