Alireza HassaniandCursor
4a1d60dbef
Charge ceil(len/64)*400 IRT per recipient across OTP, customer, and partner SMS; seed new businesses with 500k IRT; default partner sends to the advertising line. Co-authored-by: Cursor <cursoragent@cursor.com>
8 lines
305 B
SQL
8 lines
305 B
SQL
-- Per-business prepaid SMS credit (messages). Deducted when customer SMS is sent.
|
|
|
|
ALTER TABLE businesses
|
|
ADD COLUMN IF NOT EXISTS sms_balance INTEGER NOT NULL DEFAULT 0;
|
|
|
|
COMMENT ON COLUMN businesses.sms_balance IS
|
|
'Prepaid SMS message credits for this business; decremented on customer SMS send.';
|