21 lines
880 B
SQL
21 lines
880 B
SQL
|
-- +goose Up
|
||
|
|
-- Watch-progress model change: `completed` is a one-way watched latch and
|
||
|
|
-- completed rows hold no resume point (position_seconds = 0), mirroring
|
||
|
|
-- Jellyfin. The Continue Watching predicate becomes position_seconds > 0, so
|
||
|
|
-- a rewatch of a watched item re-enters the row naturally while keeping its
|
||
|
|
-- watched state. Legacy completed rows pinned position_seconds to
|
||
|
|
-- duration_seconds; reset them so they don't surface as phantom resume
|
||
|
|
-- entries under the new predicate.
|
||
|
|
UPDATE user_watch_progress
|
||
|
|
SET position_seconds = 0
|
||
|
|
WHERE completed = TRUE
|
||
|
|
AND position_seconds <> 0;
|
||
|
|
|
||
|
|
-- +goose Down
|
||
|
|
-- Restore the legacy convention (completed rows pinned to duration) so the
|
||
|
|
-- old `completed = FALSE` resume predicate doesn't surface watched items.
|
||
|
|
UPDATE user_watch_progress
|
||
|
|
SET position_seconds = duration_seconds
|
||
|
|
WHERE completed = TRUE
|
||
|
|
AND duration_seconds > 0;
|