-- Migration script to add OTP fields to users table
-- Run this script in your database to add the email verification OTP columns

ALTER TABLE `users` 
ADD COLUMN `emailVerificationOTP` VARCHAR(6) NULL AFTER `emailVerificationTokenExpiry`,
ADD COLUMN `emailVerificationOTPExpiry` DATETIME NULL AFTER `emailVerificationOTP`;

-- Verify the columns were added
-- SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE 
-- FROM INFORMATION_SCHEMA.COLUMNS 
-- WHERE TABLE_NAME = 'users' 
-- AND COLUMN_NAME IN ('emailVerificationOTP', 'emailVerificationOTPExpiry');