0.10.1

Bug Fixes

• lib: Fix bug when migrating a table with no foreign keys to having some (fa8960b)

0.10.0

Possibly Breaking Changes

• feat: When new columns are added during migrations, add them in the same position that they are defined in the columns object (beddf36)
  • Only breaking if you directly test the result of SHOW CREATE TABLE after migrations
• PoolPlus: Make .defineTable() throw a TypeError (instead of Error) if name is not a string (b6489fe)
  • Mostly likely won't break anything

New Features

• PoolPlus: Add .basicTable() method that just creates a MySQLTable instance (2ca6e43)

0.9.0

Breaking Changes

• ColumnDefinitions: Make timestamp columns NULL by default (dfcd030)
  • See the TimestampColumnDefinition documentation for details

0.8.0

Possibly Breaking Changes

• MySQLTable: Simplify parsing arguments to .insert() and .update() (725cdfa)
  • Should not be a breaking change if you don't pass strings or numbers as the values parameter and you don't use undefined or null to fill in unused arguments (i.e. .insert({data}, undefined, undefined, callback))

New Features

• MySQLTable: Implement new .insertIfNotExists() method (1791688)
• MySQLTable: Allow .insert() to accept a string as the first parameter (f4c9d92)
• docs: Show generated SQL in MySQLTable query examples (785d853)

Bug Fixes

• MySQLTable: Fix bug in .insert() where sqlString was ignored if data was an array (55cc324)

0.7.0

Breaking Changes

• PoolPlus: Remove deprecation reminder error in constructor (d9c416f)

New Features

• deps: mysql@2.13.0 (9d95934)
• TableDefinition: Beautify CREATE TABLE statements to make debugging easier (40d93e1)
• lib: Make debugging section separators the same length (4d92886)

Bug Fixes

• lib: Combine all ALTER statements into a single statement before running the query (a92e330)
  • Fixes issues with migrating tables with an AUTO_INCREMENT column
• PoolPlus: Fix bug in debug mode where the .sync() callback would not get called (231e7ec)

0.6.3

New Features

• PoolPlus: Add debugging to #sync() and fix incorrect documentation (bdbce55)
• perf: Add fast path in diffKeys() for when either input is null (d3b66eb)

Bug Fixes

• lib: Fix bug when altering a multi-column index and the first column in that index has a foreign key (585b7dc)

0.6.2

Bug Fixes

• lib: Fix foreign key bug introduced in d43235a (03374e4)
• lib: Fix bug caused by columns with a default value (8f1e963)

0.6.1

New Features

• ColumnDefinitions: Add support for spatial data (geometry) and JSON column types (46f3034)
• lib: Support spatial indexes (9a4a2be)

0.6.0

Breaking Changes

• lib: Require the migrationStrategy and allowAlterInProduction options to be under a plusOptions config property (744e492)
• lib: Remove the deprecated Type namespace (3226971)
• MySQLTable: Remove the deprecated tableName instance property (db99fbf)
• MySQLTable: Remove the deprecated .insertIgnore() and .replace() methods (14aca60)
• ColumnDefinition: Remove deprecated .defaultRaw() method (709c6f8)
• ColumnDefinition: Remove deprecated handling of .default('CURRENT_TIMESTAMP') (ca1ace4)

New Features

• lib: Add debug config option (baf89ee)

Bug Fixes

• lib: Prevent error when changing columns or keys with foreign keys (d43235a)

0.5.0

Deprecations

• ColumnDefinition: Deprecate .defaultRaw() (ee10a0c)
  • Use .defaultCurrentTimestamp() instead when needed
• lib: Update deprecation warnings to say things will be removed in 0.6.0 (instead of 0.5.0) (3273395)

New features

• UpdatableTimeColumnDefinition: Add .defaultCurrentTimestamp() method (949d72f)