mike-sorokin/migration

Migration generator for Phinx

Migrations

Migrations Builder for Phinx., _(*1)

Currently Phinx (a migration library) cannot generate migrations automatically. Phinx "only" generates a empty class with up and down functions. You still have to write the migration manually., _(*2)

In reality, you should rarely need to write migrations manually, as the migrations library "should" generate migration classes automatically by comparing your schema mapping information (i.e. what your database should look like) with your actual current database structure., _(*3)

, _(*4)

Generated migration, _(*5)

, _(*6)

THIS IS A DEVELOPMENT PREVIEW - DO NOT USE IT IN PRODUCTION!, _(*7)

Features

• Framework independent
• DBMS: MySQL
• Database: character set, collation
• Tables: create, update, remove, engine, comment, character set, collation
• Columns: create, update, remove
• Indexes: create, remove
• Foreign keys (experimental): create, remove

Not supported

• MySQL [double] is not supported by phinx https://github.com/robmorgan/phinx/issues/498
• MySQL [year] is not supported by phinx. https://github.com/robmorgan/phinx/pull/704 | https://github.com/robmorgan/phinx/issues/551
• MySQL [bit] is not supported by phinx. https://github.com/robmorgan/phinx/pull/778
• MySQL enum values with special characters: https://github.com/robmorgan/phinx/issues/887
• Migration of contraint names (currently only auto generated): https://github.com/robmorgan/phinx/issues/823
• MySQL comments with special characters.

Installation

git clone https://github.com/odan/migrations.git
cd migrations
composer install --no-dev

Integration

composer require odan/migrations

Configuration

• Default configuration file: migrations-config.php

Example:, _(*8)

<?php

return array(
    'dsn' => 'mysql:host=127.0.0.1;dbname=test',
    'username' => 'root',
    'password' => '',
    'options' => array(
        PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
    ),
    'schema_file' => __DIR__ . '/schema.php',
    'migration_path' => __DIR__
);

Usage

Generating migrations

cd bin
php migrations.php migration:generate

Load custom config file

php migrations.php migration:generate --config=myconfig.php