← back to NationalPaperHangers

db/migrations/002_ad_signals.sql

16 lines

-- 002 · Ad / social signals JSONB per installer
-- Stores tracking-pixel fingerprints mined from each studio's homepage.
-- Idempotent.

BEGIN;

ALTER TABLE installers
  ADD COLUMN IF NOT EXISTS ad_signals JSONB,
  ADD COLUMN IF NOT EXISTS ad_signals_at TIMESTAMPTZ;

CREATE INDEX IF NOT EXISTS idx_installers_ad_signals_paid
  ON installers((ad_signals->>'paid_ads_count'))
  WHERE ad_signals IS NOT NULL;

COMMIT;