5.2.3

What's Changed

• Auto-generate check constraint name when name is empty by @dereuromark in #1098

Full Changelog: 5.2.2...5.2.3

5.2.2

Fixes

• Do not auto-increment composite primary key columns in bake migration. Baking a join-table migration with a composite integer primary key (e.g. article_id:integer:primary tag_id:integer:primary) generated autoIncrement on both columns, which MySQL rejects. Now autoIncrement is only emitted for a single integer primary key. (#1095)

Full Changelog: 5.2.1...5.2.2

5.2.1

Fixes

• Quote the constraint name in the MySQL DROP FOREIGN KEY statement. Names that are not bare identifiers previously produced invalid SQL — whitespace in a name (cakephp/phinx#924) or numeric names auto-assigned by MariaDB 12.x (DROP FOREIGN KEY 1) would fail with a syntax error. The identifier is now quoted via quoteColumnName(), matching the Postgres and SQL Server adapters.

Full Changelog: 5.2.0...5.2.1

5.2.0

Improvements

• Add an --all flag to the migrations status command (#1076)
• Add citext column type support for PostgreSQL (#1069)
• Add support for PostgreSQL index access methods: gist, spgist, brin, hash (#1053)

Full Changelog: 5.1.1...5.2.0

Migrations 4.9.7

This release fixes a problem related to changes introduced in Phinx 0.16.11.

ℹ️ If you are on CakePHP 5.3+ we HIGHLY recommend you upgrade to Migrations v5. Go to https://book.cakephp.org/migrations/5/upgrades/upgrading-from-4-x.html to learn what has changed and what you need to do, to get it working ℹ️

What's Changed

• pin phinx to 0.16.10 as 0.16.11 contains breaking changes by @LordSimal in #1078

Full Changelog: 4.9.6...4.9.7

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