-- Migration: Add lead_type field to users table
-- Run this SQL to add the lead_type column to your users table
-- 
-- NOTE: If the lead_type column already exists, you'll get an error.
-- In that case, you can skip this migration or modify it to use:
-- ALTER TABLE users MODIFY COLUMN lead_type ENUM('chp', 'fsp') DEFAULT NULL;

ALTER TABLE users 
ADD COLUMN lead_type ENUM('chp', 'fsp') DEFAULT NULL 
AFTER passport_number;

-- Update existing users (optional - you can set default if needed)
-- UPDATE users SET lead_type = 'chp' WHERE lead_type IS NULL;

