-- Migration: Update billing_cycle to support multi-month options
-- Run this SQL to update your database schema for multi-month billing cycles

-- Modify billing_cycle column to support more options
ALTER TABLE subscriptions 
MODIFY COLUMN billing_cycle ENUM('monthly','3months','6months','yearly') DEFAULT 'monthly';
