-- Commercial plan metadata and an explicit subscription interval are retained
-- in the SaaS entitlement store. WooCommerce remains the billing source.
CREATE TYPE "BillingInterval" AS ENUM ('MONTHLY', 'ANNUAL', 'LIFETIME');

ALTER TABLE "Plan"
  ADD COLUMN "monthlyPriceCents" INTEGER NOT NULL DEFAULT 0,
  ADD COLUMN "annualPriceCents" INTEGER NOT NULL DEFAULT 0,
  ADD COLUMN "trialDays" INTEGER NOT NULL DEFAULT 7,
  ADD COLUMN "refundWindowDays" INTEGER NOT NULL DEFAULT 30,
  ADD COLUMN "allowChatAnalytics" BOOLEAN NOT NULL DEFAULT false,
  ADD COLUMN "allowWhiteLabel" BOOLEAN NOT NULL DEFAULT false,
  ADD COLUMN "clientSeatLimit" INTEGER NOT NULL DEFAULT 0;

ALTER TABLE "Subscription"
  ADD COLUMN "billingInterval" "BillingInterval" NOT NULL DEFAULT 'MONTHLY',
  ADD COLUMN "accessEndsAt" TIMESTAMP(3);