PhoenixKit.Migrations.Postgres.V15 (phoenix_kit v1.5.1)

View Source

PhoenixKit V15 Migration: Email Templates System

This migration introduces a comprehensive email templates management system that allows storing, managing and using email templates through the admin interface.

Changes

Email Templates System

  • Adds phoenix_kit_email_templates table for template storage and management
  • Supports template variables with {{variable}} syntax
  • Includes template categories (system, marketing, transactional)
  • Template versioning and usage tracking
  • Integration with existing email logging system

New Tables

  • phoenix_kit_email_templates: Template storage with metadata, variables, and usage analytics

PostgreSQL Support

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

Summary

Functions

down(opts)

Rollback the V15 migration.

up(opts)

Run the V15 migration to add email templates system.

Functions

down(opts)

Rollback the V15 migration.

up(opts)

Run the V15 migration to add email templates system.