-- Lifetime count of SMS messages successfully billed to each business
-- (incremented on charge, decremented on refund). One unit = one recipient.

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

COMMENT ON COLUMN businesses.sms_sent_count IS
  'Lifetime SMS messages billed to this business (one per recipient). Incremented on charge, decremented on refund.';