--- /dev/null
+'use strict';
+
+module.exports = {
+ up: function (queryInterface, Sequelize) {
+ return queryInterface.sequelize.query('DELETE FROM voice_voicemail_messages WHERE mailboxuser NOT IN (SELECT mailbox FROM voice_voicemail)')
+ .then(function(){
+ 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;');
+ })
+ .catch(function(err){
+ console.error(err);
+ })
+ },
+
+ down: function (queryInterface, Sequelize) {
+ queryInterface.sequelize.query('ALTER TABLE voice_voicemail_messages DROP FOREIGN KEY voice_voicemail_messages_ibfk_1;');
+ }
+};