migration.query('ALTER TABLE voice_extensions DROP FOREIGN KEY voice_extensions_ibfk_7');
migration.query('ALTER TABLE voice_extensions DROP INDEX voice_extensions_ibfk_7');
migration.query('ALTER TABLE voice_extensions ADD CONSTRAINT voice_extensions_ibfk_7 FOREIGN KEY (VoicePrefixId) REFERENCES voice_prefixes(id) ON UPDATE CASCADE ON DELETE CASCADE');
- // END voice_extensions
+ // END voice_extensions
+
+ //START voice_queues
+ migration.addColumn('voice_queues', 'dialNoSuchNumberMaxRetry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 3
+ });
+ migration.addColumn('voice_queues', 'dialNoSuchNumberRetryFrequency', {
+ type: Sequelize.INTEGER,
+ defaultValue: 150
+ });
+
+ migration.addColumn('voice_queues', 'dialDropMaxRetry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 3
+ });
+ migration.addColumn('voice_queues', 'dialDropRetryFrequency', {
+ type: Sequelize.INTEGER,
+ defaultValue: 150
+ });
+
+ migration.addColumn('voice_queues', 'dialAbandonedMaxRetry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 3
+ });
+ migration.addColumn('voice_queues', 'dialAbandonedRetryFrequency', {
+ type: Sequelize.INTEGER,
+ defaultValue: 150
+ });
+
+ migration.addColumn('voice_queues', 'dialMachineMaxRetry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 3
+ });
+ migration.addColumn('voice_queues', 'dialMachineRetryFrequency', {
+ type: Sequelize.INTEGER,
+ defaultValue: 150
+ });
+
+ migration.addColumn('voice_queues', 'dialAgentRejectMaxRetry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 3
+ });
+ migration.addColumn('voice_queues', 'dialAgentRejectRetryFrequency', {
+ type: Sequelize.INTEGER,
+ defaultValue: 150
+ });
+ //END voice_queues
+
+ //START campaigns
+ migration.addColumn('campaigns', 'dialNoSuchNumberMaxRetry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 3
+ });
+ migration.addColumn('campaigns', 'dialNoSuchNumberRetryFrequency', {
+ type: Sequelize.INTEGER,
+ defaultValue: 150
+ });
+ migration.addColumn('campaigns', 'dialDropMaxRetry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 3
+ });
+ migration.addColumn('campaigns', 'dialDropRetryFrequency', {
+ type: Sequelize.INTEGER,
+ defaultValue: 150
+ });
+ migration.addColumn('campaigns', 'dialAbandonedMaxRetry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 3
+ });
+ migration.addColumn('campaigns', 'dialAbandonedRetryFrequency', {
+ type: Sequelize.INTEGER,
+ defaultValue: 150
+ });
+ migration.addColumn('campaigns', 'dialMachineMaxRetry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 3
+ });
+ migration.addColumn('campaigns', 'dialMachineRetryFrequency', {
+ type: Sequelize.INTEGER,
+ defaultValue: 150
+ });
+ migration.addColumn('campaigns', 'dialAgentRejectMaxRetry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 3
+ });
+ migration.addColumn('campaigns', 'dialAgentRejectRetryFrequency', {
+ type: Sequelize.INTEGER,
+ defaultValue: 150
+ });
+ //END campaigns
+
+ //START cm_hopper
+ migration.addColumn('cm_hopper', 'countnosuchnumberretry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 0
+ });
+ migration.addColumn('cm_hopper', 'countdropretry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 0
+ });
+ migration.addColumn('cm_hopper', 'countabandonedretry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 0
+ });
+ migration.addColumn('cm_hopper', 'countmachineretry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 0
+ });
+ migration.addColumn('cm_hopper', 'countagentrejectretry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 0
+ });
+ //END cm_hopper
+
+ //START cm_hopper_final
+ migration.addColumn('cm_hopper_final', 'countnosuchnumberretry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 0
+ });
+ migration.addColumn('cm_hopper_final', 'countdropretry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 0
+ });
+ migration.addColumn('cm_hopper_final', 'countabandonedretry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 0
+ });
+ migration.addColumn('cm_hopper_final', 'countmachineretry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 0
+ });
+ migration.addColumn('cm_hopper_final', 'countagentrejectretry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 0
+ });
+ //END cm_hopper_final
+
+ //START cm_hopper_history
+ migration.addColumn('cm_hopper_history', 'countnosuchnumberretry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 0
+ });
+ migration.addColumn('cm_hopper_history', 'countdropretry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 0
+ });
+ migration.addColumn('cm_hopper_history', 'countabandonedretry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 0
+ });
+ migration.addColumn('cm_hopper_history', 'countmachineretry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 0
+ });
+ migration.addColumn('cm_hopper_history', 'countagentrejectretry', {
+ type: Sequelize.INTEGER,
+ defaultValue: 0
+ });
+ //END cm_hopper_history
// START FINAL
migration.final(resolve);