-- Migration: Add status field to users table
-- Run this SQL to add the status column to your users table
-- 
-- NOTE: If the status 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 status ENUM('active', 'inactive', 'pending') DEFAULT 'pending';

ALTER TABLE users 
ADD COLUMN status ENUM('active', 'inactive', 'pending') DEFAULT 'pending' 
AFTER passport_number;

-- Update existing users to have 'pending' status if not already set
UPDATE users SET status = 'pending' WHERE status IS NULL;

