-- Step 1: Add 'awaiting_proof' to the ENUM to allow the update
ALTER TABLE `applications` MODIFY `status` ENUM('pending', 'awaiting_proof', 'pending_approval', 'approved', 'rejected') NOT NULL;

-- Step 2: Update existing 'pending' values
UPDATE `applications` SET `status` = 'awaiting_proof' WHERE `status` = 'pending';

-- Step 3: Remove 'pending' from the ENUM
ALTER TABLE `applications` MODIFY `status` ENUM('awaiting_proof', 'pending_approval', 'approved', 'rejected') NOT NULL DEFAULT 'awaiting_proof';
