2026-06-06 23:51:30 -04:00
|
|
|
-- +goose Up
|
|
|
|
|
-- +goose StatementBegin
|
2026-05-22 20:26:11 -04:00
|
|
|
-- Allow users to attach a custom poster to their personal collections,
|
|
|
|
|
-- mirroring the admin/library collection artwork pipeline. Both columns
|
|
|
|
|
-- default to '' so existing rows remain unchanged.
|
|
|
|
|
|
|
|
|
|
ALTER TABLE user_personal_collections
|
|
|
|
|
ADD COLUMN IF NOT EXISTS poster_url TEXT NOT NULL DEFAULT '',
|
|
|
|
|
ADD COLUMN IF NOT EXISTS poster_thumbhash TEXT NOT NULL DEFAULT '';
|
2026-06-06 23:51:30 -04:00
|
|
|
-- +goose StatementEnd
|
|
|
|
|
|
|
|
|
|
-- +goose Down
|
|
|
|
|
-- +goose StatementBegin
|
|
|
|
|
ALTER TABLE user_personal_collections
|
|
|
|
|
DROP COLUMN IF EXISTS poster_thumbhash,
|
|
|
|
|
DROP COLUMN IF EXISTS poster_url;
|
|
|
|
|
-- +goose StatementEnd
|
