-- Add Cashi Points balance to users
ALTER TABLE "users"
ADD COLUMN IF NOT EXISTS "cashiPoints" INTEGER NOT NULL DEFAULT 0;

-- Add points cost to coupons
ALTER TABLE "coupons"
ADD COLUMN IF NOT EXISTS "cashiPointsCost" INTEGER NOT NULL DEFAULT 0;

-- Optional: index for filtering affordable coupons (future use)
CREATE INDEX IF NOT EXISTS "coupons_cashiPointsCost_idx" ON "coupons" ("cashiPointsCost");

