-- First, let's check the current enum values
SHOW COLUMNS FROM User LIKE 'role';

-- Then, let's modify the enum to include PENDING
ALTER TABLE `User` 
MODIFY COLUMN `role` ENUM('PENDING', 'READER', 'AUTHOR', 'ADMIN', 'PUBLISHER', 'EDITOR', 'REVIEWER', 'AFFILIATE') NOT NULL DEFAULT 'PENDING';