fix: migration 018 — adds magazine_features.taps + taps_breakdown for engagement tracking

64555b133a414af76723006dbb642481436d7597 · 2026-05-07 09:00:32 -0700 · SteveStudio2

Files touched

A db/migrations/018_magazine_engagement.sql

Diff

commit 64555b133a414af76723006dbb642481436d7597
Author: SteveStudio2 <stevestudio2@SteveStacStudio.lan>
Date:   Thu May 7 09:00:32 2026 -0700

    fix: migration 018 — adds magazine_features.taps + taps_breakdown for engagement tracking
---
 db/migrations/018_magazine_engagement.sql | 9 +++++++++
 1 file changed, 9 insertions(+)

diff --git a/db/migrations/018_magazine_engagement.sql b/db/migrations/018_magazine_engagement.sql
new file mode 100644
index 0000000..e416489
--- /dev/null
+++ b/db/migrations/018_magazine_engagement.sql
@@ -0,0 +1,9 @@
+-- Migration 018 — engagement columns on magazine_features.
+-- The session-era code (and the new corpus-summary email) reads
+-- mf.taps and mf.taps_breakdown; these need to exist alongside views.
+
+ALTER TABLE magazine_features
+  ADD COLUMN IF NOT EXISTS taps            INTEGER NOT NULL DEFAULT 0,
+  ADD COLUMN IF NOT EXISTS taps_breakdown  JSONB NOT NULL DEFAULT '{}'::jsonb;
+
+CREATE INDEX IF NOT EXISTS idx_magfeat_taps ON magazine_features (taps DESC) WHERE status='published';

← d817e36 feat: 9 AM daily corpus-summary email — totals + cover + top · back to Ventura Corridor · feat: migration 019 + 5 starter LinkedIn post drafts (corrid ee200d8 →