moviedice/supabase/migrations/00007_landing_reel_posters_cert_backfill.sql

-- Clear cached reel posters that pre-date the 2026-05-21 PG-13 cert filter.
--
-- An older cron populated landing_reel_posters without applying the
-- isMovieAllowedByCert filter, so the table may contain titles that would
-- be rejected by the current policy. We can't cert-check from inside SQL
-- (the data lives at TMDB), so the safe path is to truncate and let the
-- bi-weekly cron repopulate with cert-filtered titles on its next run.
--
-- The route layer (src/app/api/tmdb/reel-posters/route.ts) falls back to
-- a live TMDB /discover call (also cert-filtered) when the table is empty,
-- so this does not cause a user-visible outage.
--
-- PINNED_REEL_POSTERS is not stored in this table — it's an in-code
-- constant prepended at the route layer — so the truncate does not affect
-- the editorial pins.

TRUNCATE TABLE public.landing_reel_posters;