-- Migration script to fix admin_settings.setting_type ENUM
-- This adds 'template' to the allowed setting_type values for email templates

-- Update the setting_type ENUM to include 'template'
ALTER TABLE admin_settings 
MODIFY COLUMN setting_type ENUM('string', 'number', 'boolean', 'json', 'file', 'template') DEFAULT 'string';

-- Verify the change
SHOW COLUMNS FROM admin_settings LIKE 'setting_type';
