-- PAX8 subscription cost columns.
--
-- PAX8's Subscription object (GET /subscriptions?page=&size=, Phase 11
-- research, devx.pax8.com findsubscriptions) exposes both a customer/list
-- `price` and a partner/reseller `partnerCost` per subscription, plus a
-- `currencyCode`. Migration 091 did not model these — this migration adds
-- them as additive columns on the existing pax8_subscriptions table (D-03).
--
-- Raw per-billing-period amounts are stored exactly as PAX8 returns them,
-- paired with the existing billing_term column. Monthly normalization is a
-- read-time concern, not modeled here (D-04).

ALTER TABLE pax8_subscriptions
  ADD COLUMN IF NOT EXISTS price NUMERIC(12,2);

ALTER TABLE pax8_subscriptions
  ADD COLUMN IF NOT EXISTS partner_cost NUMERIC(12,2);

ALTER TABLE pax8_subscriptions
  ADD COLUMN IF NOT EXISTS currency CHAR(3) NOT NULL DEFAULT 'USD';