-- Migration 019: Add stripe_customer_id to subscriptions for webhook correlation
-- Applied: 2026-05-21

ALTER TABLE subscriptions
    ADD COLUMN stripe_customer_id VARCHAR(64) NULL DEFAULT NULL AFTER provider_ref,
    ADD KEY idx_sub_stripe_cus (stripe_customer_id);
