Phinx Migrations

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.

Good developers always version their code using a SCM system, so why don’t theydo the same for their database schema?

Phinx was developed with the following goals in mind:

• Be portable amongst the most popular database vendors.
• Be PHP framework independent.
• Have a simple install process.
• Have an easy to use command-line operation.
• Integrate with various other PHP tools (Phing, PHPUnit) and web frameworks.

Phinx should be installed using Composer, which is a tool for dependencymanagement in PHP. Please visit the Composerwebsite for more information.

Phinx requires at least PHP 5.4 (or later).

To install Phinx, simply require it using Composer:

Phinx can now be executed from within your project:

vendor/bin/phinx init

• • Creating a New Migration
  • Inserting Data
  • Working With Columns
  • Working With Foreign Keys
• • Creating a New Seed Class
  • Inserting Data
  • Executing Seed Classes
• • Migration Paths
  • Seed Paths
  • Table Prefix and Suffix
  • External Variables
  • Aliases