-- Migration: Add password reset token columns to users table
-- Run this migration on the punimtag_auth database

-- Add password_reset_token column
ALTER TABLE users 
ADD COLUMN IF NOT EXISTS password_reset_token VARCHAR(255) UNIQUE;

-- Add password_reset_token_expiry column
ALTER TABLE users 
ADD COLUMN IF NOT EXISTS password_reset_token_expiry TIMESTAMP;

-- Create index on password_reset_token for faster lookups
CREATE INDEX IF NOT EXISTS idx_users_password_reset_token ON users(password_reset_token);






