-- Migration: 040-add-email-verified-at-and-address.sql
-- Description: Add email_verified_at and address columns to users table for
--              email verification flow + full profile support on register.
-- Date: 2026-06-17

ALTER TABLE users
    ADD COLUMN IF NOT EXISTS email_verified_at TIMESTAMP WITH TIME ZONE,
    ADD COLUMN IF NOT EXISTS address          TEXT;

-- Index to support filtering verified users and audit queries
CREATE INDEX IF NOT EXISTS idx_users_email_verified_at
    ON users (email_verified_at);
