.env.example

# ==============================================================================
# Azure PostgreSQL Connection
# ==============================================================================
# For Azure Database for PostgreSQL:
# - Host format: your-server.postgres.database.azure.com
# - SSL is required in production (automatically configured)
# - Ensure firewall rules allow Vercel IP ranges or Azure services

AZURE_POSTGRES_HOST=your-server.postgres.database.azure.com
AZURE_POSTGRES_PORT=5432
AZURE_POSTGRES_DB=your-database-name
AZURE_POSTGRES_USER=your-username
AZURE_POSTGRES_PASSWORD=your-password

# ==============================================================================
# Database Schema
# ==============================================================================
# Schema prefix for auth tables (e.g., 'myapp' creates myapp.users, myapp.magic_tokens)
# Must match the schema in sql/auth_tables.sql

DB_SCHEMA=myapp

# ==============================================================================
# Authentication
# ==============================================================================
# Generate a secure secret: openssl rand -hex 32
# CRITICAL: Change this in production!

AUTH_SECRET=change-me-in-production


# ==============================================================================
# SMTP Configuration (Magic Link Email Delivery)
# ==============================================================================
# Gmail example (requires app-specific password if 2FA enabled):
#   SMTP_HOST=smtp.gmail.com
#   SMTP_PORT=587
#   SMTP_USER=your-email@gmail.com
#   SMTP_PASS=your-app-password
#
# Mailbox.org example:
#   SMTP_HOST=smtp.mailbox.org
#   SMTP_PORT=587

SMTP_HOST=smtp.mailbox.org
SMTP_PORT=587
SMTP_USER=your-email@example.com
SMTP_PASS=your-smtp-password
SMTP_FROM=noreply@example.com