feat: migration 019 + 5 starter LinkedIn post drafts (corridor commentary x2, project reveal x2, behind-the-scenes x1)

ee200d8b952db6af8a2603a0d9760be2dd1b117a · 2026-05-07 09:02:44 -0700 · SteveStudio2

Files touched

A db/migrations/019_linkedin_pitch_cols.sql

Diff

commit ee200d8b952db6af8a2603a0d9760be2dd1b117a
Author: SteveStudio2 <stevestudio2@SteveStacStudio.lan>
Date:   Thu May 7 09:02:44 2026 -0700

    feat: migration 019 + 5 starter LinkedIn post drafts (corridor commentary x2, project reveal x2, behind-the-scenes x1)
---
 db/migrations/019_linkedin_pitch_cols.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)

diff --git a/db/migrations/019_linkedin_pitch_cols.sql b/db/migrations/019_linkedin_pitch_cols.sql
new file mode 100644
index 0000000..b673a33
--- /dev/null
+++ b/db/migrations/019_linkedin_pitch_cols.sql
@@ -0,0 +1,12 @@
+-- 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;

← 64555b1 fix: migration 018 — adds magazine_features.taps + taps_brea · back to Ventura Corridor · feat: bulk-seed 10,050 pitches across 10 archetypes (office- c6a6ecd →