cakephp/phinx
### [`v0.14.0`](https://togithub.com/cakephp/phinx/releases/tag/0.14.0)
[Compare Source](https://togithub.com/cakephp/phinx/compare/0.13.4...0.14.0)
#### What's Changed
- Require php-64bit to install phinx by [@MasterOdin](https://togithub.com/MasterOdin) in [https://github.com/cakephp/phinx/pull/2169](https://togithub.com/cakephp/phinx/pull/2169)
- Update license copyright to CakePHP Software Foundation by [@MasterOdin](https://togithub.com/MasterOdin) in [https://github.com/cakephp/phinx/pull/2170](https://togithub.com/cakephp/phinx/pull/2170)
- Fix recreating indices for renamed/removed columns. by [@ndm2](https://togithub.com/ndm2) in [https://github.com/cakephp/phinx/pull/2134](https://togithub.com/cakephp/phinx/pull/2134)
- Refactor foreign keys switching. by [@ndm2](https://togithub.com/ndm2) in [https://github.com/cakephp/phinx/pull/2171](https://togithub.com/cakephp/phinx/pull/2171)
- Min PHP 7.3 by [@dereuromark](https://togithub.com/dereuromark) in [https://github.com/cakephp/phinx/pull/2167](https://togithub.com/cakephp/phinx/pull/2167)
- Fix blank line above declare statement, see PSR-12 by [@chrisblech](https://togithub.com/chrisblech) in [https://github.com/cakephp/phinx/pull/2175](https://togithub.com/cakephp/phinx/pull/2175)
- update phinx link by [@Arhell](https://togithub.com/Arhell) in [https://github.com/cakephp/phinx/pull/2177](https://togithub.com/cakephp/phinx/pull/2177)
- Add existing comment to column object for mysql by [@alex-jonas](https://togithub.com/alex-jonas) in [https://github.com/cakephp/phinx/pull/2174](https://togithub.com/cakephp/phinx/pull/2174)
- Update phinxlog as part of migration transaction by [@JRDuncan](https://togithub.com/JRDuncan) in [https://github.com/cakephp/phinx/pull/2181](https://togithub.com/cakephp/phinx/pull/2181)
- Fix missing quoting on constraints name for sqlserver by [@algorhythm](https://togithub.com/algorhythm) in [https://github.com/cakephp/phinx/pull/2186](https://togithub.com/cakephp/phinx/pull/2186)
- Make check for CURRENT_TIMESTAMP in default value case insensitive by [@vuyiswankosi](https://togithub.com/vuyiswankosi) in [https://github.com/cakephp/phinx/pull/2190](https://togithub.com/cakephp/phinx/pull/2190)
- Cache created decorated connection by [@MasterOdin](https://togithub.com/MasterOdin) in [https://github.com/cakephp/phinx/pull/2191](https://togithub.com/cakephp/phinx/pull/2191)
- Fix grammar in exception message by [@cnizzardini](https://togithub.com/cnizzardini) in [https://github.com/cakephp/phinx/pull/2203](https://togithub.com/cakephp/phinx/pull/2203)
- Add note about MyISAM length limitation by [@naidim](https://togithub.com/naidim) in [https://github.com/cakephp/phinx/pull/2204](https://togithub.com/cakephp/phinx/pull/2204)
- Clarify where feature flags are in configuration file with a YAML example by [@SteenSchutt](https://togithub.com/SteenSchutt) in [https://github.com/cakephp/phinx/pull/2206](https://togithub.com/cakephp/phinx/pull/2206)
- Fix PostgresAdapter not returning limit for char and varchar by [@roblperry](https://togithub.com/roblperry) in [https://github.com/cakephp/phinx/pull/2214](https://togithub.com/cakephp/phinx/pull/2214)
- Fix 2193 Postgres GENERATED ALWAYS by [@captain-redbeard](https://togithub.com/captain-redbeard) in [https://github.com/cakephp/phinx/pull/2195](https://togithub.com/cakephp/phinx/pull/2195)
#### New Contributors
- [@chrisblech](https://togithub.com/chrisblech) made their first contribution in [https://github.com/cakephp/phinx/pull/2175](https://togithub.com/cakephp/phinx/pull/2175)
- [@alex-jonas](https://togithub.com/alex-jonas) made their first contribution in [https://github.com/cakephp/phinx/pull/2174](https://togithub.com/cakephp/phinx/pull/2174)
- [@algorhythm](https://togithub.com/algorhythm) made their first contribution in [https://github.com/cakephp/phinx/pull/2186](https://togithub.com/cakephp/phinx/pull/2186)
- [@vuyiswankosi](https://togithub.com/vuyiswankosi) made their first contribution in [https://github.com/cakephp/phinx/pull/2190](https://togithub.com/cakephp/phinx/pull/2190)
- [@naidim](https://togithub.com/naidim) made their first contribution in [https://github.com/cakephp/phinx/pull/2204](https://togithub.com/cakephp/phinx/pull/2204)
- [@SteenSchutt](https://togithub.com/SteenSchutt) made their first contribution in [https://github.com/cakephp/phinx/pull/2206](https://togithub.com/cakephp/phinx/pull/2206)
- [@roblperry](https://togithub.com/roblperry) made their first contribution in [https://github.com/cakephp/phinx/pull/2214](https://togithub.com/cakephp/phinx/pull/2214)
- [@captain-redbeard](https://togithub.com/captain-redbeard) made their first contribution in [https://github.com/cakephp/phinx/pull/2195](https://togithub.com/cakephp/phinx/pull/2195)
**Full Changelog**: https://github.com/cakephp/phinx/compare/0.13.4...0.14.0
### [`v0.13.4`](https://togithub.com/cakephp/phinx/releases/tag/0.13.4)
[Compare Source](https://togithub.com/cakephp/phinx/compare/0.13.3...0.13.4)
#### Feature Flags
This release adds [feature flags](https://book.cakephp.org/phinx/0/en/configuration.html#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`](https://togithub.com/cakephp/phinx/releases/tag/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](https://togithub.com/ndm2) in [https://github.com/cakephp/phinx/pull/2156](https://togithub.com/cakephp/phinx/pull/2156)
- Restored migration template method return types by [@Bilge](https://togithub.com/Bilge) in [https://github.com/cakephp/phinx/pull/2160](https://togithub.com/cakephp/phinx/pull/2160)
- Fix foreign key constraint violations on implicit table drops by [@ndm2](https://togithub.com/ndm2) in [https://github.com/cakephp/phinx/pull/2131](https://togithub.com/cakephp/phinx/pull/2131)
- Add feature flags to disable some 0.13.0 breaking changes by [@MasterOdin](https://togithub.com/MasterOdin) in [https://github.com/cakephp/phinx/pull/2159](https://togithub.com/cakephp/phinx/pull/2159)
- Changed breakpoint column to disallow nulls again by [@Bilge](https://togithub.com/Bilge) in [https://github.com/cakephp/phinx/pull/2162](https://togithub.com/cakephp/phinx/pull/2162)
**Full Changelog**: https://github.com/cakephp/phinx/compare/0.13.3...0.13.4
### [`v0.13.3`](https://togithub.com/cakephp/phinx/releases/tag/0.13.3)
[Compare Source](https://togithub.com/cakephp/phinx/compare/0.13.2...0.13.3)
##### Fixes
- Fix string to int return type by [@dereuromark](https://togithub.com/dereuromark) in [https://github.com/cakephp/phinx/pull/2150](https://togithub.com/cakephp/phinx/pull/2150)
- Fix rolling back columns with indices for SQLite and SQL Server by [@ndm2](https://togithub.com/ndm2) in [https://github.com/cakephp/phinx/pull/2128](https://togithub.com/cakephp/phinx/pull/2128)
- Add testcases for Util::getVersionFromFileName function by [@MasterOdin](https://togithub.com/MasterOdin) in [https://github.com/cakephp/phinx/pull/2153](https://togithub.com/cakephp/phinx/pull/2153)
- Fix reference to MysqlAdapter::FIRST constant in migrations doc by [@niekatywny](https://togithub.com/niekatywny) in [https://github.com/cakephp/phinx/pull/2143](https://togithub.com/cakephp/phinx/pull/2143)
**Full Changelog**: https://github.com/cakephp/phinx/compare/0.13.2...0.13.3
### [`v0.13.2`](https://togithub.com/cakephp/phinx/releases/tag/0.13.2)
[Compare Source](https://togithub.com/cakephp/phinx/compare/0.13.1...0.13.2)
##### Fixes
- Maintain indexes / triggers after altering sqlite tables by [@MasterOdin](https://togithub.com/MasterOdin) in [https://github.com/cakephp/phinx/pull/2040](https://togithub.com/cakephp/phinx/pull/2040)
- Fix documentation seeder_base_class configuration by [@N-Silbernagel](https://togithub.com/N-Silbernagel) in [https://github.com/cakephp/phinx/pull/2124](https://togithub.com/cakephp/phinx/pull/2124)
- Fix deprecated ${} string interpolation by [@rigrig](https://togithub.com/rigrig) in [https://github.com/cakephp/phinx/pull/2133](https://togithub.com/cakephp/phinx/pull/2133)
- Fix enum by [@dereuromark](https://togithub.com/dereuromark) in [https://github.com/cakephp/phinx/pull/2140](https://togithub.com/cakephp/phinx/pull/2140)
##### New Contributors
- [@Arhell](https://togithub.com/Arhell) made their first contribution in [https://github.com/cakephp/phinx/pull/2120](https://togithub.com/cakephp/phinx/pull/2120)
- [@N-Silbernagel](https://togithub.com/N-Silbernagel) made their first contribution in [https://github.com/cakephp/phinx/pull/2124](https://togithub.com/cakephp/phinx/pull/2124)
- [@rigrig](https://togithub.com/rigrig) made their first contribution in [https://github.com/cakephp/phinx/pull/2133](https://togithub.com/cakephp/phinx/pull/2133)
- [@nono-lqdn](https://togithub.com/nono-lqdn) made their first contribution in [https://github.com/cakephp/phinx/pull/2137](https://togithub.com/cakephp/phinx/pull/2137)
**Full Changelog**: https://github.com/cakephp/phinx/compare/0.13.1...0.13.2
### [`v0.13.1`](https://togithub.com/cakephp/phinx/releases/tag/0.13.1)
[Compare Source](https://togithub.com/cakephp/phinx/compare/0.13.0...0.13.1)
##### Fixes
- Fix target being set to `0` if omitted when running migrate by [@nrob81](https://togithub.com/nrob81) in [#2115](https://togithub.com/cakephp/phinx/issues/2115)
- Fix deprecation warning on return value for `Config::offsetGet` by [@MasterOdin](https://togithub.com/MasterOdin) in [#2117](https://togithub.com/cakephp/phinx/issues/2117)
**Full Changelog**: https://github.com/cakephp/phinx/compare/0.13.0...0.13.1
### [`v0.13.0`](https://togithub.com/cakephp/phinx/releases/tag/0.13.0)
[Compare Source](https://togithub.com/cakephp/phinx/compare/0.12.13...0.13.0)
#### Breaking Changes
- set column null by default unless identity by [@MasterOdin](https://togithub.com/MasterOdin) in [#1872](https://togithub.com/cakephp/phinx/issues/1872). Previously columns were created as `NOT NULL` by default, and to now get that behavior, you will need to explicitly pass `'null' => false` in the column options.
- remove remove `$direction` argument to `preFlightCheck` and `postFlightCheck` (use `isMigratingUp` property) by [@MasterOdin](https://togithub.com/MasterOdin) in [#1892](https://togithub.com/cakephp/phinx/issues/1892)
- make `utf8mb4` default charset and collation for new mysql tables by [@MasterOdin](https://togithub.com/MasterOdin) in [#1875](https://togithub.com/cakephp/phinx/issues/1875) (Set `charset` and `collation` setting in phinx.php to `utf8mb3` for prior behavior)
- make default PKs for mysql unsigned by default by [@MasterOdin](https://togithub.com/MasterOdin) in [#1899](https://togithub.com/cakephp/phinx/issues/1899). When defining foreign keys, you will need to now need to set `$signed => false`. To restore prior behavior, pass `$signed => true` when defining the default PK.
- Add type hints to codebase by [@MasterOdin](https://togithub.com/MasterOdin) in [#1995](https://togithub.com/cakephp/phinx/issues/1995) (This does not affect the `up`, `down`, or `change` methods for `AbstractMigration`. If you extend from phinx, you will need to add type hinting to your code)
- remove deprecated hasSchemaTable function from `AdapterInterface` by [@MasterOdin](https://togithub.com/MasterOdin) in [#1877](https://togithub.com/cakephp/phinx/issues/1877)
- remove deprecated `insert`, `dropTable` methods from `MigrationInterface` by [@MasterOdin](https://togithub.com/MasterOdin) in [#1878](https://togithub.com/cakephp/phinx/issues/1878)
- Do not set code when recasting PDOException when connecting to DB by [@MasterOdin](https://togithub.com/MasterOdin) in [#2101](https://togithub.com/cakephp/phinx/issues/2101)
- Implement identity in `PostgresAdapter` by [@ajibarra](https://togithub.com/ajibarra) in [#2085](https://togithub.com/cakephp/phinx/issues/2085) (identity columns for postgres 10+ will now be generated as `INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY` instead of `SERIAL NOT NULL`)
#### Deprecations
- Deprecate the `default_migration_table` config setting, use `migration_table` instead by [@MasterOdin](https://togithub.com/MasterOdin) in [#1961](https://togithub.com/cakephp/phinx/issues/1961)
#### New Features
- add createSchema and dropSchema methods on MigrationInterface by [@MasterOdin](https://togithub.com/MasterOdin) in [#1871](https://togithub.com/cakephp/phinx/issues/1871)
#### Improvements
- remove check on column type for setting collation / encoding by [@Masterodin](https://togithub.com/Masterodin) in [#1881](https://togithub.com/cakephp/phinx/issues/1881)
- trigger deprecation notice when using default_database by [@MasterOdin](https://togithub.com/MasterOdin) in [#1890](https://togithub.com/cakephp/phinx/issues/1890) (function had been marked as deprecated in 0.12.0)
- add support for smallserial alias for postgres by [@MasterOdin](https://togithub.com/MasterOdin) in [#1915](https://togithub.com/cakephp/phinx/issues/1915) (note, using `smallinteger` on an identity column will now use the type `smallserial`)
- allow setting migration_table per environment by [@MasterOdin](https://togithub.com/MasterOdin) in [#1961](https://togithub.com/cakephp/phinx/issues/1961)
- Add new `shouldExecute` method to `AbstractMigration` and `AbstractSeed` by [@AdrienPoupa](https://togithub.com/AdrienPoupa) in [#1939](https://togithub.com/cakephp/phinx/issues/1939)
- Add for geometry column type to `SqlServerAdapter` by [@tedce](https://togithub.com/tedce) in [#1969](https://togithub.com/cakephp/phinx/issues/1969)
- Add optional `$params` argument to query/execute adapter methods to allow usage of prepared queries by [@MasterOdin](https://togithub.com/MasterOdin) in [#1962](https://togithub.com/cakephp/phinx/issues/1962)
- Allow specifying template style for create command by [@MasterOdin](https://togithub.com/MasterOdin) in [#2013](https://togithub.com/cakephp/phinx/issues/2013) (note, the name of the base migration file has changed, argument has changed for `AbstractCommand::getMigrationTemplateFilename`)
- Improve associative array phpdocs by [@dereuromark](https://togithub.com/dereuromark) in [#2034](https://togithub.com/cakephp/phinx/issues/2034)
- Pass environment to seed from manager by [@martenb](https://togithub.com/martenb) in [#2102](https://togithub.com/cakephp/phinx/issues/2102) (note, parameter change to `Manager::getSeeds` method)
**Full Changelog**: https://github.com/cakephp/phinx/compare/0.12.13...0.13.0
Configuration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
[ ] If you want to rebase/retry this PR, click this checkbox.
This PR contains the following updates:
^0.12.3
->^0.14.0
Release Notes
cakephp/phinx
### [`v0.14.0`](https://togithub.com/cakephp/phinx/releases/tag/0.14.0) [Compare Source](https://togithub.com/cakephp/phinx/compare/0.13.4...0.14.0) #### What's Changed - Require php-64bit to install phinx by [@MasterOdin](https://togithub.com/MasterOdin) in [https://github.com/cakephp/phinx/pull/2169](https://togithub.com/cakephp/phinx/pull/2169) - Update license copyright to CakePHP Software Foundation by [@MasterOdin](https://togithub.com/MasterOdin) in [https://github.com/cakephp/phinx/pull/2170](https://togithub.com/cakephp/phinx/pull/2170) - Fix recreating indices for renamed/removed columns. by [@ndm2](https://togithub.com/ndm2) in [https://github.com/cakephp/phinx/pull/2134](https://togithub.com/cakephp/phinx/pull/2134) - Refactor foreign keys switching. by [@ndm2](https://togithub.com/ndm2) in [https://github.com/cakephp/phinx/pull/2171](https://togithub.com/cakephp/phinx/pull/2171) - Min PHP 7.3 by [@dereuromark](https://togithub.com/dereuromark) in [https://github.com/cakephp/phinx/pull/2167](https://togithub.com/cakephp/phinx/pull/2167) - Fix blank line above declare statement, see PSR-12 by [@chrisblech](https://togithub.com/chrisblech) in [https://github.com/cakephp/phinx/pull/2175](https://togithub.com/cakephp/phinx/pull/2175) - update phinx link by [@Arhell](https://togithub.com/Arhell) in [https://github.com/cakephp/phinx/pull/2177](https://togithub.com/cakephp/phinx/pull/2177) - Add existing comment to column object for mysql by [@alex-jonas](https://togithub.com/alex-jonas) in [https://github.com/cakephp/phinx/pull/2174](https://togithub.com/cakephp/phinx/pull/2174) - Update phinxlog as part of migration transaction by [@JRDuncan](https://togithub.com/JRDuncan) in [https://github.com/cakephp/phinx/pull/2181](https://togithub.com/cakephp/phinx/pull/2181) - Fix missing quoting on constraints name for sqlserver by [@algorhythm](https://togithub.com/algorhythm) in [https://github.com/cakephp/phinx/pull/2186](https://togithub.com/cakephp/phinx/pull/2186) - Make check for CURRENT_TIMESTAMP in default value case insensitive by [@vuyiswankosi](https://togithub.com/vuyiswankosi) in [https://github.com/cakephp/phinx/pull/2190](https://togithub.com/cakephp/phinx/pull/2190) - Cache created decorated connection by [@MasterOdin](https://togithub.com/MasterOdin) in [https://github.com/cakephp/phinx/pull/2191](https://togithub.com/cakephp/phinx/pull/2191) - Fix grammar in exception message by [@cnizzardini](https://togithub.com/cnizzardini) in [https://github.com/cakephp/phinx/pull/2203](https://togithub.com/cakephp/phinx/pull/2203) - Add note about MyISAM length limitation by [@naidim](https://togithub.com/naidim) in [https://github.com/cakephp/phinx/pull/2204](https://togithub.com/cakephp/phinx/pull/2204) - Clarify where feature flags are in configuration file with a YAML example by [@SteenSchutt](https://togithub.com/SteenSchutt) in [https://github.com/cakephp/phinx/pull/2206](https://togithub.com/cakephp/phinx/pull/2206) - Fix PostgresAdapter not returning limit for char and varchar by [@roblperry](https://togithub.com/roblperry) in [https://github.com/cakephp/phinx/pull/2214](https://togithub.com/cakephp/phinx/pull/2214) - Fix 2193 Postgres GENERATED ALWAYS by [@captain-redbeard](https://togithub.com/captain-redbeard) in [https://github.com/cakephp/phinx/pull/2195](https://togithub.com/cakephp/phinx/pull/2195) #### New Contributors - [@chrisblech](https://togithub.com/chrisblech) made their first contribution in [https://github.com/cakephp/phinx/pull/2175](https://togithub.com/cakephp/phinx/pull/2175) - [@alex-jonas](https://togithub.com/alex-jonas) made their first contribution in [https://github.com/cakephp/phinx/pull/2174](https://togithub.com/cakephp/phinx/pull/2174) - [@algorhythm](https://togithub.com/algorhythm) made their first contribution in [https://github.com/cakephp/phinx/pull/2186](https://togithub.com/cakephp/phinx/pull/2186) - [@vuyiswankosi](https://togithub.com/vuyiswankosi) made their first contribution in [https://github.com/cakephp/phinx/pull/2190](https://togithub.com/cakephp/phinx/pull/2190) - [@naidim](https://togithub.com/naidim) made their first contribution in [https://github.com/cakephp/phinx/pull/2204](https://togithub.com/cakephp/phinx/pull/2204) - [@SteenSchutt](https://togithub.com/SteenSchutt) made their first contribution in [https://github.com/cakephp/phinx/pull/2206](https://togithub.com/cakephp/phinx/pull/2206) - [@roblperry](https://togithub.com/roblperry) made their first contribution in [https://github.com/cakephp/phinx/pull/2214](https://togithub.com/cakephp/phinx/pull/2214) - [@captain-redbeard](https://togithub.com/captain-redbeard) made their first contribution in [https://github.com/cakephp/phinx/pull/2195](https://togithub.com/cakephp/phinx/pull/2195) **Full Changelog**: https://github.com/cakephp/phinx/compare/0.13.4...0.14.0 ### [`v0.13.4`](https://togithub.com/cakephp/phinx/releases/tag/0.13.4) [Compare Source](https://togithub.com/cakephp/phinx/compare/0.13.3...0.13.4) #### Feature Flags This release adds [feature flags](https://book.cakephp.org/phinx/0/en/configuration.html#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`](https://togithub.com/cakephp/phinx/releases/tag/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](https://togithub.com/ndm2) in [https://github.com/cakephp/phinx/pull/2156](https://togithub.com/cakephp/phinx/pull/2156) - Restored migration template method return types by [@Bilge](https://togithub.com/Bilge) in [https://github.com/cakephp/phinx/pull/2160](https://togithub.com/cakephp/phinx/pull/2160) - Fix foreign key constraint violations on implicit table drops by [@ndm2](https://togithub.com/ndm2) in [https://github.com/cakephp/phinx/pull/2131](https://togithub.com/cakephp/phinx/pull/2131) - Add feature flags to disable some 0.13.0 breaking changes by [@MasterOdin](https://togithub.com/MasterOdin) in [https://github.com/cakephp/phinx/pull/2159](https://togithub.com/cakephp/phinx/pull/2159) - Changed breakpoint column to disallow nulls again by [@Bilge](https://togithub.com/Bilge) in [https://github.com/cakephp/phinx/pull/2162](https://togithub.com/cakephp/phinx/pull/2162) **Full Changelog**: https://github.com/cakephp/phinx/compare/0.13.3...0.13.4 ### [`v0.13.3`](https://togithub.com/cakephp/phinx/releases/tag/0.13.3) [Compare Source](https://togithub.com/cakephp/phinx/compare/0.13.2...0.13.3) ##### Fixes - Fix string to int return type by [@dereuromark](https://togithub.com/dereuromark) in [https://github.com/cakephp/phinx/pull/2150](https://togithub.com/cakephp/phinx/pull/2150) - Fix rolling back columns with indices for SQLite and SQL Server by [@ndm2](https://togithub.com/ndm2) in [https://github.com/cakephp/phinx/pull/2128](https://togithub.com/cakephp/phinx/pull/2128) - Add testcases for Util::getVersionFromFileName function by [@MasterOdin](https://togithub.com/MasterOdin) in [https://github.com/cakephp/phinx/pull/2153](https://togithub.com/cakephp/phinx/pull/2153) - Fix reference to MysqlAdapter::FIRST constant in migrations doc by [@niekatywny](https://togithub.com/niekatywny) in [https://github.com/cakephp/phinx/pull/2143](https://togithub.com/cakephp/phinx/pull/2143) **Full Changelog**: https://github.com/cakephp/phinx/compare/0.13.2...0.13.3 ### [`v0.13.2`](https://togithub.com/cakephp/phinx/releases/tag/0.13.2) [Compare Source](https://togithub.com/cakephp/phinx/compare/0.13.1...0.13.2) ##### Fixes - Maintain indexes / triggers after altering sqlite tables by [@MasterOdin](https://togithub.com/MasterOdin) in [https://github.com/cakephp/phinx/pull/2040](https://togithub.com/cakephp/phinx/pull/2040) - Fix documentation seeder_base_class configuration by [@N-Silbernagel](https://togithub.com/N-Silbernagel) in [https://github.com/cakephp/phinx/pull/2124](https://togithub.com/cakephp/phinx/pull/2124) - Fix deprecated ${} string interpolation by [@rigrig](https://togithub.com/rigrig) in [https://github.com/cakephp/phinx/pull/2133](https://togithub.com/cakephp/phinx/pull/2133) - Fix enum by [@dereuromark](https://togithub.com/dereuromark) in [https://github.com/cakephp/phinx/pull/2140](https://togithub.com/cakephp/phinx/pull/2140) ##### New Contributors - [@Arhell](https://togithub.com/Arhell) made their first contribution in [https://github.com/cakephp/phinx/pull/2120](https://togithub.com/cakephp/phinx/pull/2120) - [@N-Silbernagel](https://togithub.com/N-Silbernagel) made their first contribution in [https://github.com/cakephp/phinx/pull/2124](https://togithub.com/cakephp/phinx/pull/2124) - [@rigrig](https://togithub.com/rigrig) made their first contribution in [https://github.com/cakephp/phinx/pull/2133](https://togithub.com/cakephp/phinx/pull/2133) - [@nono-lqdn](https://togithub.com/nono-lqdn) made their first contribution in [https://github.com/cakephp/phinx/pull/2137](https://togithub.com/cakephp/phinx/pull/2137) **Full Changelog**: https://github.com/cakephp/phinx/compare/0.13.1...0.13.2 ### [`v0.13.1`](https://togithub.com/cakephp/phinx/releases/tag/0.13.1) [Compare Source](https://togithub.com/cakephp/phinx/compare/0.13.0...0.13.1) ##### Fixes - Fix target being set to `0` if omitted when running migrate by [@nrob81](https://togithub.com/nrob81) in [#2115](https://togithub.com/cakephp/phinx/issues/2115) - Fix deprecation warning on return value for `Config::offsetGet` by [@MasterOdin](https://togithub.com/MasterOdin) in [#2117](https://togithub.com/cakephp/phinx/issues/2117) **Full Changelog**: https://github.com/cakephp/phinx/compare/0.13.0...0.13.1 ### [`v0.13.0`](https://togithub.com/cakephp/phinx/releases/tag/0.13.0) [Compare Source](https://togithub.com/cakephp/phinx/compare/0.12.13...0.13.0) #### Breaking Changes - set column null by default unless identity by [@MasterOdin](https://togithub.com/MasterOdin) in [#1872](https://togithub.com/cakephp/phinx/issues/1872). Previously columns were created as `NOT NULL` by default, and to now get that behavior, you will need to explicitly pass `'null' => false` in the column options. - remove remove `$direction` argument to `preFlightCheck` and `postFlightCheck` (use `isMigratingUp` property) by [@MasterOdin](https://togithub.com/MasterOdin) in [#1892](https://togithub.com/cakephp/phinx/issues/1892) - make `utf8mb4` default charset and collation for new mysql tables by [@MasterOdin](https://togithub.com/MasterOdin) in [#1875](https://togithub.com/cakephp/phinx/issues/1875) (Set `charset` and `collation` setting in phinx.php to `utf8mb3` for prior behavior) - make default PKs for mysql unsigned by default by [@MasterOdin](https://togithub.com/MasterOdin) in [#1899](https://togithub.com/cakephp/phinx/issues/1899). When defining foreign keys, you will need to now need to set `$signed => false`. To restore prior behavior, pass `$signed => true` when defining the default PK. - Add type hints to codebase by [@MasterOdin](https://togithub.com/MasterOdin) in [#1995](https://togithub.com/cakephp/phinx/issues/1995) (This does not affect the `up`, `down`, or `change` methods for `AbstractMigration`. If you extend from phinx, you will need to add type hinting to your code) - remove deprecated hasSchemaTable function from `AdapterInterface` by [@MasterOdin](https://togithub.com/MasterOdin) in [#1877](https://togithub.com/cakephp/phinx/issues/1877) - remove deprecated `insert`, `dropTable` methods from `MigrationInterface` by [@MasterOdin](https://togithub.com/MasterOdin) in [#1878](https://togithub.com/cakephp/phinx/issues/1878) - Do not set code when recasting PDOException when connecting to DB by [@MasterOdin](https://togithub.com/MasterOdin) in [#2101](https://togithub.com/cakephp/phinx/issues/2101) - Implement identity in `PostgresAdapter` by [@ajibarra](https://togithub.com/ajibarra) in [#2085](https://togithub.com/cakephp/phinx/issues/2085) (identity columns for postgres 10+ will now be generated as `INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY` instead of `SERIAL NOT NULL`) #### Deprecations - Deprecate the `default_migration_table` config setting, use `migration_table` instead by [@MasterOdin](https://togithub.com/MasterOdin) in [#1961](https://togithub.com/cakephp/phinx/issues/1961) #### New Features - add createSchema and dropSchema methods on MigrationInterface by [@MasterOdin](https://togithub.com/MasterOdin) in [#1871](https://togithub.com/cakephp/phinx/issues/1871) #### Improvements - remove check on column type for setting collation / encoding by [@Masterodin](https://togithub.com/Masterodin) in [#1881](https://togithub.com/cakephp/phinx/issues/1881) - trigger deprecation notice when using default_database by [@MasterOdin](https://togithub.com/MasterOdin) in [#1890](https://togithub.com/cakephp/phinx/issues/1890) (function had been marked as deprecated in 0.12.0) - add support for smallserial alias for postgres by [@MasterOdin](https://togithub.com/MasterOdin) in [#1915](https://togithub.com/cakephp/phinx/issues/1915) (note, using `smallinteger` on an identity column will now use the type `smallserial`) - allow setting migration_table per environment by [@MasterOdin](https://togithub.com/MasterOdin) in [#1961](https://togithub.com/cakephp/phinx/issues/1961) - Add new `shouldExecute` method to `AbstractMigration` and `AbstractSeed` by [@AdrienPoupa](https://togithub.com/AdrienPoupa) in [#1939](https://togithub.com/cakephp/phinx/issues/1939) - Add for geometry column type to `SqlServerAdapter` by [@tedce](https://togithub.com/tedce) in [#1969](https://togithub.com/cakephp/phinx/issues/1969) - Add optional `$params` argument to query/execute adapter methods to allow usage of prepared queries by [@MasterOdin](https://togithub.com/MasterOdin) in [#1962](https://togithub.com/cakephp/phinx/issues/1962) - Allow specifying template style for create command by [@MasterOdin](https://togithub.com/MasterOdin) in [#2013](https://togithub.com/cakephp/phinx/issues/2013) (note, the name of the base migration file has changed, argument has changed for `AbstractCommand::getMigrationTemplateFilename`) - Improve associative array phpdocs by [@dereuromark](https://togithub.com/dereuromark) in [#2034](https://togithub.com/cakephp/phinx/issues/2034) - Pass environment to seed from manager by [@martenb](https://togithub.com/martenb) in [#2102](https://togithub.com/cakephp/phinx/issues/2102) (note, parameter change to `Manager::getSeeds` method) **Full Changelog**: https://github.com/cakephp/phinx/compare/0.12.13...0.13.0Configuration
📅 Schedule: Branch creation - At any time (no schedule defined), Automerge - At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
This PR has been generated by Renovate Bot.