PhoenixKit.Migrations.Postgres.V07 (phoenix_kit v1.6.16)

View Source

PhoenixKit V07 Migration: Email System

This migration introduces comprehensive email tracking capabilities including logging of outgoing emails, event tracking (open, click, bounce), and integration with AWS SES for delivery monitoring.

Changes

Email System

  • Adds phoenix_kit_email_logs table for comprehensive email logging
  • Adds phoenix_kit_email_events table for tracking delivery events
  • Supports AWS SES integration with configuration sets
  • Provides detailed analytics and monitoring capabilities
  • Includes rate limiting and security features

New Tables

  • phoenix_kit_email_logs: Main email logging with extended metadata
  • phoenix_kit_email_events: Event tracking (open, click, bounce, complaint)

PostgreSQL Support

  • Supports PostgreSQL prefix for schema isolation
  • Optimized indexes for performance
  • JSONB fields for flexible metadata storage

Summary

Functions

down(opts)
up(opts)

Run the V07 migration to add email tracking system.

Functions

down(opts)

up(opts)

Run the V07 migration to add email tracking system.