addColumn-with-fk-by-sequelize.js

module.exports = {
  up: function (queryInterface, Sequelize) {
    // raw query
    // add column and foreign key constrant
    var sql = "ALTER TABLE `Friend`" +
        "  ADD COLUMN `UserId` BIGINT(20) UNSIGNED DEFAULT NULL" +
        ", ADD CONSTRAINT `fkUserIdInFriend` FOREIGN KEY (`UserId`) REFERENCES `User` (`id`) ON UPDATE CASCADE ON DELETE RESTRICT";

    // run the query
    return queryInterface.sequelize.query(sql, {
      type: Sequelize.QueryTypes.RAW
    });
  },

  down: function (queryInterface, Sequelize) {
    var sql = "ALTER TABLE `Friend`" +
        "  DROP FOREIGN KEY `fkUserIdInFriend`, DROP COLUMN `UserId`";

    return queryInterface.sequelize.query(sql, {
      type: Sequelize.QueryTypes.RAW
    });
  }
};