diff options
author | BoHong Li | 2017-03-28 15:16:09 +0800 |
---|---|---|
committer | BoHong Li | 2017-03-28 15:16:09 +0800 |
commit | e26bb0503f962e1ee56dfa138b43af4653065812 (patch) | |
tree | 32703ec0cb7ad9050e107da9d2dff60f59554f16 /lib/migrations/20160420180355-note-add-alias.js | |
parent | 6f14822413eeb43aae1298163699f87bc1ce11e7 (diff) |
fix: Support SQlite
Move 'unique' constraint to another statement (SQLite don't support set unique when addColumn)
Diffstat (limited to 'lib/migrations/20160420180355-note-add-alias.js')
-rw-r--r-- | lib/migrations/20160420180355-note-add-alias.js | 11 |
1 files changed, 8 insertions, 3 deletions
diff --git a/lib/migrations/20160420180355-note-add-alias.js b/lib/migrations/20160420180355-note-add-alias.js index 2c3e453b..a043cd5c 100644 --- a/lib/migrations/20160420180355-note-add-alias.js +++ b/lib/migrations/20160420180355-note-add-alias.js @@ -2,12 +2,17 @@ module.exports = { up: function (queryInterface, Sequelize) { return queryInterface.addColumn('Notes', 'alias', { - type: Sequelize.STRING, - unique: true + type: Sequelize.STRING + }).then(function () { + return queryInterface.addIndex('Notes', ['alias'], { + indicesType: 'UNIQUE' + }) }) }, down: function (queryInterface, Sequelize) { - return queryInterface.removeColumn('Notes', 'alias') + return queryInterface.removeColumn('Notes', 'alias').then(function () { + return queryInterface.removeIndex('Notes', ['alias']) + }) } } |