-- Add subscription columns
ALTER TABLE stores ADD COLUMN subscription_end_date DATETIME DEFAULT NULL;
ALTER TABLE stores ADD COLUMN subscription_plan INT DEFAULT 1;

-- Set default subscription for existing stores (Unlimited/Long term)
UPDATE stores SET subscription_end_date = '2099-12-31 23:59:59' WHERE subscription_end_date IS NULL;
