0.16.2

Improvements

• Support MariaDB's CURRENT_TIMESTAMP format (5c6d3c7)

Documentation

• Remove --save from npm install command (ed932c9)

0.16.0

Breaking Changes

• feat!: Change the interface for how keys are defined in the table schema (8cab7ce)
  • Check out the new documentation on how to define table keys
• chore(ci)!: Update config and stop testing on Node 6 and 11 (56564e8)

New Features

• feat: Add support for FULLTEXT indexes (673fad7)
• feat: Add support for key prefix lengths (13e185d)

Improvements

• improvement: Don't run unnecessary DROP/ADD_FOREIGN_KEY operations (687df26)
• improvement: Improve error messages when creating ColumnDefinitions with improper arguments (fff463e)
• chore(deps): mysql@2.17.1 (6281eab)
• chore: Fix spelling - 'geometrical' -> 'geometry' (b88c815)

Documentation

• docs: Use clearer language in the readme intro (ceb11ca)

0.15.0

Breaking Changes

• Drop support for Node 4 (e1f25a9)
• ci: Stop testing on Node 9 (af9117f)

New Features

• deps: mysql@2.16.0 (e62a99a)
  • See mysql changes
• ci: Test on Node 10 (c4dfb02)

Bug Fixes

• fix: Run ADD COLUMN operations before MODIFY/CHANGE COLUMN operations (5e72c04)

Documentation

• doc: Add section for known migrations that will not work (0650b44)

0.14.0

Breaking Changes

• lib: Remove support for deprecated {__raw: ...} objects (739a293)

New Features

• PoolPlus: Add Promise support to pool.sync() (0704b40)

Performance

• lib: Use === where possible (9d31c23)

Documentation

• docs: Simplify initial example and use async-await (9987b43)
• docs: Avoid using pronouns where possible (913d92c)

0.13.1

Deprecations

• lib: Log a deprecation message when a {__raw: ...} object is used (ec00429)

Documentation

• docs: Add spatialIndexes to table of contents for Keys section (3a31e05)
• docs: Amend the deprecation plan for {__raw: ...} objects (774b9d3)

0.13.0

Deprecations

• lib: Remove {__raw: ...} object documentation (1ad76d0)
  • Use mysql.raw() or pool.raw() instead to create raw values
  • This is currently a soft deprecation. In v0.13.1, mysql-plus will log a warning if you use a {__raw: ...} object with the MySQLTable#insertIfNotExists() method and support for {__raw: ...} objects will be removed completely in v0.14.0.

New Features

• deps: mysql@2.15.0 (91ff662)
  • See mysql changes
• lib: Improve debug output formatting (a43815f)
• PoolPlus: Add .raw() method (f0779c9)
  • This is an alias of the mysql.raw() function added in mysql@2.15.0
• TableDefinition: Expand foreign key shorthand syntax (ccb3c53)
  • You can now specify the onDelete and onUpdate options in the shorthand like so: 'table.column CASCADE'

Misc

• ci: Test on Node 9 (6c44566)
• Rename 'LICENSE' -> 'LICENSE.txt' (5b588f8)

0.12.1

• lib: Fix debug formatting + improve foreign key operation formatting (9f714a7)

0.12.0

Notable Changes

• TableDefinition: When a column changes, update its position (3836d3b)
• lib: Replace lodash/isEmpty with a custom function (a2b68f9)
• lib: Replace lodash/cloneDeep with a custom function for cloning keys (73651c9)
• lib: Replace lodash/isEqual with a custom function for comparing key definitions (db32bec)
  • Lodash is no longer a dependency!
• lib: Change how debugging logs to the console and test debugging code (c9aacb2)
• deps: mysql@2.14.1 (adfb9b4)

0.11.1

Bug Fixes

• lib: Fix bug when migrating a table with foreign keys to having none (f9867da)

Misc

• Test on Node 8

0.11.0

Breaking Changes (that fix bugs)

• lib: Always drop keys not created by mysql-plus during migrations (6bfa2af)
  • This fixes a bug where syncing would throw an error when attempting to drop a key not created by mysql-plus.
• ColumnDefinitions: Define certain numeric types as synonyms (79c5acb)
  • This fixes a bug where using integer, dec, numeric, fixed, bool, or boolean would always cause the table to run unnecessary ALTER queries during migrations.
  • Feature: The bool and boolean ColType methods now return a NumericColumnDefinition instance.

New Features

• MySQLTable: Implement an .exists() method (a01e6fb)
• doc: Fix MySQLTable#insert() example with using only the sqlString argument (1da7a2a)