← back to Ventura Claw Leads

db/migrations/010_share_count.sql

7 lines

-- Per-business share counter. Increments when a visitor taps the 'Share'
-- button on /business/:slug. Surfaced on profile as social proof at the
-- ≥10 threshold (below that we don't show — same anti-pattern guard as
-- views and messages).

ALTER TABLE businesses ADD COLUMN IF NOT EXISTS share_count INTEGER NOT NULL DEFAULT 0;