-- Phase 12 — extend users.status ENUM to support self-service deactivation
-- and operator/admin-driven hard delete request lifecycle. Idempotent.

ALTER TABLE users
    MODIFY COLUMN status ENUM('active','suspended','pending','deactivated') NOT NULL DEFAULT 'active';
