0.16.0

Breaking Changes

• Validate datetime for version by @dereuromark in #2249
  When using AbstratMigration class, when it's instantiated, the version will be validated that it is 14 characters (YYYYMMDDHHmmSS). A future version may strengthen this to validate that it's a valid datetime. To get prior behavior, will need to extend the AbstractMigration class and either override the constructor or the new validateVersion method.
• Fix inconsistencies with hasPrimaryKey by @DrewKolstad in #2228
  Previously hasPrimaryKey would return inconsistently if the passed array of columns was a subset/superset of actual primary keys. This function should now only return true iff the passed array of columns strictly matches the actual list of primary key columns (same length and values). Postgres and SQLServer are case sensitive, while MySQL and SQLite are case insensitive.

Fixes

• Fix setting faked migrations as migrated by @MasterOdin in #2252
• Fix for MySQL 8 DEFAULT_GENERATED extra by @cergfix in #2253
• Fix fatal errors when calling get methods by @markstory in #2257
• Fix using literal type with add column by @ndm2 in #2255
• Make Abstract{Migration,Seed}::getAdapter return non-null by @MasterOdin in #2261

Docs

• Reword null option description by @MasterOdin in #2262

Misc

• Bump actions/cache from 3 to 4 by @dependabot in #2260

New Contributors

• @DrewKolstad made their first contribution in #2228
• @cergfix made their first contribution in #2253

Full Changelog: 0.15.5...0.16.0

0.15.5

What's Changed

• Introduce getQueryBuilder aliases for specific database actions by @wallacio in #2242
• Add Symfony 7 support by @Slamdunk in #2246

New Contributors

• @Slamdunk made their first contribution in #2246

Full Changelog: 0.15.4...0.15.5

0.15.4

Fixes

• Correct type for migrate target option by @wallacio in #2241
• Fix up UUID binary16 support for Sqlite by @dereuromark in #2239

Note: Columns created in Sqlite before 0.15.4 using the PdoAdapter::PHINX_TYPE_BINARYUUID type were binary_blob. In 0.15.4 they were changed to be type uuid_blob. If you rely on this constant, you will need to manually update the types of any columns using PdoAdapter::PHINX_TYPE_BINARYUUID to the new value.

Note: binary(16) support for Sqlite inside CakePHP requires v5.0.3+.

New Contributors

• @wallacio made their first contribution in #2241

Full Changelog: 0.15.3...0.15.4

0.15.3

Fixes

• Fix using test command when manually setting config by @MasterOdin in #2235
• Fix default to null for type of column in addColumn by @gaydamakha in #2236
• Loosen psr/container version constraint by @MasterOdin in #2237

Docs

• Update minimum PHP version in docs by @coderanger in #2232

New Contributors

• @coderanger made their first contribution in #2232
• @gaydamakha made their first contribution in #2236

Full Changelog: 0.15.2...0.15.3

0.15.2

Fixes

• Allow Table::addColumn() to use type from Column object again by @othercorey in #2224

Full Changelog: 0.15.1...0.15.2

0.15.1

Fixes

• Ensure PostgresAdapter::useIdentity is always initialized by @othercorey in #2223

Full Changelog: 0.15.0...0.15.1

0.15.0

Note: The 2.0.0, 2.0.1, and 2.0.2 tags were created incorrectly, and have been deleted and will be removed from packagist. This release features all of the same features and changes that was in those releases. We are still using 0.x releases as the API is not yet considered stable, as evidenced by the breaking change below.

Breaking Changes

PHP 8.1 / Type declarations

This release requires PHP 8.1 or greater to be installed to use Phinx. As part of this, a number of type declarations were changed throughout Phinx to take advantage of the expanded syntax allowed by PHP 8.1. See #2218 for all the files affected.

For users that overwrite $autoId in their migration class, this will now need a bool type declaration:

public bool $autoId = false;

Foreign Key Handling

In previous versions, Phinx was inconsistent with how it handled foreign keys across the adapters. Per #2212, here is the old and new behaviors:

Currently the behavior looks like this:

	MySQL	Postgres	Sqlite	SQL Server
Case-sensitive drop	no	yes	yes	no¹
Case-sensitive lookup	yes	yes	no	yes¹
Multi-column drop	no²	yes	no³	no²
Drop all column matches	yes	yes	no	yes
Column order dependent drop	no	no	no	no
Column order dependent lookup	yes	no	no	no
Silently drop non-existent by columns	no	yes	no	yes
Silently drop non-existent by name	no	no	-	no

^{1) In a case sensitive database the query would produce an error.
2) Generates duplicate drop instructions, one for every key that has any of the given columns.
3) For every column, the first key that starts with that column would be deleted.}

With these changes, the new behavior would be as follows:

	MySQL	Postgres	Sqlite	SQL Server
Case-sensitive drop	no	yes¹	no	yes¹
Case-sensitive lookup	no	yes¹	no	yes¹
Multi-column drop	yes	yes	yes	yes
Drop all column matches	yes	yes	yes	yes
Column order dependent drop	yes	yes	yes	yes
Column order dependent lookup	yes	yes	yes	yes
Silently drop non-existent by columns	no	no	no	no
Silently drop non-existent by name	no	no	-	no

^{1) The behavior is independent of whether the database/column is actually case-sensitive.}

Features

• Require PHP 8.1+
• Update for Cake 5 by @ADmad in #2106
• Add/improve type declarations for PHP 8.1 by @othercorey in #2218
• Unify multi-column foreign key handling by @ndm2 in #2212
• Add declare strict_types to seed template by @MasterOdin in #2220

Docs

• fix phinx link by @Arhell in #2179
• update phinx link by @Arhell in #2180
• Fix grammar in configuration doc by @Jonezzyboy in #2219

New Contributors

• @Jonezzyboy made their first contribution in #2219

Full Changelog: 0.14.0...0.15.0

0.14.0

Breaking Changes

• Require php-64bit to install phinx by @MasterOdin in #2169
• Min PHP 7.3 by @dereuromark in #2167

Fixes

• Fix recreating indices for renamed/removed columns. by @ndm2 in #2134
• Refactor foreign keys switching. by @ndm2 in #2171
• Fix blank line above declare statement, see PSR-12 by @chrisblech in #2175
• Add existing comment to column object for mysql by @alex-jonas in #2174
• Update phinxlog as part of migration transaction by @JRDuncan in #2181
• Fix missing quoting on constraints name for sqlserver by @algorhythm in #2186
• Make check for CURRENT_TIMESTAMP in default value case insensitive by @vuyiswankosi in #2190
• Cache created decorated connection by @MasterOdin in #2191
• Fix grammar in exception message by @cnizzardini in #2203
• Fix PostgresAdapter not returning limit for char and varchar by @roblperry in #2214
• Fix 2193 Postgres GENERATED ALWAYS by @captain-redbeard in #2195

Docs

• Update license copyright to CakePHP Software Foundation by @MasterOdin in #2170
• update phinx link by @Arhell in #2177
• Add note about MyISAM length limitation by @naidim in #2204
• Clarify where feature flags are in configuration file with a YAML example by @SteenSchutt in #2206

New Contributors

• @chrisblech made their first contribution in #2175
• @alex-jonas made their first contribution in #2174
• @algorhythm made their first contribution in #2186
• @vuyiswankosi made their first contribution in #2190
• @naidim made their first contribution in #2204
• @SteenSchutt made their first contribution in #2206
• @roblperry made their first contribution in #2214
• @captain-redbeard made their first contribution in #2195

Full Changelog: 0.13.4...0.14.0

0.13.4

Feature Flags

This release adds feature flags, which allows for toggling behavior of Phinx to better fit your workflow. Currently, there are two flags that opt out of breaking changes that were added in 0.13.0, namely allowing to restore behavior of having primary keys signed by default as well as making columns not null by default.

Fixes

• Fix custom column types not working anymore by @ndm2 in #2156
• Restored migration template method return types by @Bilge in #2160
• Fix foreign key constraint violations on implicit table drops by @ndm2 in #2131
• Add feature flags to disable some 0.13.0 breaking changes by @MasterOdin in #2159
• Changed breakpoint column to disallow nulls again by @Bilge in #2162

Full Changelog: 0.13.3...0.13.4

0.13.3

Fixes

• Fix string to int return type by @dereuromark in #2150
• Fix rolling back columns with indices for SQLite and SQL Server by @ndm2 in #2128
• Add testcases for Util::getVersionFromFileName function by @MasterOdin in #2153
• Fix reference to MysqlAdapter::FIRST constant in migrations doc by @niekatywny in #2143

Full Changelog: 0.13.2...0.13.3