-- The added_at correction added in 002 could only use Tautulli's history, which
-- starts 2025-03-08. But the evidence that proved Plex's addedAt wrong is Plex's
-- own lastViewedAt, which reaches back years further — 2001: A Space Odyssey
-- reports added 2026-07-31 and last watched 2017-08-26.
--
-- That field was parsed by the provider and then dropped on the floor, so the
-- correction fired zero times on the live library. Store it.
--
-- Seasons also need a provider_added_at of their own (the MIN over their
-- episodes), or their added_at_source can never be computed.

ALTER TABLE media_item ADD COLUMN provider_last_viewed_at INTEGER;
ALTER TABLE episode ADD COLUMN provider_last_viewed_at INTEGER;