-- Add email verification fields to users table
ALTER TABLE users ADD COLUMN email_verified INTEGER DEFAULT 0;
ALTER TABLE users ADD COLUMN verification_token TEXT NULL;
ALTER TABLE users ADD COLUMN verification_token_expires DATETIME NULL;

CREATE INDEX IF NOT EXISTS idx_verification_token ON users(verification_token);