← back to Ventura Claw Leads

db/migrations/008_business_photo_path.sql

6 lines

-- Profile photo per business. Stored as a relative path under
-- /uploads/business-photos/ — served as a static asset by Express.
-- NULL = use the vertical-themed gradient hero (the v0.2 fallback).

ALTER TABLE businesses ADD COLUMN IF NOT EXISTS photo_path TEXT;