-- Create verification_otps table
CREATE TABLE verification_otps (
    id INT PRIMARY KEY AUTO_INCREMENT,
    hash_id VARCHAR(32) NOT NULL,
    student_id INT NOT NULL,
    mobile VARCHAR(15) NOT NULL,
    otp VARCHAR(6) NOT NULL,
    method ENUM('sms', 'whatsapp') DEFAULT 'sms',
    status VARCHAR(50),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    verified_at TIMESTAMP NULL,
    verified BOOLEAN DEFAULT FALSE,
    failed_attempts INT DEFAULT 0
); 
