2026-06-06 23:51:30 -04:00
|
|
|
-- +goose Up
|
|
|
|
|
-- +goose StatementBegin
|
2026-05-22 20:26:11 -04:00
|
|
|
-- show_status captures the series lifecycle ("returning", "ended", "cancelled",
|
|
|
|
|
-- "in_production") sourced from metadata providers. Empty string when unknown
|
|
|
|
|
-- or not applicable (movies). Used by the card overlay system to render a
|
|
|
|
|
-- Show Status badge on series cards.
|
|
|
|
|
ALTER TABLE media_items
|
|
|
|
|
ADD COLUMN show_status TEXT NOT NULL DEFAULT '';
|
2026-06-06 23:51:30 -04:00
|
|
|
-- +goose StatementEnd
|
|
|
|
|
|
|
|
|
|
-- +goose Down
|
|
|
|
|
-- +goose StatementBegin
|
|
|
|
|
ALTER TABLE media_items
|
|
|
|
|
DROP COLUMN show_status;
|
|
|
|
|
-- +goose StatementEnd
|
