Built motion from commit db94841.|2.5.3
[motion2.git] / server / migrations / 2.5.2.js
index 17894c1..0ec5ab4 100644 (file)
@@ -170,7 +170,166 @@ module.exports = {
             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);