-- Business profile fields for dashboard / public storefront

ALTER TABLE businesses
  ADD COLUMN IF NOT EXISTS vision TEXT,
  ADD COLUMN IF NOT EXISTS emails JSONB NOT NULL DEFAULT '[]'::jsonb,
  ADD COLUMN IF NOT EXISTS phone_numbers JSONB NOT NULL DEFAULT '[]'::jsonb,
  ADD COLUMN IF NOT EXISTS social_media JSONB NOT NULL DEFAULT '{}'::jsonb,
  ADD COLUMN IF NOT EXISTS logo_media_id BIGINT;

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