2026-06-06 23:51:30 -04:00
|
|
|
-- +goose Up
|
|
|
|
|
-- +goose StatementBegin
|
2026-05-22 20:26:11 -04:00
|
|
|
ALTER TABLE public.media_items
|
|
|
|
|
ADD COLUMN IF NOT EXISTS release_date date;
|
|
|
|
|
|
|
|
|
|
UPDATE public.media_items
|
|
|
|
|
SET release_date = NULLIF(first_air_date, '')::date
|
|
|
|
|
WHERE release_date IS NULL
|
|
|
|
|
AND first_air_date IS NOT NULL;
|
2026-06-06 23:51:30 -04:00
|
|
|
-- +goose StatementEnd
|
|
|
|
|
|
|
|
|
|
-- +goose Down
|
|
|
|
|
-- +goose StatementBegin
|
|
|
|
|
ALTER TABLE public.media_items
|
|
|
|
|
DROP COLUMN IF EXISTS release_date;
|
|
|
|
|
-- +goose StatementEnd
|
