[EPIC] Airdrop full teardown (campaign paused)

[realproject7]

Airdrop Full Teardown — campaign paused indefinitely

The PLOT airdrop is paused indefinitely. This EPIC tracks the clean, safe removal of ALL airdrop code, DB objects, cron, frontend, and config — while keeping every core PlotLink feature working (story pages, ratings, on-chain indexing, backfill cron, x-stats, profiles, sharing).

Paused, not cancelled → code is git-tagged and DB data archived before removal so it can be revived.

Background

• v5 "Buy-Back Sprint" reverted; v6 redesign shelved. Airdrop on hold.
• v5 EPIC [EPIC] PlotLink Buy-Back Sprint v5 — Airdrop Campaign #1229 + children already closed (superseded-by-v6).
• Teardown plan reviewed by RE1 across two rounds; all points applied.

Dependency audit (verified 2026-05-28, static)

• lib/airdrop/award.ts = no-op stubs. The 3 callers (ratings, index/storyline, backfill cron) call it fire-and-forget: awardX(...).catch(()=>{}). Return value unused → removing calls is safe.
• ShareButtons uses referral optionally (code ? url?ref=code : url) → degrades to plain story URL. No breakage.
• TWITTERAPI_IO_KEY is SHARED with core x-stats (lib/x-stats.ts) → KEEP the env var; only delete lib/airdrop/twitterapi.ts.
• NEYNAR_API_KEY + CRON_SECRET = core → KEEP.
• No core→airdrop FK (migration scan clean) → DB DROP is safe without CASCADE.
• Airdrop tests live under src/app/api/airdrop/ → deleted with routes (no orphans).
• Packages siwe, @openzeppelin/merkle-tree, @electric-sql/pglite, nanoid = airdrop-only → remove.

Children

• [Teardown-A] Remove all airdrop code + write teardown migration #1316 — Code teardown (agent/T3): remove all airdrop code, write teardown migration file, dep cleanup, build gate
• [Teardown-B] Archive + apply DB teardown migration #1317 — DB teardown (operator): archive + apply forward migration to prod
• [Teardown-C] Revival git tag + Vercel env/cron cleanup #1318 — Env + revival tag (operator): git tag snapshot + Vercel env/cron cleanup

Strict execution order

1. git tag airdrop-v5-archive (revival snapshot) — [Teardown-C] Revival git tag + Vercel env/cron cleanup #1318 C1, do FIRST
2. [Teardown-A] Remove all airdrop code + write teardown migration #1316 code PR → RE1+RE2 review → T1 merge → prod deploy
3. Verify no /airdrop references resolve in prod
4. [Teardown-B] Archive + apply DB teardown migration #1317 DB archive + migration drop
5. [Teardown-C] Revival git tag + Vercel env/cron cleanup #1318 C2 env cleanup

🚨 Critical safety rule

Code teardown + prod deploy MUST land BEFORE DB drop. The airdrop-price / airdrop-weekly crons currently run on schedule; dropping tables before removing the crons would cause them to error on missing tables.

Revival path

• git tag airdrop-v5-archive (full code)
• DB archive tables pl_*_archive_<date>
• Design docs retained in operator workspace (PLOTLINK-diamond-hand-airdrop-5/6.md, PLOTLINK-airdrop-teardown-checklist.md)

[realproject7]

✅ Airdrop full teardown complete (2026-05-28).

Child	Result
#1316 Code	PR #1319 merged; CI (lint/typecheck/e2e/Vercel) pass; all airdrop code/routes/frontend/crons/contracts/packages removed; core (story, share, ratings, indexing, backfill, x-stats) verified intact
#1317 DB	weighted_spend + 8 pl_* tables dropped (forward migration 00042); archive skipped (test-only data); table list confirms only core tables remain
#1318 Env+tag	airdrop-v5-archive tag pushed; 2 airdrop env vars removed; crons cleaned

Revival path: git tag airdrop-v5-archive (full code) + design docs (PLOTLINK-diamond-hand-airdrop-5/6.md, teardown checklist) in operator workspace.

Repo + DB are clean of airdrop. Closing EPIC.