cakephp/phinx
### [`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)
- 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+ 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)
### [`v0.12.13`](https://togithub.com/cakephp/phinx/releases/tag/0.12.13)
[Compare Source](https://togithub.com/cakephp/phinx/compare/0.12.12...0.12.13)
##### Fixes
- Fix defaultName deprecation warning on symfony/console 6.1 by [@MasterOdin](https://togithub.com/MasterOdin) in [#2107](https://togithub.com/cakephp/phinx/pull/2107)
**Full Changelog**: https://github.com/cakephp/phinx/compare/0.12.12...0.12.13
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.13.0
Release Notes
cakephp/phinx
### [`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) - 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+ 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) ### [`v0.12.13`](https://togithub.com/cakephp/phinx/releases/tag/0.12.13) [Compare Source](https://togithub.com/cakephp/phinx/compare/0.12.12...0.12.13) ##### Fixes - Fix defaultName deprecation warning on symfony/console 6.1 by [@MasterOdin](https://togithub.com/MasterOdin) in [#2107](https://togithub.com/cakephp/phinx/pull/2107) **Full Changelog**: https://github.com/cakephp/phinx/compare/0.12.12...0.12.13Configuration
š 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.