-- Migration 027: Annual billing interval on subscriptions
-- Adds billing_interval column so subscriptions can be monthly or annual.
-- renews_at already exists; BillingService sets it to +1 year for annual subs.

ALTER TABLE subscriptions
    ADD COLUMN billing_interval ENUM('monthly','annual') NOT NULL DEFAULT 'monthly'
        AFTER status;
