-- Migration: Update theme column to support larger JSON configurations
-- Date: 2025-10-26
-- Description: Change theme column from VARCHAR(500) to TEXT to support full theme JSON

USE cms_db;

-- Update organizations table - change theme column type
ALTER TABLE organizations 
MODIFY COLUMN theme TEXT DEFAULT NULL;

-- Verify the change
DESCRIBE organizations;

-- Success message
SELECT 'Theme column updated successfully. Can now store larger theme configurations.' as status;