Alireza HassaniandCursor
717a203d48
Import the purchase-price constant for Nest build, and only convert IRT-scale balances so migrate re-runs do not divide credits again. Co-authored-by: Cursor <cursoragent@cursor.com>
13 lines
609 B
SQL
13 lines
609 B
SQL
-- Convert prepaid SMS balance from IRT to credit units (idempotent).
|
|
-- Previous billing: 400 IRT per 64-char segment.
|
|
-- New model: balance is SMS credits (1 credit = 1 segment); top-up at 500 IRT/credit.
|
|
-- Only convert rows that still look like IRT balances (>= 100_000). Already-converted
|
|
-- credit balances are below that and are left unchanged on re-run.
|
|
|
|
UPDATE businesses
|
|
SET sms_balance = sms_balance / 400
|
|
WHERE sms_balance >= 100000;
|
|
|
|
COMMENT ON COLUMN businesses.sms_balance IS
|
|
'Prepaid SMS credit units. 1 unit = one 64-character segment per recipient. Top-up adds floor(IRT / 500) credits.';
|