INSERT IGNORE INTO company_subscriptions (
    company_id,
    plan_id,
    status,
    start_date,
    end_date
)
SELECT
    c.id,
    sp.id,
    'active',
    CURDATE(),
    DATE_ADD(CURDATE(), INTERVAL 1 YEAR)
FROM companies c
JOIN subscription_plans sp ON sp.plan_key = 'free';
