-- +goose Up
-- A post's featured image: a library image shown as a thumbnail on listings
-- and on the post page. Deleting the file just unsets it.
ALTER TABLE posts ADD COLUMN image uuid REFERENCES files(id) ON DELETE SET NULL;

-- +goose Down
ALTER TABLE posts DROP COLUMN image;