andela/team-odd-bn-backend

View on GitHub
src/database/migrations/20191203089313-modify-accommodations.js

Summary

Maintainability
A
50 mins
Test Coverage
'use strict';

module.exports = {
  up: (queryInterface, Sequelize) => {
    return queryInterface.addColumn(
      'accommodations',
      'userId',{
      type: Sequelize.INTEGER,
        onDelete: 'CASCADE',
        onUpdate: 'CASCADE',
        references: {
          model: 'users',
          key: 'id',
          as: 'userId',
        }
      }
    );
  },
  down: (queryInterface, Sequelize) => {
    return queryInterface.removeColumn('accommodations', 'userId');
  }
};