Files
MiragenFlow/server/migrations/0015_v1_payment_request_fingerprints.sql

7 lines
331 B
SQL

-- Preserve payment/order request fingerprints across PostgreSQL reloads so
-- idempotency checks cannot fall back to a lossy amount/plan comparison.
ALTER TABLE IF EXISTS recharge_orders
ADD COLUMN IF NOT EXISTS request_fingerprint TEXT;
ALTER TABLE IF EXISTS plan_purchases
ADD COLUMN IF NOT EXISTS request_fingerprint TEXT;