← back to Ventura Corridor

db/migrations/019_linkedin_pitch_cols.sql

13 lines

-- Migration 019 — LinkedIn-specific pitch columns referenced by /linkedin.html
-- and /api/linkedin/* endpoints. These were added inline during the original
-- session but never made it into a numbered migration.

ALTER TABLE pitches
  ADD COLUMN IF NOT EXISTS li_message            TEXT,
  ADD COLUMN IF NOT EXISTS li_invite_sent_at     TIMESTAMPTZ,
  ADD COLUMN IF NOT EXISTS li_invite_accepted_at TIMESTAMPTZ,
  ADD COLUMN IF NOT EXISTS li_dm_sent_at         TIMESTAMPTZ,
  ADD COLUMN IF NOT EXISTS li_dm_replied_at      TIMESTAMPTZ;

CREATE INDEX IF NOT EXISTS idx_pitches_li_dm_sent_at ON pitches (li_dm_sent_at) WHERE li_dm_sent_at IS NOT NULL;