-- Migration: add Stripe session/intent columns to enrollments
-- Run this once against gelife_db before enabling Stripe payments.

ALTER TABLE enrollments
  ADD COLUMN IF NOT EXISTS stripe_session_id      VARCHAR(255) NULL AFTER payment_status,
  ADD COLUMN IF NOT EXISTS stripe_payment_intent  VARCHAR(255) NULL AFTER stripe_session_id;

-- Optional index for fast webhook lookups by session id
CREATE INDEX IF NOT EXISTS idx_enrollments_stripe_session
  ON enrollments (stripe_session_id);