`db/migrations/020_pitches_query_columns.sql`

13 lines
-- Migration 020 — restore columns the /api/pitches query was already selecting.
--
-- Caught 2026-05-07 by the audit-tabs.cjs Playwright sweep: /pitches.html
-- returned `column p.website does not exist` because earlier migrations 010
-- and 019 added a subset of pitches columns but the query in
-- src/server/index.ts also references website / instagram / li_connection_status
-- which had no migration of their own.

ALTER TABLE pitches
  ADD COLUMN IF NOT EXISTS website              TEXT,
  ADD COLUMN IF NOT EXISTS instagram            TEXT,
  ADD COLUMN IF NOT EXISTS li_connection_status TEXT;