-- Migration: add status field to users for registration approval workflow
ALTER TABLE users
  ADD COLUMN status ENUM('pending', 'active', 'rejected') NOT NULL DEFAULT 'active'
  AFTER role;

-- Existing users are already active
UPDATE users SET status = 'active' WHERE status = 'active';
