server/migrations/20160427103718-history.js

   1 'use strict';
   2
   3 module.exports = {
   4   up: function(queryInterface, Sequelize) {
   5     queryInterface.removeColumn('report_call_history', 'id');
   6     queryInterface.removeColumn('report_chat_history', 'id');
   7     queryInterface.removeColumn('report_chat_room_history', 'id');
   8     queryInterface.removeColumn('report_chat_session_history', 'id');
   9     queryInterface.removeColumn('report_mail_history', 'id');
  10     queryInterface.removeColumn('report_mail_room_history', 'id');
  11     queryInterface.removeColumn('report_mail_session_history', 'id');
  12     queryInterface.removeColumn('report_sms_history', 'id');
  13     queryInterface.removeColumn('report_sms_room_history', 'id');
  14     queryInterface.removeColumn('report_sms_session_history', 'id');
  15     queryInterface.removeColumn('report_square_details_history', 'id');
  16     queryInterface.removeColumn('report_square_history', 'id');
  17     queryInterface.removeColumn('report_transfer_history', 'id');
  18   },
  19
  20   down: function(queryInterface, Sequelize) {
  21     queryInterface.addColumn('report_call_history', 'id', Sequelize.INTEGER);
  22     queryInterface.addColumn('report_chat_history', 'id', Sequelize.INTEGER);
  23     queryInterface.addColumn('report_chat_room_history', 'id', Sequelize.INTEGER);
  24     queryInterface.addColumn('report_chat_session_history', 'id', Sequelize.INTEGER);
  25     queryInterface.addColumn('report_mail_history', 'id', Sequelize.INTEGER);
  26     queryInterface.addColumn('report_mail_room_history', 'id', Sequelize.INTEGER);
  27     queryInterface.addColumn('report_mail_session_history', 'id', Sequelize.INTEGER);
  28     queryInterface.addColumn('report_sms_history', 'id', Sequelize.INTEGER);
  29     queryInterface.addColumn('report_sms_room_history', 'id', Sequelize.INTEGER);
  30     queryInterface.addColumn('report_sms_session_history', 'id', Sequelize.INTEGER);
  31     queryInterface.addColumn('report_square_details_history', 'id', Sequelize.INTEGER);
  32     queryInterface.addColumn('report_square_history', 'id', Sequelize.INTEGER);
  33     queryInterface.addColumn('report_transfer_history', 'id', Sequelize.INTEGER);
  34   }
  35 };