Phinx Documentation

Phinx makes it ridiculously easy to manage the database migrations for your PHP app. In less than 5 minutes, you can install Phinx using Composer and create your first database migration. Phinx is just about migrations without all the bloat of a database ORM system or application framework.

Phinx requires a 64-bit version of PHP to function.

Contents

• Introduction
• Goals
• Installation
• Writing Migrations
  • Creating a New Migration
  • Executing Queries
  • Fetching Rows
  • Inserting Data
  • Working With Tables
  • Working With Columns
  • Working With Indexes
  • Working With Foreign Keys
  • Using the Query Builder
• Database Seeding
  • Creating a New Seed Class
  • The AbstractSeed Class
  • Inserting Data
  • Truncating Tables
  • Executing Seed Classes
• Commands
  • The Breakpoint Command
  • The Create Command
  • The Init Command
  • The Migrate Command
  • The Rollback Command
  • The Status Command
  • The Seed Create Command
  • The Seed Run Command
  • Configuration File Parameter
  • Running Phinx in a Web App
  • Wrapping Phinx in another Symfony Console Application
  • Using Phinx with PHPUnit
• Configuration
  • Migration Paths
  • Custom Migration Base
  • Seed Paths
  • Custom Seeder Base
  • Custom Migration Template
  • Custom Seeder Template
  • Environments
  • Migration Table
  • Table Prefix and Suffix
  • Socket Connections
  • External Variables
  • Data Source Names
  • Supported Adapters
  • Templates
  • Aliases
  • Version Order
  • Bootstrap Path
  • Feature Flags
• Copyright

Indices and tables

• Index

• Module Index

• Search Page