Migrations 5.1.1

Fixes

• TestSuite\Migrator now treats cake_migrations as a migration metadata table alongside legacy *_phinxlog tables, so the unified migration ledger is reset during test cleanup instead of being left behind. (#1072)

Full Changelog: 5.1.0...5.1.1

Migrations 5.1.0

Improvements

• Add support for database views and triggers. (#957)
• Add migrations reset command. (#1051)
• Add fluent Table API for check constraints. (#1052)
• Add ALGORITHM/LOCK support to Index operations. (#1057)
• Raise PHPStan level to 8 with null safety fixes. (#1044)

Fixes

• Fix property types related to CakePHP 5.4 changes. (#1067)

Full Changelog: 5.0.4...5.1.0

Migrations 5.0.4

What's Changed

• improve error message if a migration contains the old base migration class by @LordSimal in #1059
• Fix checkSync() to only consider migrations from current context by @dereuromark in #1061

Full Changelog: 5.0.3...5.0.4

Migrations 5.0.3

What's Changed

• Filter out null fixed option from generated migrations by @dereuromark in #1048
• Stop using deprecated setOnDelete/setOnUpdate methods by @dereuromark in #1047
• Auto-generate foreign key constraint names when not provided by @dereuromark in #1041
• Add conflict resolution for auto-generated FK constraint names by @dereuromark in #1042
• Fix LONGTEXT columns becoming TEXT in generated migrations by @dereuromark in #1050

⚠️ Potential Breaking Change

Foreign Key Constraint Naming: When using addForeignKey() without an explicit constraint name, migrations now auto-generates names using the pattern {table}_{columns} instead of letting the database generate names (e.g., articles_ibfk_1 on MySQL). This provides consistent naming across all database adapters but may affect rollbacks in existing migrations that reference constraints by their old names. See the upgrade documentation for details.

Full Changelog: 5.0.2...5.0.3

Migrations 5.0.2

What's Changed

• Fix migrations upgrade with postgres which has native booleans by @nicosp in #1023
• Fix spurious warning when using empty conflictColumns with MySQL by @jamisonbryant in #1028
• add using when changing column type to json by @swiffer in #1031
• Fix TEXT column variants not round-tripping correctly by @dereuromark in #1032
• Add fixed option for binary column type by @dereuromark in #1014
• Add TYPE_BIT constant to AdapterInterface by @dereuromark in #1013
• Fix upgrade command not matching plugins with slashes by @dereuromark in #1039

Full Changelog: 5.0.1...5.0.2

Migrations 4.9.6

What's Changed

• Fix dump command error when migrations directory does not exist by @dereuromark in #1009
• Add runtime deprecation warnings for AbstractMigration and AbstractSeed by @dereuromark in #1006
• Fix column collation not applied for uuid type by @dereuromark in #1025

Full Changelog: 4.9.5...4.9.6

Migrations 5.0.1

What's Changed

• Fix dump command error when migrations directory does not exist by @dereuromark in #1009
• Remove hardcoded default collation for MySQL tables by @dereuromark in #1011
• Add upgrade warning when using legacy phinxlog tables by @dereuromark in #1016
• Track last execution time for idempotent seeds by @dereuromark in #1017

Full Changelog: 5.0.0...5.0.1

Migrations 5.0.0

Fully refactored major with zero dependencies outside CakePHP code.

Breaking Changes

• Phinx fully removed - The library no longer depends on Phinx. All functionality is now native to CakePHP Migrations.
• Requires CakePHP 5.3+
• Integer columns now default to signed - Use explicit 'signed' => false for unsigned columns
• Unified migrations table - New cake_migrations table name (auto-detects legacy phinxlog for BC)

New Features

• Seed tracking - Seeds now track execution state in cake_seeds table, preventing accidental re-runs
• Upsert operations - insertOrUpdate() and insertOrSkip() methods for seeds
• Check constraints - Add CHECK constraints to columns
• Table partitioning - MySQL and PostgreSQL partition support via partitionBy()
• MySQL ALTER optimizations - ALGORITHM and LOCK options for zero-downtime schema changes
• Default value expressions - Support for CURRENT_DATE, CURRENT_TIME, etc. as defaults
• Bake improvements - Default value syntax support in migration bake commands

API Improvements

• Short seed names - Use Users instead of UsersSeed everywhere
• Seeds as command argument - bin/cake seeds run User instead of --seed User
• --fake flag - Mark seeds as executed without running them
• Consistent use of CakePHP Database classes (Column, Index, ForeignKey)

For details see docs and migration guide.

Full Changelog: 4.9.4...5.0.0

Migrations 4.9.5

What's Changed

• Backport bug fixes from 5.x branch by @dereuromark in #1005

Full Changelog: 4.9.4...4.9.5

Migrations 4.9.4

What's Changed

• Fix small binary column creation by @markstory in #1000

Full Changelog: 4.9.3...4.9.4