# `PhoenixKit.Migrations.Postgres.V09`
[🔗](https://github.com/BeamLabEU/phoenix_kit/blob/v1.7.71/lib/phoenix_kit/migrations/postgres/v09.ex#L1)

PhoenixKit V09 Migration: Email Blocklist Support

This migration adds the email blocklist functionality to the email tracking system,
allowing management of blocked email addresses for rate limiting and spam prevention.

## Changes

### Email Blocklist System
- Adds phoenix_kit_email_blocklist table for blocked email addresses
- Creates indexes for efficient blocklist queries
- Supports temporary and permanent blocks with expiration
- Provides audit trail for block management

### New Features
- **Blocklist Management**: Store blocked email addresses with reasons
- **Expiration Support**: Temporary blocks with automatic expiration
- **User Tracking**: Track which user added the block
- **Audit Trail**: Complete history of block additions and removals
- **Performance Optimized**: Efficient indexes for fast lookups

## PostgreSQL Support
- Supports PostgreSQL prefix for schema isolation
- Optimized indexes for email lookup and expiration queries
- Unique constraint to prevent duplicate blocks

# `down`
[🔗](https://github.com/BeamLabEU/phoenix_kit/blob/v1.7.71/lib/phoenix_kit/migrations/postgres/v09.ex#L92)

Rollback the V09 migration.

# `up`
[🔗](https://github.com/BeamLabEU/phoenix_kit/blob/v1.7.71/lib/phoenix_kit/migrations/postgres/v09.ex#L33)

Run the V09 migration to add email blocklist support.

---

*Consult [api-reference.md](api-reference.md) for complete listing*