server/migrations/20160701160405-report_queue.js

   1 'use strict';
   2
   3 module.exports = {
   4   up: function(queryInterface, Sequelize) {
   5     queryInterface.addColumn('report_queue', 'assigned', {
   6       type: Sequelize.BOOLEAN,
   7       defaultValue: false
   8     });
   9     queryInterface.addColumn('report_queue', 'lastAssignedTo', {
  10       type: Sequelize.STRING
  11     });
  12     queryInterface.addColumn('report_queue_history', 'assigned', {
  13       type: Sequelize.BOOLEAN,
  14       defaultValue: false
  15     });
  16     queryInterface.addColumn('report_queue_history', 'lastAssignedTo', {
  17       type: Sequelize.STRING
  18     });
  19   },
  20
  21   down: function(queryInterface, Sequelize) {
  22     queryInterface.removeColumn('report_queue', 'assigned');
  23     queryInterface.removeColumn('report_queue', 'lastAssignedTo');
  24     queryInterface.removeColumn('report_queue_history', 'assigned');
  25     queryInterface.removeColumn('report_queue_history', 'lastAssignedTo');
  26   }
  27 };