cakephp/migrations 4.7.0

CakePHP Migrations 4.7.0

on GitHub

This release further integrates cakephp/database into the builtin backend. The next step is going to be a major release where the builtin backend is made the primary and only backend that migrations supports.

Behavior changes

The builtin migrations backend now uses cakephp/database for schema reflection and generation. Previously, migrations used phinx, which differ from those in cakephp/database. If you are using column types that do not exist in cakephp/database, you may need to adjust your migrations. See below for changes in each SQL dialect.

Mysql

• The set, enum, and time types are no longer supported.
• The double type is now aliased to float(52) storage. This format change reflects both double being deprecated in MySQL, and cakephp using float.
• The BLOB_REGULAR length is deprecated.
• smallint, tinyint are now mapped to integer types.
• Length attributes on integer columns are no longer preserved. cakephp/database does not support lengths on integers as MySQL 8+ ignores storage lengths on integers.
• Binary types will now be reflected as binary with length values to indicate whether they are tiny, regular, medium or long.

New features and fixes

• Add (initial) support for Dry run mode by @jamisonbryant in #867
• Fix dry-run output to stdout. by @dereuromark in #873
• Added migrate/rollback by count by @dereuromark in #874
• Decrease the amount of info being dumped when doing migrate, rollback or seed by @LordSimal in #863
• Cleanup ConsoleIO::out commands to use their named counterparts by @LordSimal in #864

New Contributors

• @jamisonbryant made their first contribution in #867

Full Changelog: 4.6.6...4.7.0