20170211214917-unnamed-migration.js 412 B

1234567891011121314151617
  1. 'use strict';
  2. module.exports = {
  3. up: function (queryInterface, Sequelize) {
  4. return queryInterface.changeColumn('users', 'username', {
  5. type: Sequelize.STRING,
  6. unique: true
  7. })
  8. },
  9. down: function (queryInterface, Sequelize) {
  10. sequelize.query(
  11. 'ALTER TABLE users DROP CONSTRAINT username_unique_idx;'
  12. );
  13. queryInterface.removeIndex('Users', 'username_unique_idx');
  14. }
  15. };