server/migrations/20180606172545-voicemail.js

   1 'use strict';
   2
   3 module.exports = {
   4   up: function (queryInterface, Sequelize) {
   5     return queryInterface.sequelize.query('DELETE FROM voice_voicemail_messages WHERE mailboxuser NOT IN (SELECT mailbox FROM voice_voicemail)')
   6     .then(function(){
   7       return queryInterface.sequelize.query('ALTER TABLE `voice_voicemail_messages` ADD CONSTRAINT `voice_voicemail_messages_ibfk_1` FOREIGN KEY (`mailboxuser`) REFERENCES voice_voicemail(`mailbox`) ON UPDATE CASCADE ON DELETE CASCADE;');
   8     })
   9     .catch(function(err){
  10       console.error(err);
  11     })
  12   },
  13
  14   down: function (queryInterface, Sequelize) {
  15     queryInterface.sequelize.query('ALTER TABLE voice_voicemail_messages DROP FOREIGN KEY voice_voicemail_messages_ibfk_1;');
  16   }
  17 };