v0.10.8

Bug Fixes

• [PDO & SQLite] Quoting (#1542)
• [Postgres] Fix truncate table (#1555, #1474)
• [SQLite] Fix truncate table (#1556)
• [SQLite] Fixes to index handling (#1545)
• [SQLite] Improved dropDatabase, and other minor fixes (#1533)
• [SqlServer] Fix SqlServer syntax after making precision alias of limit (#1529)

New Features

• Add double type (#1493)
• Introduce --set and --unset options for breakpoints (#1560)
• [SQLite] Implement hasPrimaryKey and hasForeignKey (#1548)
• [SQLite] New implementation of getColumns (#1554)

Other Changes

• Document that double is now a valid column type (#1527)
• Enable testing for PHP 7.3
• Typos in documentation (#1525)
• Updated documentation regarding the use of saveData() rather than save() in seeds (#1473)

v0.10.7

Bug Fixes

• Several bug fixes introduced in 0.10 related to the batching of alter table statements (#1523)
• Fixed DSN parsing (#1433)
• SQLite Adapter now respects LIMIT on CHAR typed columns (#1518)
• Fixes decimal info getColumns() (#1466)
• Prevent data insertion when passing an empty array (#1496)
• Quote column names when running CHECK command (#1444)

New Features

• Add double type (#1493)
• Add Exit Status 1 on Exception (#1462)
• Non integer primary sqlite (#1450)
• Add feature to be able to define a boostrap script (#1455)
• Add small integer support to all Mysql, SqlServer and Sqlite (#1438)
• Make removeIndex work with one column as a string (#1437)

v0.10.6

Bug Fixes

• Fixed wrong SQL used when adding new columns to a table in SQLite
• Do not output all migrations in the -vvv output when running migrations every single time.

New Features

• Ability to change the primary key and table comment
• Added Table::getColumn() method

v.0.10.5

Bug fixes

• Fixed boolean fields couldn't have default NULL
• Documentation fixes

v0.10.4

Bug Fixes

• Creating FULL TEXT indexes in MySQL is now done in separate steps, as it does not support creating multiple indexes of this type at the same time.
• Made the SQLServer adapter work again

Features

• Added the setPrecisionAndScale() method to the Column class

v0.10.3

Bug Fixes

• Fixed issues in the Postgresql adapter that would drop the wrong foreign keys when only using column names

Changes

• Hiding some debugging output when using the -v flag. The debugging output referring to the list of files visited by phinx during a migration roll out can still be viewed using -vvv

v0.10.2

Changes

• Improved the warnings when declaring both the change and any of up or down methods in a migration.
• The up() and down() methods were removed fro the MigrationInterface

Bug fixes

• Fixed issue "Dropping FK without constraint name causes unwanted dropping of PK in Postgres" (#574)
• Fixed issue in postgres when using boolean in seeds (#1038)

v0.10.1

Changes

• It is now possible to set the file extension for sqlite databases. It will no longer be forced to be .sqlite3
• Added a warning when the migration class declares both the change() method and any of up() and down as well
• Deprecated AbstractMigration::dropTable()
• Deprecated AbstractMigration::insert()

Bug Fixes

• Fixed the dropTable() method in the Migration class, it was broken in the previous release. Additionally deprecated the method as it is an alias for $this->table($table)->dropTable()->save(). Using the table method is preferred as it gives phinx the opportunity to buffer all actions and execute the at the end after validating them.

v0.10.0

This release is a major breaking change when coming from v0.9.x. Most of the user facing methods in the Migration class stay the same, some of the least used ones are gone. The internals of Phinx have been severely changed, to make room for more features and to create more efficient queries.

New Features

• Faster migrations. Phinx can now bundle changes for the same table into a single statement
• Added a Query builder for SELECT, UPDATE, INSERT and DELETE queries
• Improved schema support for Postgres
• Add support for ROW_FORMAT table option
• Added support for LIMIT for each column in an index
• Ability to specify custom column types by the use of a Literal expression
• Added JSON support for the SQLite adapter

Bugfixes

• Probably too many to list them here :)

v0.9.2

0.9.2 (Saturday, 23 December 2017)

• Pull requests
  • #1169 Apply default collation on tables as per documentation
  • #1214 Simplify multiple primary key quoting
  • #1238 Support PHPUnit 6
  • #1244 Add ordered seeds feature
  • #1246 Added saving column's comment for PostgresAdapter when you add column
• Bug fixes
  • #1181 Fix "Fatal: hasOption() on null" error
  • #1198 Fix chainability for the setColumns call