-- Marketplace / storefront banner image for a business (aspect 18:4.5 ≈ 4:1)
ALTER TABLE businesses
  ADD COLUMN IF NOT EXISTS banner_media_id BIGINT;

ALTER TABLE businesses
  DROP CONSTRAINT IF EXISTS businesses_banner_media_id_fkey;

ALTER TABLE businesses
  ADD CONSTRAINT businesses_banner_media_id_fkey
  FOREIGN KEY (banner_media_id) REFERENCES media (id) ON DELETE SET NULL;

COMMENT ON COLUMN businesses.banner_media_id IS
  'Optional marketplace/storefront banner; recommended aspect ratio 18:4.5 (4:1).';