9 lines
510 B
SQL
9 lines
510 B
SQL
-- 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';
|