server/migrations/20160627124640-voice_recording.js

   1 'use strict';
   2
   3 module.exports = {
   4   up: function(queryInterface, Sequelize) {
   5     queryInterface.sequelize.query('ALTER TABLE `voice_recordings` DROP PRIMARY KEY;');
   6     queryInterface.addColumn('voice_recordings', 'id', {
   7       type: Sequelize.INTEGER,
   8       autoIncrement: true,
   9       primaryKey: true
  10     });
  11   },
  12
  13   down: function(queryInterface, Sequelize) {
  14     queryInterface.sequelize.query('ALTER TABLE `voice_recordings` DROP PRIMARY KEY;');
  15     queryInterface.removeColumn('voice_recordings', 'id');
  16     queryInterface.changeColumn('voice_recordings', 'uniqueid', {
  17       type: Sequelize.STRING,
  18       primaryKey: true
  19     });
  20   }
  21 };