text: 'use strict';
  
  module.exports = {
    up: (queryInterface, Sequelize) => {
      /*
        Add altering commands here.
        Return a promise to correctly handle asynchronicity.
  
        Example:
        return queryInterface.createTable('users', { id: Sequelize.INTEGER });
      */
      return queryInterface.createTable('volume_failed_transaction_logs', {
        id: {
          type: Sequelize.INTEGER,
          primaryKey: true,
          autoIncrement: true,
        },
        customer_details_id: Sequelize.INTEGER,
        transaction_volume: Sequelize.DOUBLE(10,2),
        transaction_failed_percentage: Sequelize.DOUBLE(10,2),
        status: Sequelize.STRING,
        latest_alert_sent: Sequelize.STRING,
        createdAt: {
          type: Sequelize.DATE,
          defaultValue: Sequelize.fn('now'),
          allowNull : false,
        },
        updatedAt: {
          type: Sequelize.DATE,
          defaultValue: Sequelize.fn('now'),
          allowNull : false,
        }
      });
    },
  };
  